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