CUUG内部OCP题库解析-052-文档3
17页1、CUUG内部OCP题库解析-052-文档3题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。下面的题是(052考试-第3个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档3 7/17/19 1、Which two events always request the LGWR to write? A) when LGWR is notified by a server process that performsa 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:CDAdministrator CUUG内部OCP题库解析-052-文档3 7/17/1
2、9 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) N
3、o rows are returned. E) Only Adam, Alan, and Ben are displayed.AdminAisntrsawtoer r:E CUUG内部OCP题库解析-052-文档3 7/17/19 3、Where Is backup metadata stored for use by RecoveryManager (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:AAdministrator CUUG内部OCP题库解析-052-文档3 7/17/19 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 I
4、f required? A) control files B) password file C) pfile D) online redo logs E) flashback logs F) data files Answer:AFAdministrator CUUG内部OCP题库解析-052-文档3 7/17/195、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:BEAdministrator CUUG内部OCP题库解析-052-文档3 7/17/196、Which two are true about roles? A) A role can be granted a combination of system and object
《CUUG内部OCP题库解析-052-文档3》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-052-文档3》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页