a, c, f, g
b, c, f, h
a, b, c, f, g
a, b, c, f, g, h
b, c, f, e, g
第1题:
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()
第2题:
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
第3题:
Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?()
第4题:
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.
第5题:
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()
第6题:
Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.
Oracle will automatically take the datafile out of hot backup mode and then open the database.
Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
The database will open with the file in hot backup mode. You can restart the backup at any time.
The datafile in hot backup mode will be corrupted and you will have to recover it.
第7题:
Oracle Net Manager
Listener Control utility
Database Configuration Assistant
Oracle Net Configuration Assistant
第8题:
Mount the container database (CDB) and restore the control file from the control file auto backup.
Recover and open the CDB in NORMAL mode.
Mount the CDB and then recover and open the database, with the RESETLOGS option.
Open all the pluggable databases.
Recover each pluggable database.
Start the database instance in the nomount stage and restore the control file from control file auto backup.
第9题:
Restore all the data files and open the database
Create the data file and perform tablespace recovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第10题:
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;
第11题:
to recover a dropped tablespace
to recover data from a truncated table
to recover a data file that has been shrunk
to recover a database to the state that existed before the RESETLOGS operation
第12题:
You will need to open the database with the resetlogs command.
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
You will use the resetlogs version of the create controlfile command.
You will use the noresetlogs version of the create controlfile command.
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
第13题:
In which case would you use the Flashback Database feature to perform a recovery?()
第14题:
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?()
第15题:
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process? ()
第16题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第17题:
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database: a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case?()
第18题:
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.
第19题:
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.
第20题:
1,3,6,7
2,3,6,8
1,2,3,6,7
1,2,3,6,,7,8
2,3,6,5,7
第21题:
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.
第22题:
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.
第23题:
2,1,3,4,5,6
2,4,5,3
4,7,3
2,4,7,3
2,7,3
第24题:
a, b, e, c
b, e, d
a, b, d, c
b, g, c, f
a, b, d, f