OCP052最新考试题库（考试原题）

1、052题库解析最新15道题052-题库解析-3-题库新特点：l 更加灵活，题库的顺序与考试时的顺序每场都在变化l 更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案l 不断有新的考题出现，目前最新已经更新到130道题每周五晚8点-直播地址：/course/ocp考试讨论群： 验证：ocpCUUG整理，官网： 1、Which two events always request the LGWR to write? A) when LGWR is notified by a server process that performsa Commi

2、t 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 SELECT * FROM emp; ENO NAME - - 100 Adam 101 Alan SQL INSERT INTO emp VALUES(102,Ben); 1 row created

3、. 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.

4、 C) Adam, Alan, Ben, and Bryan are displayed. D) No rows are returned. E) Only Adam, Alan, and Ben are displayed. Answer:E 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 di

5、agnostic 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:AF5、Your database is u

6、sing 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:BE6、Which two are true about roles? A) A role can be granted a combination of system and objectprivileges and other r

7、oles. B) The CONNECT role Is granted automatically to a userwhen It Is created. 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:AE7、USER1 grants SELECT, INSERT, and UPDATE

8、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,INSER

9、T, Or UPDATE on USER1. EMP. C) It will 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

10、, but both will be able to query USER1. EMP). Answer:D8、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. C) It c

11、an 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. Answer

12、:DEF9、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 fragments S. PL/SQLfunction result sets Which of t

13、hese 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 L

14、IST = (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 differ

15、ent portnumber 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 inLISTE

16、NER. ORA Answer:D11、Your database Is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST Is set to Fast Recovery Area (FRA) and it Is 100% fullwhen a log switch takes place. No alternative or optional archive destinations are defined. What Is the outcome? A) All active sessions are disconnected and their tran

17、sactions rolled back. B) The archivelog entries are made in the diagnostic destination andwhen space Is available, new archivelogs are generated. C) No archivelogs are generated. D) Obsolete backups are automatically deleted and new archivelogs aregenerated. E) All active sessions hang until the dat

18、abase administrator (DBA) makesspace available In the FRA. Answer:E12、Which two are true about data dictionary views? A) ALL or USER prefixed views display output that aresubsets of the output from the DBA prefixed data views. B) DBA prefixed views are accessible when a database is Inmount state. C)

19、 A user may not necessarily be the owner of all objectsthat can be viewed by using the ALL prefixed views. D) A user can query the DBA prefixed views only if they havethe SYSDBA privilege E) All data dictionary views are prefixed with DBA. Or ALL orUSER Answer:AD13、USER1. EMP has a referential Integ

20、rity constraint defined on EMP. DNO that references USER1. DEPT. DNO. user1 executes these commands: SQL UPDATE dept SET 1oc=UK where dno=1; 1 row updated SQL UPDATE emp SET sal=1000 whore eno=100; 1 row updated SQL ALTER TABLE dept DROP(dno); What will be the outcome and why? A) It will fail becaus

21、e a referential Integrity constraint Is defined on USER1. EMP. B) It will fall because there Is an uncommitted transaction on USER1. EMP. C) It will fail because there is an uncommitted transaction on USER1. DEPT. D) It will execute successfully and drop DEPT. DNO. E) It will execute successfully and drop the DEPT. DNO and EMP. DNO columns. Answer:A14、Which two are true about undo tablespa