Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above, all these files are backed up.
第1题:
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
第2题:
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()
第3题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第4题:
You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()
第5题:
Which files are required for a full recovery of the database in ARCHIVELOG mode?()
第6题:
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
第7题:
only the control file, the current SPFILE, and data files
only the current SPFILE and data files if autobackup is disabled
only the data files and the archived redo logs
the control file, current SPFILE file, data files, and archived redo logs
第8题:
Only the data files.
Only the data files and the online logs.
The data files, control files, and the online logs.
The data files and control files, but not the online logs.
第9题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第10题:
Open the database in NORMAL mode
Open the database in read-only mode
Open the database in RESTRICTED mode
Open the database with the RESETLOGS option
第11题:
only the control file, the current SPFILE, and data files
only the current SPFILE and data files if autobackup is disabled
only the data files and the archived redo logs
the control file,current SPFILE file,data files,and archived redo logs
第12题:
Put the database in hot backup mode and perform an online backup,including backing up the archived redo logs.
Just back up the database datafiles without shutting down the database.
You will have to wait until you can shut down the database to perform the backup.
Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.
Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
第13题:
When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()
第14题:
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()
第15题:
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()
第16题:
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?()
第17题:
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?()
第18题:
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
第19题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第20题:
only the control file, the current SPFILE, and data files
only the current SPFILE and data files if autobackup is disabled
only the data files and the archived redo logs
the control file, current SPFILE file, data files, and archived redo logs
第21题:
Open the database in NORMAL mode
Open the database in read-only mode
Open the database in RESTRICTED mode
Open the database with the RESETLOGS option
第22题:
RMAN keeps a list of archive logs in a text file.
The DBA must manually tell RMAN which archive logs to backup.
RMAN has access to target control file and/or catalog information.
RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
第23题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above,all these files are backed up