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
OCP考试052最新考试题库原题-3-20180525-
