单项选择题
The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table？（）
A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
B. Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE command
C. Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE command
D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
相关考题
-
单项选择题
The following command is executed to create the baseline template: Which statement is true about the effect of the above command?（）
A. It creates a baseline template that never expires.
B. It produces an error because no snapshot information is provided to create the baseline.
C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period. -
多项选择题
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session. -
单项选择题
The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBAs intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations
