《CUUG内部OCP题库解析-052-文档3》由会员分享，可在线阅读，更多相关《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
2、 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/19 2、Examine these commands and their output: SQL SELECT * FROM emp; ENO ENAME - - 100 Adam 101 Alan
3、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 displ
4、ayed. 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.AdminAisntrsawtoer r:E CUUG内部OCP题库解析-052-文档3 7/17/19 3、Where Is backup metadata stored for use by RecoveryManager (RMAN)? A) In the contr
5、ol 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
6、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 b
7、uffer 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 objectprivileges and other roles. B) The CONNECT role Is granted automatically to a userwhen It Is created
8、. C) Roles are owned by SYSTEM. D) The RESOURCE role Is granted the CREATE SESSIONprivilege. E) A secure application role can be set only by Its associatedPL/SQL package. Answer:AEAdministrator CUUG内部OCP题库解析-052-文档3 7/17/197、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2.S
9、YS executes this command:SQL REVOKE UPDATE ON user1.emp FROM user1;What will be the outcome? A) It will succeed and only USER2 will be unable to perform SELECT,INSERT, Or UPDATE on USER1. EMU. B) It will succeed and only USER1 will be unable to perform SELECT,INSERT, Or UPDATE on USER1. EMP. C) It w
10、ill succeed but neither USER1 nor USER2 will be able to performSELECT, INSERT, or UPDATE on USER1. EMP. 0 D) It will fall because USER1 Is the owner of USER1. EMP. E) It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1. EMP, but both will be able to query US
11、ER1. EMP). Answer:DAdministrator CUUG内部OCP题库解析-052-文档3 7/17/198、Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? A) Its findings are accessible only by using Oracle EnterpriseManager. B) It improves database performance by automaticallyimplementing Oracles best practices.
12、 C) It can assist the DBA in diagnosing database instancestartup failures. D) It can be used by executing the PL/SQL procedures in theDBMS_ADDM package. E) It runs automatically after each Automatic WorkloadRepository snapshot is created. F) It provides recommendations to improve databaseperformance
13、. Answer:DEFAdministrator CUUG内部OCP题库解析-052-文档3 7/17/199、Examine these components: 1. Execution plan for a non-embedded SQL statement 2. Local, global, and package variables for a session 3. Execution plan for a SQL statement contained In a PL/SQLprogram unit 4. Results of executed queries and query
14、 fragments S. PL/SQLfunction result sets Which of these are stored in the shared SQL area? A) 1 and 4 B) 1, 2 and 3 C) 1 and 3 D) 1, 3, 4, and 5 Answer:CAdministrator CUUG内部OCP题库解析-052-文档3 7/17/19 10、Examine this LISTENER. ORA file: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDR
15、ESS = (PROTOCOL = TCP) (HOST = )(PORT = 1522) ) ) ) SID LIST LISTENER = (SID LIST = (SID_DESC = (GLOBAL_DBNAME = ) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = orcl) ) ) How should you configure an additional listener LISTENER2 that listens for the same SID? A) Add relevant details In DESCRTPTION under
