CHANGE
RESYNC
CATALOG
CROSSCHECK
第1题:
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()
第2题:
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?()
第3题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()
第4题:
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()
第5题:
SQL script
PL/SQL script
Operating System (OS) script
Enterprise Manager (EM) script
Recovery Manager (RMAN) script
第6题:
The copy of the datafile created is stored in the RMAN repository.
The copy of the datafile created can be viewed using the LIST BACKUP command.
The copy of the datafile created using this COPY command can be placed only on the disk.
The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
The copy of the datafile created can be used for recovering the database using the user-managed recovery method.
第7题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第8题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第9题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第10题:
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.
第11题:
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.
第12题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第13题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第14题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
第15题:
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()
第16题:
SYSDBA
SYSOPER
No system privileges are required for the RMAN user.
Only SYS user can connect and execute RMAN commands on a target database.
第17题:
The backup status will be marked expired in RMAN recovery catalog.
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
第18题:
You are backing up to tape and your tape device performs its own compression.
You are making image copies, and you have not enabled tablespace compression.
You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
第19题:
backup database all
backup compressed database
backup as compressed backupset database
backup as compressed backup database plus archivelog all
backup as compressed backupset database plus compress archivelog all
第20题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
第21题:
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
第22题:
Datafiles
Current control file
Server parameter file (spfile)
Password file
第23题:
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