- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
31.
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 & Explanation
- Report
Answer : [B,C,E]
Explanation :
Explanation :
| The recovery catalog provides a means of storing metadata related to a database’s RMAN backup and recovery operations. Additionally, it provides the ability to store scripts that can be used by any database connecting to the repository via RMAN. Finally, the recovery catalog provides the means to store backup records for longer than a year. |
32.
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 & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The RECOVERY_CATALOG_OWNER privilege is required to create the recovery catalog. The DBA privilege includes RESOURCE and CONNECT and will work, but this role has many additional privileges that are unneeded. SELECT ANY DICTIONARY is not required. |
33.
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 & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Use the CREATE CATALOG command to create the recovery catalog schema. |
34.
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 & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| Anytime you execute an RMAN backup operation when connected to the recovery catalog, RMAN will automatically resynchronize the recovery catalog metadata with the database control file. The RESYNC command is used to manually resynchronize the recovery catalog with the database. |
35.
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 & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| You would use the EXECUTE SCRIPT RMAN command, contained within a RUN block, to execute the backup_database script. |
|
|
||||||||||||||||||||||||||||
