单项选择题
A.The index tablespace contains bitmap indexes.
B.The index tablespace contains more than one data file.
C.The index tablespace supports only complete recovery.
D.The index tablespace is not a dictionarymanaged tablespace.
E.There is a dependency relationship between a table and its indexes.
单项选择题 In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member?()
单项选择题 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?()