2024年OCP 052最新考试题库解析-20240518
题库新特点：
更加灵活，题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案 整理：CUUG
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) to recover a database ? Answer:A
5、Which two affect the time taken for instance recovery? ? A) size of redo logs
? B) size of UNDO tablespace
? C) FAST_START_MTTR_TARGET value ? D) size of archivelogs
? E) size of existing RMAN backupsets ? F) UNDO_RETENTION value ? Answer:AC
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select the \Which task is performed by OUI as part of this installation?
? A) creation and configuration of Enterprise Manager Cloud Control on the server ? B) creation of privileged operating system groups that are used for OS authentication ? C) creation of a general purpose database
? D) creation of an ASM disk group and registration of ASM components with Oracle Restart ? Answer:D
7、Which is true about external tables?
? A) The ORACLE_DATAPUMP access driver can be used to write data to external tables. ? B) Segments are allocated for external tables. ? C) They do not support partitioning. ? D) They may have Indexes.
? E) DML operations may be performed on external tables. ? Answer:C
8、Which two are true about the Fast Recovery Area (FRA)? ? A) It should be larger than the database.
? B) Space management In the FRA Is Influenced by the database backup retention policy. ? C) A database must be in ARCHIVELOG mode to use the FRA.
? D) It must reside on the same file system as the database data files. ? E) Only consistent backups can be stored in the FRA. ? Answer:AB
9、Which is true about the Automatic Diagnostic Repository (ADR)?
? A) It includes diagnostic data for critical errors for each server and background process. ? B) Its location is always set by the ORACLE_BASE variable.
? C) It is used only if the DIAGNOSTIC_DEST parameter is manually configured. ? D) It only contains the alert log and trace files for background processes. ? Answer:A
10、Which two are true about consistent database backups?
? A) They can only be taken when a RECOVERY CATALOG is used. ? B) They can only be taken if the database Is in ARCHIVELOG mode.
? C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened. ? D) They can only be taken by using RMAN commands.
? E) They can only be taken by using RMAN when the database is in MOUNT state. ? Answer:CE
11、Which three are true about UNDO data? ? ? A) It is used to roll back failed transactions.
? ? B) It is used to rewind a database by using FLASHBACK DATABASE. ? ? C) It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP.
? ? D) It is used to enable ROLLBACK statements to roll back uncommitted updates. ? ? E) It is used to provide read consistency.
? ? F) It is used during online backups to guarantee their consistency. ? Answer:ADE
12、Which two types of Information can be found in the alert log? ? ? A) instance recovery details
? ? B) a record of all DDL statements performed by non-DBA users ? ? C) a record of all actions performed by SYS and SYSTEM ? ? D) critical errors encountered by background processes
? ? E) values of all Initialization parameters whenever an Instance Is restarted ? Answer:AD
13、Which two are true about AWR snapshots? ? ? A) They are stored In the SYSAUX tablespace.
? ? B) They are not generated if STATISTICS_LEVEL Is set to TYPICAL. ? ? C) They can be modified by using DMLs. ? ? D) They can be retained forever.
? ? E) They are always created automatically. ? Answer:AD
14、Which command is used to display files that no longer conform to the backup retention policy?
? ? A) REPORT OBSOLETE
? ? B) SHOW DATAFILE BACKUP COPIES ? ? C) CROSSCHECK BACKUP ? ? D) LIST EXPIRED BACKUP ? Answer:A
? 15、Which two are true about space management in tablespaces?
? ? A) Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other.
? ? B) Locally managed tablespaces track adjacent free space automatically by using bitmaps. ? ? C) Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces.
? ? D) ASSM tablespaces prevent row chaining.
? ? E) Free lists are used for managing free space for segments in locally managed tablespaces. ? Answer:AB
Oracle OCP 052最新考试题库解析-20240518
