单选题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
单选题
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
参考解析
解析：
暂无解析
相关考题：
The walk－up rate at a hotel is the price charged to a customer who arrives without a reservation.It's usually about 30% less expensive than the online booking rate.() 此题为判断题(对，错)。
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 data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?() A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
Which statement is true about a forwarding table?() A.It stores a subset of information from the routing table.B.It contains routes learned from all protocols to a destination.C.It provides a database for routes selected and placed into the routing table.D.Every routing protocol maintains its own forwarding table.
Which statement is true about a forwarding table?（）A、It stores a subset of information from the routing table.B、It contains routes learned from all protocols to a destination.C、It provides a database for routes selected and placed into the routing table.D、Every routing protocol maintains its own forwarding table.
The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）A、 Pivoting INSERTB、 Unconditional INSERTC、 Conditional ALL INSERTD、 Conditional FIRST INSERT
In which scenario will you perform a user-managed incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
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
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；A、 when the schema of the user， SCOTT， was deleted by mistake 15 minutes agoB、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes agoC、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes agoD、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutesE、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）A、 It remains valid.B、 It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C、 It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D、 It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）A、Perform point-in-time recovery to 2： 00 p.m.B、Use Flashback Table feature to revert the changes.C、Restore the entire database from the recent backup and open it.D、Issue the rollback statement with system change number （SCN）.
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）A、EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B、ALTER TABLE … COALESCE ；C、ALTER INDEX …REBUILD ONLINE；D、CREATE TABLE …AS SELECT_ONLINE；
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
单选题Which statement is true about a forwarding table?（）AIt stores a subset of information from the routing table.BIt contains routes learned from all protocols to a destination.CIt provides a database for routes selected and placed into the routing table.DEvery routing protocol maintains its own forwarding table.
单选题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
单选题A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）A It remains valid.B It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.C It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.D It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
单选题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?（）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
单选题An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）AEXPORT with TABLES and IMPORT with the INDEX and IGNORE options.BALTER TABLE … COALESCE ；CALTER INDEX …REBUILD ONLINE；DCREATE TABLE …AS SELECT_ONLINE；
单选题In which scenario will you perform a user-managed incomplete recovery？（）A when a table is dropped and stored in the Recycle BinBwhen a table is dropped and purged from the Recycle BinC when you are required to recover an existing table to its previous stateD when you are required to view all the versions of a row of an existing table between a specific time period
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A The dependent materialized view should have a complete refresh performed after the online table redefinition process.B Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C Referential integrity constraints must be manually enabled after the online table redefinition process.D The materialized log should be dropped before the online table redefinition process.
单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A when all the online redo log groups are multiplexed and one of the members of a group is missingB when all the online redo log groups are not multiplexed and one log group is missingC when all the control files are missingD when some important tables are deleted from the database and purged from the Recycle Bin
单选题The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）A Pivoting INSERTB Unconditional INSERTC Conditional ALL INSERTD Conditional FIRST INSERT
单选题You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）APerform point-in-time recovery to 2： 00 p.m.BUse Flashback Table feature to revert the changes.CRestore the entire database from the recent backup and open it.DIssue the rollback statement with system change number （SCN）.