Which Oracle background&#8...

单项选择题Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）

A.PMON
B.SMON
C.LGWR
D.CKRT

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords？（）

A.Wallet Manager
B.Radius
C.Oracle Internet Directory
D.None of the above

点击查看答案

2.单项选择题Which of the following roles must be granted to a user to perform a full database import？（）

A.CONNECT
B.IMP_FULL_DATABASE
C.FULL_EXPORT_PRIVS
D.RESOURCE
E.FULL_IMPORT_PRIVS

点击查看答案

3.单项选择题Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）

A.INDEXES
B.SKIP_INDEXES_MAINTENANCE
C.SKIP_UNUSABLE_INDEXES
D.RESUMABLE
E.INDEXES_UNUSABLE

点击查看答案

4.单项选择题Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）

A.IGNORE=Y
B.DIRECT=Y
C.CONSISTENT=Y
D.BUFFER=Y

点击查看答案

5.单项选择题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

点击查看答案

6.单项选择题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

点击查看答案

7.单项选择题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

点击查看答案

8.单项选择题 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

点击查看答案

9.单项选择题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.

点击查看答案

10.单项选择题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.

点击查看答案