单项选择题
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
相关考题
-
单项选择题
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command -
单项选择题
You observed the following output for a user session: What do you infer from the preceding output?（）
A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
D. The threshold warning limit is exceeded for the tablespace that is used by the user session -
单项选择题
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
