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?

Which condition must be met so that the optimizer can choose to completely bypass a table and
cover the query through index-only access?

What does the MXANCHOR file contain on the local node?

Which is not a valid component of a CREATE TRIGGER statement?

In which type of tables or files can referential integrity be enforced?

Which parameter of the FUP RELOAD command controls the resources used by the load?

Which CONTROL statement forces an access plan?

Which object can MEASCOM output not be directed to?

Which CONTROL QUERY DEFAULT INSERT_VSBB parameter is used for simple inserts?

During an online reorganization of a table, when are other processes prevented from reading and
writing to the table being reorganized?