多项选择题
A. All the related indexes and views are automatically dropped
B. The flashback drop feature can recover only the table structure
C. Only the related indexes are dropped whereas views are invalidated
D. The flashback drop feature can recover both the table structure and its data
单项选择题 Examine the following command： SQL> ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）
单项选择题 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？（）