ocp认证考试052最新考试题库解析.pptx

2018年OCP 052最新考试题库解析-20180525
题库新特点：
 更加灵活，题库的顺序与考试时的顺序每场都在变化
 更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案
 
整理：CUUG
1
精选ppt
2018年OCP 052最新考试题库解析-20180525
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
精选ppt
2018年OCP 052最新考试题库解析-20180525
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
精选ppt
2018年OCP 052最新考试题库解析-20180525
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
精选ppt
2018年OCP 052最新考试题库解析-20180525
4、Which two can be backed up by using RMAN when a database Is open in ARCHIVELOG mode, so that media recovery can be performed If required?
❑ A) control files
❑ B) password file
❑ C) pfile
❑ D) online redo logs
❑ E) flashback logs
❑ F) data files
Answer:AF
5
精选ppt
2018年OCP 052最新考试题库解析-20180525
5、Your database is using Automatic Memory Management.
Which two SGA components must be managed manually?
❑ A) default buffer cache
❑ B) redo log buffer
❑ C) large pool
❑ D) shared pool
❑ E) keep buffer pool
Answer:BE
6
精选ppt
2018年OCP 052最新考试题库解析-20180525
6、Which two are true about roles?
❑ A) A role can