You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()
第1题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()
第2题:
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?()
第3题:
You issued the following RMAN command: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()
第4题:
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?()
第5题:
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
第6题:
Corrupted blocks, if any, are repaired.
Checks are performed for physical corruptions.
Checks are performed for logical corruptions.
Checks are performed to confirm whether all database files exist in correct locations
Backup sets containing both data files and archive logs are created.
第7题:
Opening the database in RESTRICTED mode
Opening the database with the RESETLOGS option
Setting a new DBID for the newly restored database
Restoring the server parameter file (SPFILE) to the new host
第8题:
A backup of the target database when it is mounted
A backup of online redo log files when the database is open
A backup of only used data blocks in the file beingbeingbackup up
A backup of online, read/write data files when the database is open
A backup of only those data blocks that have changed since a previous backup
A backup of online, read/write data files when the database is in the NOMOUNT state.
第9题:
The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
第10题:
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
第11题:
Opening the database in RESTRICTED mode
Opening the database with the RESETLOGS option
Setting a new DBID for the newly restored database
Restoring the server parameter file (SPFILE) to the new host
第12题:
target database
auxiliary database
third-party database
recovery catalog database
第13题:
Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()
第14题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第15题:
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?()
第16题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
第17题:
When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.
When a structural change is made to the database, then a backup of the current control file is performed.
When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.
When a structural change is made to the database, then a backup of the alert log file will be performed.
第18题:
Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
The change tracking file must always be backed up when you perform a full database backup.
Block change tracking will always reduce I/O performed during cumulative incremental backups.
More than one database block may be read by an incremental backup for a change made to a single block.
The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.
第19题:
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
第20题:
by using the Flashback Table feature
by using the Flashback Database feature
by performing incomplete recovery using RMAN utility
by performing incomplete recovery using user-managed recovery
第21题:
You need to perform the restore and recover operations manually, because the backup was made manually.
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
第22题:
cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
第23题:
’SQL ALTER DATABASE OPEN’;
SQL ALTER DATABASE ’OPEN’;
OPEN DATABASE;
DATABASE OPEN