可学答题网 > 问答 > OCP 11G认证考试题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The BOOKINGS table contains online bo


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
参考答案
参考解析:
分类:OCP 11G认证考试题库
相关推荐

1、The EMP table contains these columns:

The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL ...

2、The EMP table contains these columns:

The EMP table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)DEPARTMENT_ID NUMBER (6)You need to display the employees who have ...

3、TABLE style="WORD-BREAK: break-all" bo

TABLE style="WORD-BREAK: break-all" border=0 width=650>通电螺旋管旁的小磁针静止如图所示,判断正确的是(  )A.螺旋管a端为N极,电源C端为正极B.螺旋管a端为S极,...

4、The EMP table contains these columns:

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statem...

5、TABLE style="WORD-BREAK: break-all" bo

TABLE style="WORD-BREAK: break-all" border=0 cellSpacing=0 width=650>关于磁体、磁场和磁感线,以下说法中正确的是A铁和铝都能够被磁体吸引B磁体之间的相互作用是通过...

6、TABLE style="WORD-BREAK: break-all" bo

TABLE style="WORD-BREAK: break-all" border=0 cellSpacing=0 width=650>如图,小磁针处于静止状态(黑色部分为N极),由此可以判定A,B两个磁极的极性是AA为S极,B为N极B...