You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

A、 You must enable the block change tracking feature.

B、 You must have enable the flashback feature.

C、 You must use the OMF in your database.

D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

相关问题推荐

• You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

  A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.

  B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.

  C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.

  D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.

  查看答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A

   The DBWn process writes to the datafile.

  B

   Changes in the background process are recorded.

  C

   The log file is updated with the current SCN number.

  D

   The System Change Number （SCN） is recorded in the control file.

  E

   The changes to the listener configuration in the listener.ora file are recorded.

  查看答案

• You have issued the following command：    RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS；   What will be the result of using the above command？（）

  A、 The backup metadata will be maintained in the control file for 100 days.

  B、 The backup metadata will be maintained in the recovery catalog for 100 days.

  C、 The backup metadata will be maintained in the flash recovery area for 100 days.

  D、 After 100 days， the backup sets and image copies will be deleted from the media.

  查看答案

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A、 MMAN

  B、 PMON

  C、 MMON

  D、 MMNL

  查看答案

• In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）

  A

  The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

  B

  The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

  C

  The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

  D

  If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

  E

  If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看答案