Exam C2090-600 topic 1 question 8 discussion

Actual exam question from IBM's C2090-600

Question #: 8
Topic #: 1

[All C2090-600 Questions]

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 INPLACE RESETDICTIONARY
B. REORG TABLE sales INPLACE REBUILDDICTIONARY
C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Show Suggested Answer

Suggested Answer: C 🗳️

by caliiorb at Oct. 16, 2019, 9:41 p.m.

Comments

Submit Cancel

TeranceCambel

3 years, 4 months ago

Correct Answer is C. ALLOW WRITE ACCESS . Allows write access to the table during reorganization. This behavior is the default.https://www.ibm.com/docs/en/db2/11.5?topic=commands-reorg-table#sdx-synid_allow_write_access

upvoted 1 times

...

Shubhranshu

5 years, 2 months ago

Correct Answer is C, with inplace we can't specify RESETDICTIONARY. Command in option A will give error when executed

upvoted 1 times

...

db2tester

5 years, 6 months ago

The clause "REBUILDDICTIONARY" does not exist. The answer B and D are note correct.

upvoted 1 times

...

caliiorb

5 years, 7 months ago

The correct answer is A, the inplace option Rearranges the table while allowing user access. And the RESETDICTIONARY option if the COMPRESS attribute of the table is YES, a new row compression dictionary is constructed. https://www.ibm.com/support/knowledgecenter/es/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001966.html

upvoted 1 times

...