OCP最新考试题库解析之052考试原题-3-20180525

1、052题库解析,最新15道题 052-题库解析-3-20180525,题库新特点：, 更加灵活，题库的顺序与考试时的顺序每场都在变化, 更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案, 不断有新的考题出现，目前最新已经更新到130道题 每周五晚8点-直播地址： ocp考试讨论群：836361015 验证：ocp 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

2、 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

3、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、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、Your dat

4、abase 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、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

5、application role can be set only by Its associated PL/SQL package. Answer:AE,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 w

6、ill 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,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 O

7、racles 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,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 SQ

8、L 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, ,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/produ

9、ct/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,11、Your database Is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST Is set to Fast Recovery Area (FRA) and it Is 10

《OCP最新考试题库解析之052考试原题-3-20180525》由会员j***分享，可在线阅读，更多相关《OCP最新考试题库解析之052考试原题-3-20180525》请在金锄头文库上搜索。