单项选择题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）

A.EXECUTE_CATALOG_ROLE
B.CONNECT
C.RESOURCE
D.RECOVERY_CATALOG_OWNER
E.RECOVERY_CATALOG_USER

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which of the following files cannot be cataloged using the CATALOG command？（）

A.Data files
B.Control files
C.Archived log files
D.Files storing RMAN scripts

点击查看答案
2.单项选择题To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

A.OPEN
B.MOUNT
C.NOMOUNT
D.CLOSE

点击查看答案
3.单项选择题

Using the command shown here， what time format must you specify to recover the database until a point-in-time？（） 
SQL> RECOVER DATABASE UNTIL TIME ’<time format>’；

A.YYYY-DD-MM:HH24:SS:MI 
B.YYYY-DD-MM:HH24:SS:MM 
C.YYYY-MM-DD:HH24:MI:SS 
D.YYYY-DD-MM:SS:MI:HH24

点击查看答案
4.单项选择题Which of the following statements is NOT true about RMAN？（）

A.It improves usability by enabling you to reuse the scripts to perform recovery operations.
B.It detects block corruption while restoration and recovery operations.
C.It enables you to perform block media recovery.
D.It is capable to recover through unrecoverable operations， with only full database backups.

点击查看答案
5.单项选择题Which of the following would you use to enable automatic media recovery for a database？（）

A.SET AUTORECOVERY ON
B.SET RECOVERY ON
C.SET AUTO ON
D.You cannot enable automatic media recovery.

点击查看答案
6.单项选择题Which of the following shut down options should not be used before performing a consistent whole database backup？（）

A.NORMAL
B.TRANSACTIONAL
C.ABORT
D.IMMEDIATE
E.INCONSISTENT

点击查看答案
7.单项选择题Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）

A.RESTORE
B.RECOVER
C.REPORT
D.BACKUP

点击查看答案
8.单项选择题What is the maximum number of ARCn processes that can be defined using the initialization parameter LOG_ARCHIVE_MAX_PROCESSES？（）

A.1
B.5
C.10
D.15
E.Depends on system memory resources

点击查看答案
9.单项选择题Which background process is responsible for writing the dirty buffers from the write list to the data files during a checkpoint？（）

A.CKPT
B.SMON
C.LGWR
D.DBWn
E.ARCn

点击查看答案
10.单项选择题Which of the following statement is incorrect regarding RMAN？（）

A.It detects corrupt blocks.
B.It performs only offline database backups.
C.It omits empty blocks during backups.
D.It performs tablespace point-in-time recovery （TSPITR）.

点击查看答案

最新试题

Which Oracle background process frees SGA resources that were allocated to a user process that failed？（）

题型：单项选择题

Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）

题型：单项选择题

Which of the following commands must be issued to remove a stored script from the recovery catalog？（）

题型：单项选择题

What is the maximum database block size supported for the Oracle9i database？（）

题型：单项选择题

Which of the following roles must be granted to a user to perform a full database import？（）

题型：单项选择题

Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）

题型：单项选择题

Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）

题型：单项选择题

Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）

题型：单项选择题

Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands？（）

题型：单项选择题

Which of the following packages maintains information in the recovery catalog？ （）

题型：单项选择题