OracleOCP052最新考试题库解析-.docx

2018 年 OCP 052 最新考试题库解析 -20180525
题库新特点：
更加灵活，题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理： CUUG
1、 Which two events always request the LGWR to write?
A) when LGWR is notified by a server process that performs a Commit or ROLLBACK
B) When PMON restarts a server process
C) when DBWn writes dirty buffers
D) when a log switch occurs
E) when a checkpoint occurs
?Answer:CD
2、 Examine these commands and their output:
SQL> SELECT * FROM emp;
ENO ENAME
---- -----
100 Adam
101 Alan
SQL> INSERT INTO emp VALUES(102,'Ben");
1 row created.
SQL> COMMIT;
Commit completed.
SQL> UPDATE emp SET ename='Bryan' WHERE eno=102;
1 row updated.
A power failure occurs. The Instance Is restarted and this query Is executed.
SQL> SELECT ename FROM emp;
What Is the outcome?
A) Only Adam and Alan are displayed.
B) Only Adam, Alan, and Bryan are displayed.
C) Adam, Alan, Ben, and Bryan are displayed.
D) No rows are returned.
E) Only Adam, Alan, and Ben are displayed. ?Answer:E
3、 Where Is backup metadata stored for use by Recovery Manager (RMAN)?
A) In the control file
B) In the SYSAUX tablespace
C) in the SPFILE
D) in the SYSTEM tablespace
E) In the diagnostic destination flies ?Answer:A
4