[单选]
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

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（） Shut down the database。 Clear the online redo log。 Back up the database。 Checkpoint the database。 Call Oracle support。生态适宜度 The Business Partner technical specialist is called to check if the addition of host ports on an IBM System Storage DS8000 system has improved users’ response times for an IBM System p server running SAP. How can the improvement be verified（） check the output of the vmstat command on AIX。 check the performance reports via TotalStorage Productivity Center for Data。 check the performance reports via TotalStorage Productivity Center for Disk。 check the improvement through the TotalStorage Expert report。 The operator needs to execute a long-running shell script. How can the script be executed so the operator does not have to wait until it is complete to access the command prompt?（） ./script.ksh。 nohup ./script.ksh。 run -b ./script.ksh。 ./script.ksh > nohup.out。标签的粘贴和更换必须由（）单位进行。气瓶检验；。气瓶充装；。气瓶使用；。气瓶监察。

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？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：OCP 11G认证考试题库

相关题目: