What is a consideration when specifying DATA CAPTURE CHANGES? A. Can be specified for capturing changes to an XML object. B. To minimize logging, specify NOT LOGGED when DATA CAPTURE CHANGES is specified. C. REFRESH TABLE statement is not allowed…

What trace class will show deadlock information? A. Audit class 3. B. Statistic class 3. C. Accounting class 1. D. Performance class 8.

Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space and the number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB parameter. Which statement about the value of…

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE? A. Filter factor information. B. Stage 1 and stage 2 information. C. Number of columns used in an index. D. Number of times…

If a single row of the PLAN_TABLE has a ‘Y’ value in more than one of the sort composite columns, what is indicated? A. The next sort step will perform two sorts. B. There are multiple sorts in the plan…