试题详情
- 单项选择题 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
- B
关注下方微信公众号，在线模考后查看
热门试题
- Which statemen
- YouareworkingonaCATD
- The database&e
- 以下关于ORACLE数据块的叙述正确的是
- A general purpose M
- 在命令行中启动SQL*Plus，使用如下
- You work
- Given： 1
- Click the
- The instance&#
- Oracle 11g是基于（）的。
- Given: Whichthreear
- Your archive-l
- You are using the co
- Which operator can b
- Given: Whatistheres
- Data file&ensp
- Given： What is
- You have not configu
- The transporta