Database Reference
In-Depth Information
Review Questions
1.
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
A.
It must be used because all RMAN-related backup and recovery metadata infor-
mation is contained in it.
B.
It provides a convenient, optional, repository of backup- and recovery-related
metadata.
C.
It provides the ability to store RMAN scripts for global use by any database that
has access to the repository.
D.
It provides a means of storing all RMAN backup sets physically in an Oracle
Database server.
E.
It provides the ability to store backup records for more than a year.
2.
What privileges must be granted to allow an account to create the recovery catalog?
(Choose all that apply.)
A.
RECOVERY_CATALOG_OWNER
B.
DBA
C.
RESOURCE
D.
SELECT ANY DICTIONARY
E.
CONNECT
3.
Which command do you use to create a recovery catalog schema?
A.
CREATE RECOVERY CATALOG
B.
CREATE CATALOG
C.
BUILD CATALOG
D.
CATALOG CREATE
E.
MOUNT CATALOG
4.
If you back up a database without connecting to the recovery catalog, which operations
will cause the recovery catalog to be updated? (Choose all that apply.)
A.
The next time you back up the database when you are also connected to the recovery
catalog and the target database
B.
The next time you are connected to the target database and the recovery catalog
database and issue the
RESYNC
command
C.
The next time you connect RMAN to just the recovery catalog
D.
The next time you connect to the recovery catalog and the target database
with RMAN
E.
Connecting to the recovery catalog and issuing the
RESYNC ALL DATABASES
command
Search WWH ::
Custom Search