单项选择题
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
相关考题
-
单项选择题
Youwanttodisableresumablespaceallocationforallsessions.WhichvalueshouldbeassignedtotheRESUMABLE_TIMEOUTparametertodisableresumablespaceallocationforallsessions？（）
A.0
B.10
C.100
D.NULL -
单项选择题
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database -
单项选择题
TheDatabaseResourceManagerisautomaticallyenabledinthemaintenancewindowthatrunstheAutomatedMaintenanceTask.Whatisthereasonforthis？（）
A. to prevent the creation of an excessive number of scheduler job classes
B. to allow the Automated Maintenance Tasks to use system resources without any restriction
C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
