单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()A The data in the segment will be compacted but t

题目
单选题
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
A

The data in the segment will be compacted but the high water mark will not be adjusted 

B

The EMPLOYEES table will be changed to read-only mode during the shrink operation 

C

The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

D

The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

E

Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


相似考题