Datafiles
Current control file
Server parameter file (spfile)
Password file
第1题:
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?()
第2题:
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?()
第3题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
第4题:
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?()
第5题:
You performed a backup of the flash recovery area by using the following command for the first time: RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
第6题:
flashback logs
current control file
control file autobackups
incremental backup sets
第7题:
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
第8题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第9题:
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
第10题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed
Using this command to create backups improves the performance of the backup process
第11题:
redo log files
password file
control file
change tracking file
第12题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above,all these files are backed up
第13题:
You issued the following RMAN command: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()
第14题:
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()
第15题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
第16题:
When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()
第17题:
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
第18题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第19题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第20题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed
Using this command to create backups improves the performance of the backup process
第21题:
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.
第22题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第23题:
data file
password file
archivelog file
temporary file
online redo log file
the current control file
the tnsnames.ora file
current server parameter file