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 incom

题目

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
相似考题

1.The father as well as children () every Sunday afternoon in winter.A.wentB.goC.goesD.are going

2.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

3.They ( ) every Sunday morning.A、go to the churchB、go to churchC、go to a churchD、go church

4.It was always on at the same time every day _______ Saturday and Sunday.A. except forB. besidesC. except thatD. except

更多“Every Sunday， consis”相关问题

  • 第1题：

    Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?()

    A.Journal

    B.Task Center

    C.Activity Monitor

    D.Command Line Processor


    参考答案：B

  • 第2题：

    10． —My sister goes swimming every Sunday．

    —Oh? But she __________hate swimming．

    A． used to

    B． use to

    C．uses to

    D．is used to


    正确答案：A
    40．A【解析】句意：——我姐姐每周日去游泳。——哦？但她过去讨厌游泳。词组：used to do sth．过去常常做某事。故选A。

  • 第3题：

    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、One
    • B、Two
    • C、Three
    • D、Four

    正确答案:C

  • 第4题：

    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 backups
    • B、Full backups every month， daily differential backups
    • C、Full backup Saturday night， incremental backups the rest of the week
    • D、Full backup Saturday night， differential backups the rest of the week

    正确答案:C

  • 第5题：

    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 mode
    • B、 Yes， if the database is in NOARCHIVELOG mode
    • C、 No， the backup is not usable in any way
    • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

    正确答案:C

  • 第6题：

    . 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 Tuesday
    • B、the differential backup from Wednesday and then the full backup from Sunday
    • C、the full backup from Sunday
    • D、the full backup from Sunday and then all other backups

    正确答案:B

  • 第7题：

    单选题
    They go to work every day_______ Saturday and Sunday. Those days are holidays.
    A

    besides

    B

    on

    C

    from

    D

    except


    正确答案： C
    解析：

  • 第8题：

    单选题
    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 Thursday

    B

    ·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and Thursday

    C

    ·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, Thursday

    D

    ·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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 recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    C

     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

    D

     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


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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

    2

    B

    3

    C

    4

    D

    5


    正确答案： D
    解析： 暂无解析

  • 第13题：

    The students’ phone offers its service_______

    A．every morning during the work-days

    B．every morning during the work—ends

    C．four mornings a week

    D．every other morning except Sunday


    正确答案：D
    文章中有“The service is available there three mornings a week at telephoneN0．330564…”可见答案应选D。

  • 第14题：

    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、 One
    • B、 Two
    • C、 Three
    • D、 Four

    正确答案:C

  • 第15题：

    Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?（）

    • A、Journal
    • B、Task Center
    • C、Activity Monitor
    • D、Command Line Processor

    正确答案:B

  • 第16题：

    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 night
    • B、Differential backups every night
    • C、Full backup Saturday night， incremental backups the rest of the week
    • D、Full backup Saturday night， differential backups the rest of the week

    正确答案:C

  • 第17题：

    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 Thursday
    • B、·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and Thursday
    • C、·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, Thursday
    • D、·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday

    正确答案:C

  • 第18题：

    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. 

    正确答案:B

  • 第19题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    . 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 Tuesday

    B

    the differential backup from Wednesday and then the full backup from Sunday

    C

    the full backup from Sunday

    D

    the full backup from Sunday and then all other backups


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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 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


    正确答案： B
    解析： 暂无解析

相关内容