ITPub博客

14、Which command is used to display files that no longer conform to the backup retention policy?A) REPORT OBSOLETEB) SHOW DATAFILE BACKUP COPIESC) CROSSCHECK BACKUPD) LIST EXPIRED BACKUPAnswer:A北京CU

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

12、Which two types of Information can be found in the alert log?A) instance recovery detailsB) a record of all DDL statements performed by non-DBA usersC) a record of all actions performed by SYS and

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 F

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 ta

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_

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 mu

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 partition

6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Wh

5、Which two affect the time taken for instance recovery?A) size of redo logsB) size of UNDO tablespaceC) FAST_START_MTTR_TARGET valueD) size of archivelogsE) size of existing RMAN backupsetsF) UNDO_RE

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 memoryB) acc

3、Which structure can span multiple data files?A) a permanent tablespaceB) a bigfile tablespaceC) a temporary tablespaceD) a segmentE) an extentAnswer:ACD北京CUUG整理，转载请注册

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

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 archiv