网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 recovery
B
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
C
restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
D
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
A server failed Thursday evening before the nightly backup. The backup scheme in place was full backups every Sunday, incremental backups on Monday, Wednesday, and Friday, and differential backups on Tuesday,Thursday, and Saturday. To fully restore the server.which of the following is the LEAST amount of backup sets required?（）A. OneB. TwoC. ThreeD. Four
考题
A full backup is performed every Sunday and incremental backups are performed daily Monday through Saturday. How many tapes would be required to perform a full restore if a complete failure occurred on Thursday before the incremental backup？（）A、 2B、 3C、 4D、 5
考题
A server failed Thursday evening before the nightly backup. The backup scheme in place was full backups every Sunday, incremental backups on Monday, Wednesday, and Friday, and differential backups on Tuesday,Thursday, and Saturday. To fully restore the server. which of the following is the LEAST amount of backup sets required?（）A、OneB、TwoC、ThreeD、Four
考题
Due to operational commitments， a system has a very short backup window during the week， but is not used from Saturday morning through Sunday at Midnight. Which of the following minimizes backup and recovery time， while providing complete data restore coverage （）A、Full backups every month， daily incremental backupsB、Full backups every month， daily differential backupsC、Full backup Saturday night， incremental backups the rest of the weekD、Full backup Saturday night， differential backups the rest of the week
考题
Due to operational commitments， a system has a very short backup window during the week， but is not used from Saturday morning through Sunday at Midnight. Which of the following minimizes backup time， while providing the best data restore coverage？（）A、Full backups every nightB、Differential backups every nightC、Full backup Saturday night， incremental backups the rest of the weekD、Full backup Saturday night， differential backups the rest of the week
考题
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
考题
Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)A、It's only supported for the backups performed on the tapeB、It is not supported for backup operations that produce image copiesC、Duplex backups need a parallelism for the device to be equal to number of copiesD、Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
考题
You are managing an Oracle Database 11g database with this backup strategy： - Every Sunday night， level 0 backup is performed. - On Monday night and subsequent days， level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true（）A、The backup contains all the used blocks.B、The backup contains all the used and unused blocks.C、The backup contains blocks that have changed since the last level 0 backup.D、The backup contains blocks that have changed since the last level 1 backup taken last week.
考题
Which two statements are true about the duplexing of the backups taken by RMAN？（） A、 It’s only supported for the backups performed on the tapeB、 It is not supported for backup operations that produce image copiesC、 Duplex backups need a parallelism for the device to be equal to number of copiesD、 Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）A、ARCHIVELOG mode.B、NOARCHIVELOG mode.C、Open database backups.D、Consistent whole backups.
考题
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？（）A、Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.B、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.C、Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.D、Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.
考题
多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1backup.CThe backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.
考题
单选题You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）A
Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.B
Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.C
Schedule a copy backup every day.D
Schedule a normal backup every day.
考题
单选题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？（）A
recover using Oracle Flashback Database technologyB
restore the data files from backup and perform a complete recoveryC
restore only the corrupted data file and perform tablespace recoveryD
restore the data files from backup and perform cancelbased recoveryE
restore the entire database from the most recent backup and start the instance and open the database
考题
单选题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
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until last Sunday’s backupC
until Wednesday eveningD
until that point in time when the database is openedE
until that point in time when the recovery is performedF
until that point in time when the table is dropped and purged
考题
单选题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.
考题
单选题You are managing an Oracle Database 11g database with this backup strategy： - Every Sunday night， level 0 backup is performed. - On Monday night and subsequent days， level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true（）A
The backup contains all the used blocks.B
The backup contains all the used and unused blocks.C
The backup contains blocks that have changed since the last level 0 backup.D
The backup contains blocks that have changed since the last level 1 backup taken last week.
考题
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
考题
单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged 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 archivelog 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 timebased recoveryB
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryC
restore all the data files from last Sunday’s backup， and then perform a changebased recoveryD
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
考题
单选题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.
考题
单选题Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows： SQL DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9：00 a.m. on the same table as follows： SQL SELECT * FROM cust_ord; SELECT * FROM cust_ord * ERROR at line 1： ORA/x7f00942： table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）A
retrieve the table by using the flashback featureB
restore all the data files from last Sunday’s backup， and then perform a timebased recoveryC
restore all the data files from last Sunday’s backup， and then perform a log sequence recoveryD
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryE
restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery
考题
单选题A full backup is performed every Sunday and incremental backups are performed daily Monday through Saturday. How many tapes would be required to perform a full restore if a complete failure occurred on Thursday before the incremental backup?（）A
2B
3C
4D
5
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN？（）AIt’s only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until that point in time when the database is openedC
until that point in time when the recovery is performedD
until last Sunday’s backupE
until that point in time when the table is dropped and purgedF
until Wednesday evening
考题
单选题A full backup is performed every Sunday and incremental backups are performed daily Monday through Saturday. How many tapes would be required to perform a full restore if a complete failure occurred on Thursday before the incremental backup？（）A
2B
3C
4D
5
考题
多选题Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)AIt's only supported for the backups performed on the tapeBIt is not supported for backup operations that produce image copiesCDuplex backups need a parallelism for the device to be equal to number of copiesDDuplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
热门标签
最新试卷