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

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

题库新特点：

 更加灵活，题库的顺序与考试时的顺序每场都在变化  更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案  不断有新的考题出现，目前最新已经更新到130道题

• 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> SELECT * FROM emp; • ENO NAME • ---- ----- • 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

• 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 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: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 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 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

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

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

• 10、Examine this LISTENER. ORA file: • LISTENER = •

(DESCRIPTION_LIST = • (DESCRIPTION = • (ADDRESS_LIST =

• (ADDRESS = (PROTOCOL = TCP) (HOST = srvl.example.com)(PORT = 1522)) • ) ) ) • SID LIST LISTENER = • (SID LIST =

• (SID_DESC =

• (GLOBAL_DBNAME = orcl.example.com) • (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

11、Your database Is open in ARCHIVELOG mode.

• LOG_ARCHIVE_DEST Is set to Fast Recovery Area (FRA) and it Is 100% full

when 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 transactions rolled back. • ❑ B) The archivelog entries are made in the diagnostic destination and

when space Is available, new archivelogs are generated. • ❑ C) No archivelogs are generated.

• ❑ D) Obsolete backups are automatically deleted and new archivelogs are

generated.

• ❑ E) All active sessions hang until the database administrator (DBA) makes

space available In the FRA. • Answer:E

12、Which two are true about data dictionary views?

• ❑ A) ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views.

• ❑ B) DBA prefixed views are accessible when a database is In

mount state.

• ❑ C) A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views.

• ❑ D) A user can query the DBA prefixed views only if they have

the SYSDBA privilege

• ❑ E) All data dictionary views are prefixed with DBA. Or ALL or

USER • Answer:AD

13、USER1. EMP has a referential Integrity 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 because 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:A

14、Which two are true about undo tablespaces?

• ❑ A) They always retain undo for the time period defined by UNDO_RETENTION.

• ❑ B) They must have only one data file.

• ❑ C) They can be recovered only when an Instance Is In MOUNT state.

• ❑ D) Tables can be created In undo tablespaces by SYS. • ❑ E) Single-Instance databases can have only one active undo

tablespace. • Answer:CE

15、Which four are true about the tools used to administer Oracle databases?

• ❑ A) SQL*Plus can be used to create databases.

• ❑ B) RMAN can be used to start up Oracle Instances. • ❑ C) DBCA can be used to upgrade databases.

• ❑ D) The Data Pump utility can be used to load data from text files.

• ❑ E) SQL*Plus can be used to start up Oracle instances. • ❑ F) SRVCTL can be used to shut down Oracle instances. • Answer:ABEF