搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单项选择题】

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、A.recovery cannot be performed because a backup was not performed after the last incomplete recovery

B、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、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、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？（）”相关的问题
第1题
[单选题] 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.  

点击查看答案
第2题
[单选题] 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.  

点击查看答案
第3题
[单选题] 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  

点击查看答案
第4题
[单选题] 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  

点击查看答案
第5题
[单选题] 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.  

点击查看答案
第6题
[单选题] 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  

点击查看答案
第7题
[] 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? （） 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 wh

A、A. the differential backup from Tuesday  B、B. the differential backup from Wednesday and then the full backup from Sunday  C、C. the full backup from Sunday  D、D. the full backup from Sunday and then all other backups  

点击查看答案
第8题
[] You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

A、A. UNTIL SEQUENCE  B、B. UNTIL SCN  C、C. UNTIL CHANGE  D、D. UNTIL CANCEL  

点击查看答案
第9题
[单选题] 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 morning  B、 until that point in time when the database is opened  C、 until that point in time when the recovery is performed  D、 until last Sunday’s backup  E、 until that point in time when the table is dropped and purged  F、 until Wednesday evening  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服