Oracle認(rèn)證考試章節(jié)練習(xí)(2019.12.21)

You issued the following command to analyze the SCOTT.EMP table for block corruption：  
ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：  
ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）  
How will you resolve the block corruption problem？（）

Examine the following command used to perform incremental level 0 backup：  
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；  
To enable the block change tracking， after the incremental level 0 backup you issued the following command：  
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：  
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；  
Which two statements are true in the above situation？（）

A team of programmers is involved in reviewing a proposed design for a new utility class. After some discussion， they realize that the current design allows other classes to access methods in the utility class that should be accessible only to methods within the utility class itself.
What design issue has the team discovered？（）

Evaluate this SQL statement:
SELECT ename, sal, 12*sal+100
FROM emp;
The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）