单选题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

第1题：

第2题：

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.

第3题：

In which scenario will you perform a user-managed incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、when a table is dropped and purged from the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when you are required to view all the versions of a row of an existing table between a specific time period

第4题：

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 ago
• B、 when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
• C、 when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
• D、 when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
• E、 never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

第5题：

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）.

第6题：

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；

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

IBE（Internet Booking Engine）

第14题：

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 INSERT
• B、 Unconditional INSERT
• C、 Conditional ALL INSERT
• D、 Conditional FIRST INSERT

第15题：

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

第16题：

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.

第17题：

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.

第18题：

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：