单项选择题
A. Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
B. Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
C. Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
多项选择题 Youlostadatafilethatbelongstoanindextablespaceinyourdatabase，whichoperatesinARCHIVELOGmode.Lossofthedatafileresultedinincreasedresponsetimeonyourqueries.Whichtwooptionswouldyouusetosolvethisproblem？（）
多项选择题 Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
单项选择题 YouneedtochecktheEMP_EASTpartitionintheEMPLOYEEStableforphysicalcorruptions.Youalsoneedtoverifythattherowsbelongtothecorrectpartition.Whichoptioncouldyouuse？（）