单选题

Examine the following command:   SQL> ALTER TABLE booking SHRINK SPACE COMPACT;   Which activity is performed when the preceding command is executed?()

A The shrink operation touches every block in the BOOKING table

B The high-water mark (HWM) for the BOOKING table is shifted from its original position

C The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

D The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

正确答案

来源:www.examk.com

答案解析

相似试题
  • View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement?()

    单选题查看答案

  • View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to().

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • Exhibit: View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command?()

    多选题查看答案

  • View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

    单选题查看答案

  • View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident()

    单选题查看答案