单项选择题
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
单项选择题 Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows： RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb； } Which statement is true about the duplicate database in this scenario？（）
多项选择题 ThedatabaseisconfiguredinARCHIVELOGmodeandregularcompletedatabasebackupsaretaken.ThelossofwhichtwotypesoffilesmayrequirearecoverywiththeRESETLOGSoption？（）
单项选择题 Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query： SQL> SELECT * FROM sales； Which process would retrieve the result from the database and return it to the client program？（）