INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第1题:
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
第2题:
For which of the following can you use Segment Shrink?()
第3题:
You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment ortablespacetype What could be the reason?()
第4题:
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?()
第5题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第6题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第7题:
The data in the segment will be compacted but the high water mark will not be adjusted
The EMPLOYEES table will be changed to read-only mode during the shrink operation
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
第8题:
Reclaims space above and below the high-water mark without using additional space
Moves rows to a new physical location,resetting the high-water mark,but uses additional space during the operation
Deallocates space above the high-water mark that is currently not in use
None of the above
第9题:
You must enable the row movement on the SCOTT.EMP table.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
第10题:
You must enable the block change tracking feature.
You must have enable the flashback feature.
You must use the OMF in your database.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
第11题:
The EMPLOYEES table will be changed to read-only mode during the shrink operation.
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
第12题:
INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第13题:
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?()
第14题:
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()
第15题:
Which of the following options describes Segment Shrink?()
第16题:
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
第17题:
The table is partitioned
The table name is wrong.
It is an index-Organized table (IOT)
The table is stored in locally managedtablespace.
The table is stored in atablespacewhere segment space is managed manually.
第18题:
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第19题:
The shrink operation touches every block in the BOOKING table
The high-water mark (HWM) for the BOOKING table is shifted from its original position
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
第20题:
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
You cannot shrink the SCOTT.EMP table.
第21题:
Heap tables
Tables with function-based indexes
Indexes
Partitions and subpartitions
None of the above
第22题:
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
It may advise the use of online table redefinition for tables in locally managed tablespaces
It will detect and advise about chained rows.
It may advise the use of segment shrink for free list managed tables.
第23题:
add data files to the tablespace
identify the segments that you should shrink
modify the storage parameters for the tablespace
automatically shrink the segments with unused space
check the alerts generated for the tablespace that is running low on space
第24题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE