网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
A
Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
B
Tell them that their request cannot be met with the current backup strategy.
C
Restore the 19ths backup， apply the online redo logs，and open the database.
D
Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo logs，and recover the database to the 20th.
E
Use the recover database command to roll back the database from today to the 19th of the month.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）A Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.B Tell them that their request cannot be met with the current backup strategy.C Restore the 19ths backup， apply the online redo logs，and open the database.D Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo logs，and recover the database to the 20th.E Use the recover database command to roll back the database from today to the 19th of the month.” 相关考题
考题
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
考题
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery
考题
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）A、recovery cannot be performed because a backup was not performed after the last incomplete recoveryB、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
考题
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？（）A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
考题
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
考题
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？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 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.E、 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
考题
Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（） A、 13：00 on Tuesday.B、 15：00 on Tuesday.C、 Up until the last available archived redo log on Sunday.D、 To any point； all the redo should still be available in the online redo logs.E、 The database is not recoverable.
考题
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）A、Restore the data file for the SYSTEM tablespace then open the database. B、Restore all redo logs form last night's backup, then restart the database. C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
考题
Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）A、 Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.B、 Tell them that their request cannot be met with the current backup strategy.C、 Restore the 19ths backup， apply the online redo logs，and open the database.D、 Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo logs，and recover the database to the 20th.E、 Use the recover database command to roll back the database from today to the 19th of the month.
考题
You are the network administrator for All network servers run Windows Server 2003. You perform a full backup of the network every Monday. You perform incremental backups every Tuesday, Wednesday, Thursday, and Friday. Backups are always performed at 1:00 A.M. On Wednesday at noon, one server experiences hard disk failure. You need to restore all data on this server. What should you do?（）A、Restore the Wednesday backup, then restore the Tuesday backup, and then restore the Monday backup.B、Restore the Wednesday backup, and then restore the Monday backup.C、Restore the Monday backup, then restore the Tuesday backup, and then restore the Wednesday backup.D、Restore the Monday backups, and then restore the Wednesday backup.
考题
You take backups of your hard drives every night. On Thursday morning you see that the hard disk has crashed. The backup log shows: * Friday normal backup completed * Saturday incremental backup completed * Sunday incremental backup completed * Monday incremental backup completed * Tuesday incremental backup incomplete * Wednesday incremental backup completed. What should you do to restore your data to the update state?（ ）A、Restore using the tapes from Friday， Saturday， Sunday， Monday and Wednesday.B、Restores using only Fridays tapeC、Restore using the tapes from Thursday， Friday， Saturday， Sunday and Tuesday.D、Restore using the tapes from Friday and Tuesday.E、Restore using the tapes from Tuesday and Thursday.
考题
You are the network administrator for TestKing. The network contains a Windows Server 2003 computer named Testking1. You back up the data folders on Testking1 by using the following schedule: 1. Normal backup every Monday. 2. Incremental backups every Tuesday, Wednesday, Thursday, and Friday. After the backup on Friday is completed, a user accidentally deletes a file from a data folder on Server1. The user reports that he modified the file in the past week, but he does not know which day he modified the file. You do not know when the file was last backed up. You need to restore the latest copy of the file as quickly as possible. What should you do?（）A、Open the backup log for each day. Begin by opening the log for Monday, and then work forward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.B、Open the backup log for each day. Begin by opening the log for Tuesday, and then work forward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.C、Open the backup log for each day. Begin by opening the log for Friday, and then work backward through the logs for each day of the week. In each log, search for a backup of the file. Restore the first backup that you find.D、Restore the file from the Monday, Tuesday, Wednesday, Thursday, and Friday backups, in that order.E、Restore the file from the Monday backup, and then from the Friday backup.
考题
单选题You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C
Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D
Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A
SMON would automatically restore the lost file.B
You would need to restore the whole database from the last backup.C
You would need to restore the file from the last full database backup.D
You would need to use flashback technology to restore the lost redo log member.E
You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F
You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A
Restore all the datafiles from the backup.B
Restore only the lost datafile from the backup.C
Restore all the datafiles for the lost tablespace from the backup.D
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
考题
单选题You are the network administrator for All network servers run Windows Server 2003. You perform a full backup of the network every Monday. You perform incremental backups every Tuesday, Wednesday, Thursday, and Friday. Backups are always performed at 1:00 A.M. On Wednesday at noon, one server experiences hard disk failure. You need to restore all data on this server. What should you do?（）A
Restore the Wednesday backup, then restore the Tuesday backup, and then restore the Monday backup.B
Restore the Wednesday backup, and then restore the Monday backup.C
Restore the Monday backup, then restore the Tuesday backup, and then restore the Wednesday backup.D
Restore the Monday backups, and then restore the Wednesday backup.
考题
单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC
restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on SundayD
restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
考题
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
考题
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
考题
单选题You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A
restore the tablespace from the backup； there is no need to apply the redo informationB
restore the full database to recover the data up to the point when you performed the backupC
restore the tablespace from the backup and then perform a recovery using the backup control fileD
restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied
考题
单选题You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）A
restore the tablespace from the backup， and then perform an incomplete recoveryB
restore the tablespace from the backup， and then apply all the redo informationC
restore all the data files in the database， and then perform an incomplete recoveryD
restore the tablespace from the backup
考题
单选题Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）A
13：00 on Tuesday.B
15：00 on Tuesday.C
Up until the last available archived redo log on Sunday.D
To any point； all the redo should still be available in the online redo logs.E
The database is not recoverable.
考题
单选题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？（）A
Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B
Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C
Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D
Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
考题
单选题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A
import the database from the last exportB
restore all the members in the group from the last backupC
drop the lost member from the database and then add a new member to the groupD
restore all the database files from the backup and then perform a complete recoveryE
restore all the database files from the backup and then perform an incomplete recovery
考题
单选题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？（）A
Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B
Just back up the database datafiles without shutting down the database.C
You will have to wait until you can shut down the database to perform the backup.D
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.E
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
热门标签
最新试卷