网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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” 相关考题
考题
The father as well as children () every Sunday afternoon in winter.
A.wentB.goC.goesD.are going
考题
It was always on at the same time every day _______ Saturday and Sunday.
A. except forB. besidesC. except thatD. except
考题
He goes to ______ church every Sunday. ______ church he usually goes to has _______ seating for over _______ thousand.A.a… The…the…aB./…The…/…aC.the…The…the…aD./…The…the…a
考题
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()
A.JournalB.Task CenterC.Activity MonitorD.Command Line Processor
考题
The students’ phone offers its service_______A.every morning during the work-daysB.every morning during the work—endsC.four mornings a weekD.every other morning except Sunday
考题
10. —My sister goes swimming every Sunday.—Oh? But she __________hate swimming.A. used toB. use toC.uses toD.is used to
考题
A server failed Thursday evening before the nightly backup. The backup scheme in place was fullbackups every Sunday,incremental backups on Monday,Wednesday,and Friday,and differentialbackups on Tuesday,Thursday,and Saturday. To fully restore the server,which of the following is theLEAST amount of backup sets required?()A、 OneB、 TwoC、 ThreeD、 Four
考题
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
考题
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()A、JournalB、Task CenterC、Activity MonitorD、Command Line Processor
考题
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 the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?() A、 Yes, if the database is in ARCHIVELOG modeB、 Yes, if the database is in NOARCHIVELOG modeC、 No, the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
考题
You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? ()A、·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and ThursdayB、·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and ThursdayC、·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, ThursdayD、·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday
考题
. You have a server that runs Windows Server 2003 Service Pack 2 (SP2). You back up the files on the server by using the following schedule: ·Full backup every Sunday ·Differential backup at 01:00 every Monday to Friday You want to restore the version of a file stored on the server at the start of the business day on Wednesday. You are unsure when the file was last modified. You need to restore the appropriate version of the file by using the minimum number of tapes. Which backup jobs should you review to locate the correct version of the file? ()A、the differential backup from TuesdayB、the differential backup from Wednesday and then the full backup from SundayC、the full backup from SundayD、the full backup from Sunday and then all other backups
考题
You have a computer that runs Windows XP Professional. Normal backups are scheduled to run every Sunday at 22:00 Eastern Time. Differential backups are scheduled to run every Monday through Saturday at 22:00 Eastern Time. The computer fails on Thursday at 9:00 Eastern Time. You need to restore the computer from the backup by using the most recent data available. You must achieve this goal by using the minimum amount of administrative effort. You reinstall Windows XP Professional on the computer. What should you do next?() A、Restore Wednesday’s differential backup. B、Restore Sunday’s normal backup. Restore Wednesday’s differential backup. C、Restore Sunday’s normal backup. Restore Monday’s differential backup. Restore Tuesday’s differential backup. Restore Wednesday’s differential backup. D、Restore Sunday’s normal backup. Restore Wednesday’s differential backup. Restore Tuesday’s differential backup. Restore Monday’s differential backup.
考题
单选题They go to work every day_______ Saturday and Sunday. Those days are holidays.A
besidesB
onC
fromD
except
考题
单选题You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?()A
Perform a normal backup on Wednesday night and on Sunday night.B
Perform a differential backup on Wednesday night and on Sunday night.C
Perform a incremental backup on Wednesday night and on Sunday night.D
Perform a copy backup on Wednesday night and on Sunday night.
考题
单选题You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? ()A
·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and ThursdayB
·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and ThursdayC
·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, ThursdayD
·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday
考题
单选题You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?()A
Create a job schedule that runs every Sunday.Assign weekly tasks to this schedule.Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.B
Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code.C
Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs.D
Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month
考题
单选题You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do? ()A
Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule. B
Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code. C
Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs. D
Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.
考题
单选题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.
考题
单选题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 a server that runs Windows Server 2003 Service Pack 2 (SP2). You back up the files on the server by using the following schedule: ·Full backup every Sunday ·Differential backup at 01:00 every Monday to Friday You want to restore the version of a file stored on the server at the start of the business day on Wednesday. You are unsure when the file was last modified. You need to restore the appropriate version of the file by using the minimum number of tapes. Which backup jobs should you review to locate the correct version of the file? ()A
the differential backup from TuesdayB
the differential backup from Wednesday and then the full backup from SundayC
the full backup from SundayD
the full backup from Sunday and then all other backups
考题
单选题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 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
考题
单选题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
热门标签
最新试卷