A query on the sales table returned the following error:
Tue May 11 07:05:40 2004
Some indexes or index [sub]partitions of table
SCOTT. SALES have been marked unusable.
Which statement caused this error to be returned when you issued the query?
A.
DELETE FROM sales;
B.
UPDATE sales SET prod_status=’sold’ WHERE prod_cat=’pens’;
C.
ALTER TABLE sales MOVE PARTITIONsal_ql TABLESPACE EXAMPLE;
D.
ALTER TABLE sales MOVE PARTITION sal_q1 TABLESPACE EXAMPLE UPDATE INDEXES;
Explanation:
The statement ALTER TABLE sales MOVE PARTITION sal_q1 TABLESPACE EXAMPLE, won’t have a UPADATE INDEXES clause. By default, many table maintenance operations on partitioned tables invalidate (mark UNUSABLE) the corresponding indexes or index partitions. You must then rebuild the entire index or, in the case of a global index, each of its partitions. The database lets you override this default behavior if you specify UPDATE INDEXES in your ALTER TABLE statement
for the maintenance operation. Specifying this clause tells the database to update the index at the time it executes the maintenance operation DDL statement.REF: Oracle(r) 10g Administrator Guide, 17-24