Database Reference
In-Depth Information
7.
How would you grant the RVPC user access to specific RMAN database records in the
RMAN virtual private catalog?
A.
Issue the
GRANT
command from the
SYS
user (or equivalent) of the target database.
B.
Issue the
GRANT
command from the
SYS
user (or equivalent) of the recovery catalog
database.
C.
Issue the
GRANT
command from the recovery catalog-owning schema user account
in the recovery catalog.
D.
Issue the
GRANT
command from RMAN when connected to the recovery catalog-
owning schema.
E.
Issue the
GRANT
command from RMAN when connected to the target database.
8.
The RVPC user can do which of the following? (Choose all that apply.)
A.
Register databases if granted the
register database
privilege.
B.
See all databases in the recovery catalog schema.
C.
See all database-related metadata in the recovery catalog if they are granted access
to that database.
D.
Unregister databases from the RVPC catalog that were not granted to the RVPC
catalog owner with the
GRANT
command.
E.
Connect to RMAN using the command-line CATALOG parameter for backup or
recovery purposes.
9.
Given the script
create script db_backup_datafile_script
{backup datafile &1, &2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}
A.
The script will fail since you instructed RMAN to back up only one data file
rather than two.
B.
The script will successfully back up datafile 3 without error.
C.
The script will fail since it uses a substitution variable, which is not supported.
D.
The
EXECUTE SCRIPT
command will prompt for the value of
&2
since it's not
included in the command.
E.
The script will fail because you cannot use the
PLUS ARCHIVELOG
command when
backing up database data files.
Search WWH ::
Custom Search