1z0-043單項(xiàng)選擇題每日一練(2019.01.19)

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： 
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？（）

You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200.  
The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：  
SQL>UPDATE EMPLOYEE  SET SALARY = 2000  
WHERE EMPNO = ’E0025’；  
SQL>COMMIT；  
On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：  
SQL>UPDATE EMPLOYEE  SET SALARY = 2400  
WHERE EMPNO = ’E0025’； 
 SQL>COMMIT；  
On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’  
SQL>UPDATE EMPLOYEE  SET SALARY = 2900  
WHERE EMPNO = ’E0025’；  
SQL>COMMIT；  
On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：  
SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；  
Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）