1Z0-040 Oracle Database 10g: New Features for Administrators Training Boot Camp

Oracle ™

1Z0-040 Oracle Database 10g: New Features for Administrators

Note 1: 1Z0-040 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 1Z0-040 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 8.

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;

Display Answer

Purchase Full Version:

1Z0-040 Printable PDF Prep Guide $49.95 BUY NOW!

1Z0-040 Test Simulation Engine $69.95 BUY NOW!

1Z0-040 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: C 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

Explanation: