A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第1题:
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
第2题:
What RMAN command must you use before you can back up a database using the recovery catalog?()
第3题:
You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL> CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts; Which command should you issue next?()
第4题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第5题:
Which command do you use to create a recovery-catalog schema? ()
第6题:
To create and execute an RMAN stored script,you must use a recovery catalog.
When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.
RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.
第7题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第8题:
4,1,5,6,3,2
4,3,1,5,6,2
4,5,1,3,2,6
5,4,1,3,2,6
5,4,1,3,6,2
第9题:
RESYNC CATALOG;
REGISTER DATABASE;
CREATE CATALOG TABLESPACE rman_ts;
GRANT recovery_catalog_owner TO rman_db01;
第10题:
A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
The virtual private catalog owner cannot create and modify the stored scripts.
The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
第11题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第12题:
target database
auxiliary database
third-party database
recovery catalog database
第13题:
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
第14题:
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?()
第15题:
Which statement about using RMAN stored scripts is true?()
第16题:
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()
第17题:
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?()
第18题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第19题:
create catalog
install database
catalog database
merge Catalog with database
register database
第20题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第21题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第22题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第23题:
1,4,5,2,3
1,4,3,2,5
4,5,2,3,1
2,3,4,5,1
1,4,2,3,5
第24题:
RCO1 only.
DB01 only.
DB02 only.
DB01 and DB02 only.
DB01,DB02,and RC01.