单项选择题
A. You must recover all data files to the required system change number （SCN）.
B. You must recover all data files， except those that are offline， to the required SCN.
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace.
单项选择题 Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organized（IOT）.YouwanttocreateabitmapindexontheJOD_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
多项选择题 In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE； Which two operations do you need to perform after restoring the control file from backup？（）
单项选择题 Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1； 3> ALTER DATABASE MOUNT； 4> RESTORE DATABASE； 5> RECOVER DATABASE； 6> ALTER DATABASE OPEN RESETLOGS； 7> }； With reference to this scenario， which statement is true？（）
