You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?()
第1题:
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8.30 a.m. With reference to this scenario, what would you do to recover the database?()
第2题:
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
第3题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
第4题:
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)
第5题:
What is the impact of the following backup if it exceeds the duration allowance?() Backup as compressed backupset duration 2:00 partial minimize load database ;
第6题:
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8:00 P.M. Your database is running in ARCHIVELOG mode. On Monday, at 9:00 A.M., a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command?()
第7题:
You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()
第8题:
You want to perform a backup of your database to tape. Which backup format can you use?()
第9题:
incomplete recovery
complete recovery
recovery using the Flashback Database feature
recovery using the export/import utility
第10题:
restore all the data files from last Sunday’s backup, and then perform a timebased recovery
restore all the data files from last Sunday’s backup, and then perform a cancelbased recovery
restore all the data files from last Sunday’s backup, and then perform a changebased recovery
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery
第11题:
2 minutes
2 hours
2 days
The command will generate an error.
This backup is not constrained by any time limitation.
第12题:
Backup compression should be enabled
Parallelism for the channel should be set to 2
All the files must be backed up as backup sets
The backup may be stored either on disk or on media with media manager
第13题:
How long will this backup be allowed to run?() Backup as compressed backupset duration 2:00 minimize load database
第14题:
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
第15题:
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? ()
第16题:
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()
第17题:
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
第18题:
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?()
第19题:
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?()
第20题:
RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE
RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
第21题:
backup database plus archivelog
backup database plus archivlog until time ‘10:00‘
backup database plus archivelog timeout ‘10:00‘
backup database plus archivelog duration 10:00
第22题:
The entire backup will fail.It will not be usable for recovery.
The entire backup will failbut any datafile successfully backed up will be usable for recovery.
If this backup fails,subsequent backups will prioritize datafiles not backed up.
If this backup fails,an error will be raised and any other commands will not be executed.
If this backup fails,no error will be raised and any other commands will be executed.
第23题:
backup set only
image copy only
only user-managed backup
both image copy and backup set
only incremental image copy backup