随笔分类 -  Segment Shrink

摘要：The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST an 阅读全文

摘要：View the exhibit and examine the TRANS table's storage information. After a massive deleteoperation, you executed the following statement to shrink th 阅读全文

摘要：Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The 阅读全文

摘要：Why does the number of blocks for the table remain the sale after the shrink operation?A.Because the table did not contain migrated or chained rows B. 阅读全文

摘要：When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?A. INC 阅读全文

摘要：For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partiti 阅读全文

摘要：Which of the following options describes Segment Shrink?A. Reclaims space above and below the high-water mark without using additional spaceB. Moves r 阅读全文