1z0-043
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A create a backup of the database and recover all corrupted blocks found in the backupB run a bac
题目
create a backup of the database and recover all corrupted blocks found in the backup
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
相似问题和答案
第1题：
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packaged procedure.
第2题：
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第3题：
A. 4
B. 8
C. 7
D. 0
第4题：
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.
正确答案:D
第5题：
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
- A、’SQL ALTER DATABASE OPEN’；
- B、SQL ALTER DATABASE ’OPEN’；
- C、OPEN DATABASE；
- D、DATABASE OPEN
正确答案:C
第6题：
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema?（）
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2
第7题：
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）
- A、The database is in NOMOUNT state.
- B、The database is in ARCHIVELOG mode and the tablespace is online.
- C、The database is in ARCHIVELOG mode and the tablespace is offline.
- D、The database is in NOARCHIVELOG mode and the tablespace is online.
- E、The database is in NOARCHIVELOG mode and the tablespace is offline.
正确答案:B,C,E
第8题：
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第9题：
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
第10题：
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