单项选择题
A.import the database from the last export
B.restore all the members in the group from the last backup
C.drop the lost member from the database, and then add a new member to the group
D.restore all the database files from the backup, and then perform a complete recovery
E.restore all the database files from the backup, and then perform an incomplete recovery
单项选择题 A user executes a query on the EMP table, which contains thousands of rows, to get details about employees in one of the departments. The user receives the following error: SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal SELECT ename FROM emp WHERE deptno=10 ORDER BY sal * ERROR at line 1: ORA01157: cannot identify/lock data file 201 see DBWR trace file ORA01110: data file 201: ’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason?()
多项选择题 Lastnight,amediafailurecausedthelossofatemporaryfilethatbelongstoyourdatabase.Whichtwothingsmayhappenthismorningwhenyoutrytoopenyourdatabase?()
单项选择题 Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces,youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting?()