单项选择题
A. The new setting would be applied but no alerts would be raised immediately.
B. The new setting would be applied and an alert would be raised immediately.
C. The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
D. The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
单项选择题 Exhibit： Using Database Control， you have scheduled a job to shrink the TRANStable residing on the TTtablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
单项选择题 You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
单项选择题 A user executes a query on the EMPtable， 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： ORA-01157： cannot identify/lock data file 201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’ What is a possible reason？（）