b, d, e
b, d, f
c, a, b, d, e
c, a, b, d, f
a, b, d, e
第1题:
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?()
第2题:
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?() a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’ c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database open
第3题:
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command: RMAN>BACKUP DATABASE; At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?()
第4题:
You have a single Active Directory directory service domain. You back up your domain controllers on a nightly basis. You perform Group Policy backups on a nightly basis. A Group Policy object (GPO) is accidentally deleted. You need to restore the GPO. What should you do?()
第5题:
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?()
第6题:
Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?() a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogs
第7题:
b, d, e
b, d, f
c, a, b, d, e
c, a, b, d, f
a, b, d, e
第8题:
You should restore the full backup
You should restore the database snapshot from 16:30 hours.
You should restore the database snapshot from 17:30 hours
You should restore both the full backup and the differential backup.
第9题:
13:00 on Tuesday.
15:00 on Tuesday.
Up until the last available archived redo log on Sunday.
To any point; all the redo should still be available in the online redo logs.
The database is not recoverable.
第10题:
Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
The restore command will fail.
The recover command will fail.
The alter database open resetlogs command will fail.
All these commands will fail because they must be in the confines of a run block.
第11题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第12题:
Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th,and open the database.
Tell them that their request cannot be met with the current backup strategy.
Restore the 19ths backup, apply the online redo logs,and open the database.
Switch the database into ARCHIVELOG mode,restore the 19th’s backup,restore all archived redo logs,and recover the database to the 20th.
Use the recover database command to roll back the database from today to the 19th of the month.
第13题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第14题:
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第15题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()
第16题:
You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19:00 and 04:00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do?()
第17题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal?()
第18题:
flash back all the tables in the data file, one by one
restore the data file to a new location and perform a media recovery
flash back the database; there is no need to restore the data file
restore the data file from the most recent backup and flash back the database
第19题:
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
第20题:
Restore and recover the datafile.
Restore and recover the tablespace.
Restore and recover the database.
Restore and recover the control file.
Restore and recover the parameter file.
第21题:
Flash back all the tables in the data file, one by one.
Restore the data file to a new location and perform a media recovery.
Flash back the database, there is no need to restore the data file.
Restore the data file from the most recent backup and flash the database.
第22题:
SYSTEM
SYSAUX
UNDO
USERS
TEMP
This restore is not possible
第23题:
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.
第24题:
restore datafiles until time '09/28/2008:21:03:11'
restore database files until time '09/28/2008:18:00:00'
restore database until time '09/28/2008:18:00:00'
recover database until time '09/28/2008:18:00:00'
recover database until timestamp '09/28/2008:18:00:00'