IBM DB2 11.1 DBA for LUW - C2090-600 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

A. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL; B. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales; C. RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL; D. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;

Discussion 0

Correct Answer: D Vote an answer

Question 2

If the following SQL statements are executed:

How many rows will be added to the DEPARTMENT table?

A. 3 B. 2 C. 1 D. 4

Discussion 0

Correct Answer: D Vote an answer

Question 3

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The INTRA_PARALLEL database manager configuration parameter is set to NO. B. The DFT_EXTENT_SZ database configuration parameter is set to 8. C. The AUTO_REORG database configuration parameter is set to NO. D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN. E. The PAGESIZE database configuration parameter is set to 32K.

Discussion 0

Correct Answer: A,D Vote an answer

Question 4

Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

A. UPDATE DB CFG USING CF LOCK_SZ AUTOMATIC B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90 D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Discussion 0

Correct Answer: C Vote an answer

Question 5

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

A. Using or altering the default service classes and workloads B. Creating service classes, service subclasses, and workloads C. Creating, using, or altering thresholds D. Granting, altering, or revoking workload privileges E. Creating, activating, stopping or dropping workload management event monitors

Discussion 0

Correct Answer: B,D Vote an answer

Question 6

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

A. db2cluster -cfs -displayconfig -filesystem datafs B. db2cluster -cfs -list -filesystem datafs C. db2cluster -cfs -display -filesystem datafs D. db2cluster -cfs -listconfig -filesystem datafs

Discussion 0

Correct Answer: B Vote an answer