单选题Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A The shrink operation touches every block in the BOOKING tableB The high-water mark （HWM） for the BOOKING table is shifted from its original positionC The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题
Examine the following command： SQL> ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）
A
The shrink operation touches every block in the BOOKING table
B
The high-water mark （HWM） for the BOOKING table is shifted from its original position
C
The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D
The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
参考解析
解析：
暂无解析
相关考题：
View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
Examine the following command:SQL ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?() A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positionC. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D、 You cannot shrink the SCOTT.EMP table.
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？（）A、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE
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、 INCLUDING DEPENDENCIESB、 INCLUDING DEPENDENCIES CASCADEC、 COMPACTD、 CASCADEE、 None of the above
Examine the following command： SQL ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）A、 The shrink operation touches every block in the BOOKING tableB、 The high-water mark （HWM） for the BOOKING table is shifted from its original positionC、 The progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableD、 The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）A、The corresponding indexes for the table are also truncated.B、Delete triggers on the table are fired during the execution of the TRUNCATE command.C、The child table is truncated when the TRUNCATE command is applied on the parent table.D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.E、No undo or very little undo data is generated during the execution of the TRUNCATE command
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？（）A、The table is partitionedB、The table name is wrong.C、It is an index-Organized table （IOT）D、The table is stored in locally managedtablespace.E、The table is stored in atablespacewhere segment space is managed manually.
Which of the following options describes Segment Shrink？（） A、 Reclaims space above and below the high-water mark without using additional spaceB、 Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operationC、 Deallocates space above the high-water mark that is currently not in useD、 None of the above
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 sequentiallyB、Shrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE commandC、Move the BOOKINGS table to a different location by using the ALTER TABLE MOVE commandD、Deallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
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?（）A、The EMPLOYEES table will be changed to read-only mode during the shrink operation.B、The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C、The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D、Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
单选题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？（）APerform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentiallyBShrink the BOOKINGS table by using the ALTER TABLE SHRINK SPACE commandCMove the BOOKINGS table to a different location by using the ALTER TABLE MOVE commandDDeallocate the space in the BOOKINGS table by using the ALTER TABLE DEALLOCATE UNUSED command
单选题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？（）AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table （IOT）DThe table is stored in locally managedtablespace.EThe table is stored in atablespacewhere segment space is managed manually.
单选题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？（）A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT orROLLBACK command， user B executes the following command on the TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user A is rolled back.C The ALTER TABLE command waits indefinitely until user A ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
单选题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?（）AThe data in the segment will be compacted but the high water mark will not be adjusted BThe EMPLOYEES table will be changed to read-only mode during the shrink operation CThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overDThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation EData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
单选题Which of the following options describes Segment Shrink？（）A Reclaims space above and below the high-water mark without using additional spaceB Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operationC Deallocates space above the high-water mark that is currently not in useD None of the above
单选题Examine the following command: SQL ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）AThe shrink operation touches every block in the BOOKING tableBThe high-water mark (HWM) for the BOOKING table is shifted from its original positionCThe progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableDThe data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
单选题You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）A The tablespace， DATA1， is not read-only.B The tablespace， DATA1， is not autoextensible.C The tablespace， DATA1， is not offline.D The segment space management for the tablespace， DATA1， is manual.
单选题You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15） ） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D You cannot shrink the SCOTT.EMP table.
单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）A You must enable the row movement on the SCOTT.EMP table.B You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark （HWM） is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
单选题You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）AImmediately following statement execution BAfter the ALTER TABLE DROP UNUSED COLUMNS command is issued CAfter the ALTER TABLE SET UNUSED COLUMN command is issued DAfter the ALTER TABLE MODIFY command is issued
单选题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?（）AThe EMPLOYEES table will be changed to read-only mode during the shrink operation.BThe indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.CThe shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.DData manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
单选题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 INCLUDING DEPENDENCIESB INCLUDING DEPENDENCIES CASCADEC COMPACTD CASCADEE None of the above
单选题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？（）AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE