1、052 题 库 解 析OCP 考试 052 最新考试题库原题-5-20180608题库新特点： 更加灵活，题库的顺序与考试时的顺序每场都在变化 更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案 不断有新的考题出现，目前最新已经更新到 130 道题1、Which three are true about undo segments and undo tablespaces in the same database and instance? A. Multiple transactions run by the same Oracle user canshare a single
2、undo segment. B. Multiple transactions run by different Oracle users canshare a single undo segment. C. A serial transaction can use multiple undo segments. D. Undo segments are automatically dropped shortly aftertransactions that use them commit. E. A new undo segment is always created for each tra
3、nsaction. F. A database can have multiple undo tablespaces. Correct Answer: ABF2、Which two are true about the Data Recovery Advisor? A. It can be used only for databases that are running inARCHIVELOG mode. B. It can be used when the database is closed. C. It can be used to validate database recovery
4、 strategies. D. It provides intelligent database problem analysis. E. It can be used to validate database backup strategies. F. It can be used only for databases with FLASHBACK enabled. Correct Answer: CD3、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2? A. If the director
5、y used in the export operation has existingdump files, it overwrites them. B. It allows encryption to be performed without using apassword. C. It supports the renaming of tables during import. D. It supports the export of specific views as tables. E. It allows compression levels to be defined for th
6、e export. Correct Answer: BE4、F or your ORCL database.1. The instance is started using an spfile.2. The database is opened.3. It is in ARCHIVELOG mode.4. CONTROL FILE AUTOBACKUP IS ON.Examine this command:RMAN backup as copy datafile users01.dbf ,example01.dbf ; Which four files are backed up? A. sp
7、file B. undo01.dbf C. users01.dbf D. archivelogs E. sysaux01.dbf F. control file G. system01.dbf H. example01.dbf Correct Answer: ACFH5、 When does an incremental checkpoint occur? A. when DBWn writes dirty buffers as part of its normal process B. when the alter system checkpoint statement is execute
8、d. C. when a user tablespace is taken offline D. when an online redo log switch occurs Correct Answer: A6、 Examine this query and its output:Which two are true? A. The blocked session is waiting on a shared table lock. B. The blocked session is waiting on an enqueue. C. The blocking session is waiting on a row-level lock. D. Session 105 is blocked by session 15. E. Session 105 is blocking session 15. Correct Answer: BD 7、 In one of your databases:1. USER1 and USER2 have no system privileges.2. ROLE1 only has these privileges:* create session* create table * create viewExamine these commands:
