OCP考试052必威体育精装版考试题库原题-2-20180518.pdf

052 题库解析 OCP 考试 052 必威体育精装版考试题库原题 -2 题库新特点： 更加灵活，题库的顺序与考试时的顺序每场都在变化 更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案 不断有新的考题出现，目前必威体育精装版已经更新到 130 道题 1、.Which two are true about the Archive (ARCn) processes? ? A) They automatically delete obsolete archive logs to make space for new archive logs. ? B) They are used during Instance recovery. ? C) They archive redo directly from the redo log buffer. ? D) They are enabled only when the database Is In ARCHTVELOC mode. ? E) They create archivelogs after every log switch. ? Answer:DE 2 、Which two are true about Optimizer Statistics? ? A) They do not persist across Instance restarts. ? B) They are automatically updated when DDL statements execute. ? C) They are gathered by the Manageability Monitor (MMON) background process. ? D) They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package. ? E) They can be used to determine the events on which a database instance waited. ? F) They provide Information to the Optimizer so that it can determine optimal execution plans for SQL statements. ? Answer:DF 3 、Which structure can span multiple data files? ? A) a permanent tablespace ? B) a bigfile tablespace ? C) a temporary tablespace ? D) a segment ? E) an extent ? Answer:ACD 4 、For which requirement should you configure shared servers? ? A) accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory ? B) accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory ? C) submitting backup jobs at regular, 24-hour Intervals in an OLTP environment with limited memory ? D) performing bulk-load operations in a DSS environment with limited memory ? E) using Recovery Manager (RMAN)