OCP-1Z0-053-200题-69题-646

QUESTION 69

View the exhibit and examine the TRANS table's storage information.

After a massive delete operation, you executed the following statement to shrink the TRANS table:

SQL> ALTER TABLE trans SHRINK SPACE CASCADE;

Which statement describes the outcome of the command?

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the

table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table

remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation

language (DML) triggers on the table are fired during the shrinking process

Answer: B

同646题：http://blog.csdn.net/rlhua/article/details/13772715

Explanation/Reference:

Section: SQL, PL/SQL, Packages, Functions, Jobs & Views

Exhibit Reference:1Z0-043, 10g OCP, Question 9 of 163

CASCADE:

If you specify CASCADE, then Oracle Database performs the same operations on all dependent objects of

table, including secondary indexes on index-organized tables.

The CASCADE clause extends the segment shrink operationto all dependent segments of the object. For

example, if you specify CASCADE when shrinking a table segment, all indexes of the table will also be shrunk.

(You need not specify CASCADE to shrink the partitions of a partitioned table.) To see a list of dependent

segments of a given object, you can run the OBJECT_DEPENDENT_SEGMENTSprocedure of the DBMS_SPACE

package.