Oracle IZ0-053 Q277(Table shrink space)
277.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
Answer: B
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
Answer: B
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2057650/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle] Shrink space & Table move比較Oracle
- Oracle 10g Shrink Table - Shrink Space 收縮空間Oracle 10g
- Oracle 11g alter table move與shrink spaceOracle
- oracle 10g__alter table shrink space compactOracle 10g
- ALTER TABLE MOVE | SHRINK SPACE區別
- ALTER TABLE MOVE和SHRINK SPACE區別
- oracle shrink tableOracle
- alter table move 和 alter table shrink space的區別
- alter table move 與shrink space的區別
- alter table move跟shrink space的區別
- alter table move跟shrink space的區別(轉)
- Oracle中shrink space命令詳解Oracle
- oracle10g shrink space 降低HWMOracle
- Oracle ASM Free Space TableOracleASM
- Oracle OCP IZ0-053 Q432(Segment Shrink)Oracle
- oracle10g_alter table shrink space_compact_cascade回收空間測試(一)Oracle
- Oracle 10g Shrink Table 詳解Oracle 10g
- shrink space的最佳實踐
- Oracle中shrink space命令詳解[轉]--還示測試Oracle
- 7 、shrink table and its dependent segments
- Oracle OCP 1Z0 053 Q96(Shrink Space Compact)Oracle
- table move 與 shrink 的區別
- oracle shrinkOracle
- How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINKOracle 10g
- 測試alter table shrink space compact cascade及學習user_tables相關列的含義
- 頑固TABLEのtable-layout/white-space
- shrink space 的整個過程就是在做delete和insertdelete
- [重慶思莊每日技術分享]-在為表新增了列後執行ALTER TABLE SHRINK SPACE 提示ORA-8102
- How to Shrink Undo Segment In Oracle DatabaseOracleDatabase
- 壓縮table and index 對 space 的影響testIndex
- Oracle DBMS_SPACEOracle
- HOW TO SHRINK A TABLE USING ONLINE REDEFINITION (文件 ID 1357878.1)
- 轉載-oracle Shrink命令的使用Oracle
- SQL查詢table或index異常增長問題 - space_usage (show_space)SQLIndex
- Oralcle 10g資料庫做shrink space操作建立了大量redo日誌資料庫
- Oracle-Segment space managementOracle
- Oracle IZ0-053 Q327Oracle
- oracle 分割槽表進行shrink操作Oracle