QUESTION 400
You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secure01.dbf' SIZE 150M
ENCRYPTION USING '3DES168' DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the
EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome?
A. It creates the table and encrypts the data in it. B. It generates an error because the wallet is closed. C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Answer: B Section: (none)
QUESTION 401
Which command is used to configure RMAN to perform a compressed backup for every backup executed?
A. BACKUP AS COMPRESSED BACKUPSET DATABASE B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS E. BACKUP DATABASE COMPRESS
Answer: C Section: (none)
QUESTION 402
You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?
A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those
backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database. E. RMAN will automatically compress backups.
Answer: B Section: (none)
QUESTION 403
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 information 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.
Answer: BCE Section: (none)
QUESTION 404
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
Answer: AC Section: (none)
Explanation/Reference:
QUESTION 405
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
Answer: B Section: (none)
QUESTION 406
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
Answer: AB Section: (none)
QUESTION 407
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?
A. run { open script backup_database; run script backup_database } B. run { engage script backup_database; } C. run { run script backup_database; } D. Run { execute script backup_database; }
E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN
would result in an error.
Answer: D Section: (none)
QUESTION 408
In what order would you execute the following steps to create a recovery catalog?
A. Issue the create catalog command. B. Create the recovery-catalog database. C. Create the recovery-catalog user.
D. Grant the recovery_catalog_owner privilege to the recovery-catalog user. E. Issue the register database command from the target database. F. a, b, c, d, e G. b, a, d, c, e H. b, c, d, a, e I. b, c, d, e, a J. b, d, c, a, e
Answer: C Section: (none)
Explanation/Reference:
QUESTION 409
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.
Answer: D Section: (none)
QUESTION 410
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. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
Answer: AC Section: (none)
QUESTION 411 Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 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 datafile 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 and2 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 datafiles.
Answer: D Section: (none)
Explanation/Reference:
QUESTION 412
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is