76.
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 called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose
all that apply.)
- A.rman target=/ catalog=/@rcat
- B.rman target=/ catalog=rcat_own/rcat_own
- C.rman target=/ catalog=rcat_own/rcat_own@RCAT
- D.rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
- E.You cannot connect to the target database and the recovery catalog at the same time.
- Answer & Explanation
- Report
Answer : [C, D]
Explanation :
Explanation :
| Options C and D show the correct format for the RMAN command line. Option C connects to the database locally, while option D connects through Oracle Net. Both methods are completely legal. |
77.
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;}
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 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 &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 datafiles.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The script will prompt for the missing substitution variable. The script will return an error if you do not put in a value for the second substitution variable. |
78.
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 & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| The RVPC user can register database if they are granted the register database privilege. They can also see all recovery-catalog database metadata to which they are granted access. |
79.
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 & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| To give the RVPC user rights to specific databases, you must connect to the recovery catalog with RMAN. You then grant those rights to that user from the RMAN prompt using the grant command. |
80.
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.
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.
- A.a, b, c, d, e
- B.b, a, d, c, e
- C.b, c, d, a, e
- D.b, c, d, e, a
- E.b, d, c, a, e
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You would first create the recovery catalog database. Then you create the recovery catalog user, granting that user the RECOVERY_CATALOG_OWNER role. You then issue the create catalog command from RMAN, which will create the recovery-catalog schema. Finally, you connect to the target database and register the database with the register database command. |
|
|
||||||||||||||||||||||||||||
