C2090-600 by IBM Valid Free Exam Practice Test

Question 1

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

A. REORG TABLE sales IN PLACE RESETDICTIONARY B. REORG TABLE sales INPLACE REBUILDDICTIONARY C. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY D. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

Correct Answer: D

Question 2

What levels of authority are needed to create a storage group? (Choose two.)

A. SYSADM B. SYSCTRL C. SQLADM D. DBADM E. SYSMAINT

Correct Answer: A,B

Question 3

Which of the following are all valid types of trigger?

A. AFTER, ATOMIC, INSTEAD OF B. ATOMIC, BEFORE, INSTEAD OF C. AFTER, ATOMIC, BEFORE D. AFTER, BEFORE, INSTEAD OF

Correct Answer: D

Question 4

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

A. ALTER TABLE tab1 APPEND ON B. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL C. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1 D. ALTER TABLE tab1 DROP COLUMN col1 E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

Correct Answer: B,D

Question 5

What is an advantage of using range partitioned tables?

A. Increased query performance through data partition elimination B. Block indexes are much smaller than RID indexes, providing better performance C. Table data is automatically and continuously clustered, requiring minimal reorganization D. Ability to run utilities against the partitions in parallel

Correct Answer: A

Question 6

Which statement about the db2move command is TRUE?

A. Loading data into tables containing XML columns is only supported for the LOAD actions. B. The LOAD actions can be run from a client machine. C. Object ownership cannot be changed after a successful schema copy operation. D. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

Correct Answer: A

IBM DB2 11.1 DBA for LUW - C2090-600 Exam Practice Test