Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Ibm Discussions
exam questions

Exam C2090-600 All Questions

View all questions & answers for the C2090-600 exam
Go to Exam

Exam C2090-600 topic 1 question 18 discussion

Actual exam question from IBM's C2090-600
Question #: 18
Topic #: 1
[All C2090-600 Questions]

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 AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
  • B. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND INDEXES ALL;
  • C. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
  • D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by db2tester at Oct. 9, 2019, 4:13 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
JamesBond
3 years, 4 months ago
B is correct
upvoted 1 times
...
db2tester
5 years, 1 month ago
The answer A is wrong. Indeed, the commands "REORG TABLE sales AND INDEXES ALL" and "RUNSTATS ON TABLE sales AND INDEXES ALL;" are syntactically wrong. The correct answer is B.
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel