PrepAway - Latest Free Exam Questions & Answers

Which action should be taken?

Click the Exhibit button.

100,000 new rows have been added to a fact table called ORDERS that currently contains one million
rows. The ORDERS table contains a primary key constraint on the order_id column and a secondary
index on column store_id.
It has been determined that the ORDERS table and its corresponding indexes should be reorganized.
Which action should be taken?

PrepAway - Latest Free Exam Questions & Answers

A.
Issue a mxci reload command on the orders table.

B.
Issue fup reload commands on all physical files that implement the orders table.

C.
Issue a mxci reorganize command on the orders table and also on the table two corresponding
indexes. Issue a mxci reorganize command on the orders table and also on the table? two
corresponding indexes.

D.
Issue fup reload commands on all physical files that implement the orders table and
corresponding indexes.


Leave a Reply