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 EMPLOYEES table will be changed to read-only mode during the shrink operation.
- B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
- C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
- D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
正确答案:C
答案解析:有
微信扫一扫手机做题