OCP认证考试052最新考试题库解析-20180525

2018年OCP 052最新考试题库解析20180525
• • • • 9、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/SQL program unit 4. Results of executed queries and query fragments S. PL/SQL function 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:C
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 •
2018年OCP 052最新考试题库解析20180525
• 6、Which two are true about roles? • ❑ A) A role can be granted a combination of system and object privileges and other roles. • ❑ B) The CONNECT role Is granted automatically to a user when It Is created. • ❑ C) Roles are owned by SYSTEM. • ❑ D) The RESOURCE role Is granted the CREATE SESSION privilege. • ❑ E) A secure application role can be set only by Its associated PL/SQL package. • Answer:AE
•
• • • • • •
2018年OCP 052最新考试题库解析20180525
• • • • • • • • • • • • • • • • • • • • 10、Examine this LISTENER. ORA file: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (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 the existing LTRTENER with a different port number in LISTENER.ORA. ❑ B) Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it. ❑ C) Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER. ORA ❑ D) Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER. ORA Answer:D
2018年OCP 052最新考试题库解析20180525
• 7、USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2.SYS 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 will succeed but neither USER1 nor USER2 will be able to perform SELECT, 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 USER1.EMP). • Answer:D
2018年OCP 052最新考试题库解析20180525
• 8、Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? • ❑ A) Its findings are accessible only by using Oracle Enterprise Manager. • ❑ B) It improves database performance by automatically implementing Oracle's best practices. • ❑ C) It can assist the DBA in diagnosing database instance startup failures. • ❑ D) It can be used by executing the PL/SQL procedures in the DBMS_ADDM package. • ❑ E) It runs automatically after each Automatic Workload Repository snapshot is created. • ❑ F) It provides recommendations to improve database performance. • Answer:DEF
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
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