CMS专题
多选题You issue this RMAN command： RMAN> create script Level0Backup { backup incremental level 0 format ‘/u01/db01/backup/%d_%_Sp’ fileperset 5 （database include current controlfile）； sql ‘alter database archive log current’； } Which three s
题目
The script is stored only in the control file.
The script is stored only in the recover catalog.
The script can be executed only by using the RMAN RUN command.
The commands of the script can be displayed with the LIST command.
The commands of the script can be displayed with the PRINT command.
The commands of the script can be displayed with the REPORT command.
相似问题和答案
第1题：
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.
正确答案:D
第2题：
What RMAN command must you use before you can back up a database using the recovery catalog？（）
- A、 create catalog
- B、 install database
- C、 catalog database
- D、 merge Catalog with database
- E、 register database
正确答案:E
第3题：
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
第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？（）
- A、 rman TARGET / NOCATALOG
- B、 rman TARGET sys/password
- C、 rman TARGET sys/password AS SYSDBA
- D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
正确答案:B
第5题：
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？（）
- A、RESYNC CATALOG；
- B、REGISTER DATABASE；
- C、CREATE CATALOG TABLESPACE rman_ts；
- D、GRANT recovery_catalog_owner TO rman_db01；
正确答案:C
第6题：
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）
- A、 control file
- B、 all datafiles
- C、 password file
- D、 online redo log file
- E、 archive redo log file
- F、 server parameter file
- G、 only the SYSTEM datafile
正确答案:A,B,F
第7题：
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
- A、 when you change the name of a datafile
- B、 when you drop a table from the database
- C、 when you take an export of the database
- D、 when you back up the database using OS utilities
- E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
- F、 when you issue a BACKUP command from inside the RMAN run block
正确答案:A,E,F
第8题：
In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
- A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
- B、 to configure RMAN to maintain backup information in the control file for at least seven days
- C、 to display the list of files that have not been backed up for the last seven days
- D、 to display the list of files that must be backed up within seven days
正确答案:C
第9题：
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMAN>BACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）
- A、 Start the database in the MOUNT stage.
- B、 Back up the control file to trace.
- C、 Set the DBID
- D、 Issue the RECOVER DATABASE command.
正确答案:C
第10题：
You perform a backup using the following BACKUP command： RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE； Which statement is true of this command？（）
- A、 A different procedure is required to restore a database from compressed backups
- B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
- C、 Using this command to create backups minimizes the bandwidth consumed
- D、 Using this command to create backups improves the performance of the backup process
正确答案:C