b, a, c, d, e
a, c, b, d, f
c, a, b, d, e
c, a, b, d, f
e, a, b, d, c
第1题:
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation?()
第2题:
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?() a. Mount the database with the startup mount command. b. Take the SYSTEM datafile offline with the alter database command. c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. d. Restore all SYSTEM tablespace-related datafiles from backup media. e. Issue the recover tablespace SYSTEM command. f. Issue the recover datafile SYSTEM_01.dbf command. g. Open the database with the alter database open command. h. Open the database with the alter database open resetlogs command.
第3题:
Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.() a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database open
第4题:
Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?()
第5题:
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?() a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.
第6题:
You work as a database administrator for Supportcenter.cn. 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?()
第7题:
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
第8题:
a, c, f, g
b, d, e, h
a, b, c, f, g
d, a, e, g
b, c, f, e, g
第9题:
a, b, c, d, e, f
c, b, a, d, e, f
c, b, a, d, f
c, a, b, d
c, a, e, b, d, f
第10题:
Drop the affected tablespace,re-create the tablespace,restore the datafiles,and the tablespace.
Take the affected datafile offline(if not already offline),restore the damaged image of the datafile,and then bring it online.
Restart the database in MOUNT mode,restore the damaged datafile,recover the datafile and then open the database with resetlogs.
Put the database in RESTRICTED mode,restore all the datafiles in the affected datafile and recover the tablespace,and then put the database in normal operational mode.
第11题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第12题:
b, a, c, d, e
a, c, b, d, f
c, a, b, d, e
c, a, b, d, f
e, a, b, d, c
第13题:
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?() a. Restored the control file with the RMAN restore controlfile command. b. Mounted the DSL instance with the alter database mount command. c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance. g. Connected to the recovery catalog with RMAN.
第14题:
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
第15题:
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
第16题:
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?() a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4 d. sql ’alter database datafile 4 offline’ e. startup f. shutdown
第17题:
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?()
第18题:
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
第19题:
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
第20题:
2, 7, 3, 5, 1, 6, 4
2, 1, 7, 6, 3, 5, 4
7, 1, 3, 2, 6, 5, 4
7, 2, 3, 1, 4, 6, 5
第21题:
shutdown restore datafile 4; recover datafile 4; alter database open;
Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;Sql alter database datafile 4 online;
Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
第22题:
b, d, e
b, d, f
c, a, b, d, e
c, a, b, d, f
a, b, d, e
第23题:
a, b, c, d, e, f
c, d, a, b, f
d, c, a, b, f
d, b, d, c, e
d, c, a, b, e
第24题:
a, b, c, d, e, f
c, b, a, d, e, f
c, b, a, d, f
c, a, b, d
c, a, e, b, d, f