多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题