网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?()   a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’  c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database open

  • A、 b, d, e
  • B、 b, d, f
  • C、 c, a, b, d, e
  • D、 c, a, b, d, f
  • E、 a, b, d, e

参考答案

更多 “ You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?()   a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’  c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database openA、 b, d, eB、 b, d, fC、 c, a, b, d, eD、 c, a, b, d, fE、 a, b, d, e” 相关考题
考题 WhatwillbetheendresultofthissetofRMANcommands?()shutdownabortstartupmountrestoredatafile4untiltime,,09/30/2008:15:00:00;recoverdatafile4untiltime,,09/29/2008:15:00:00;alterdatabaseopenresetlogs; A.Datafile4willberecovereduntil9/30/2008at15:00andthedatabasewillopen.B.Therestorecommandwillfail.C.Therecovercommandwillfail.D.Thealterdatabaseopenresetlogscommandwillfail.E.Allthesecommandswillfailbecausetheymustbeintheconfinesofarunblock.

考题 Youneedtorestoreyourdatabasebackto9/30/2008at18:00.Inwhatorderwouldyourunthefollowingcommandstocompetethistask?()a.restorecontrolfileuntiltime`09/30/2008:18:00:00’b.restoredatabaseuntiltime`09/30/2008:18:00:00’c.restorespfileuntiltime`09/30/2008:18:00:00’d.recoverdatabaseuntiltime`09/30/2008:18:00:00’e.alterdatabaseopenresetlogsf.alterdatabaseopenA.b,d,eB.b,d,fC.c,a,b,d,eD.c,a,b,d,fE.a,b,d,e

考题 Whichcommandwillrestorealldatafilestothedate9/30/2008at18:00hours?() A.restoredatafilesuntiltime‘09/28/2008:21:03:11‘B.restoredatabasefilesuntiltime‘09/28/2008:18:00:00‘C.restoredatabaseuntiltime‘09/28/2008:18:00:00‘D.recoverdatabaseuntiltime‘09/28/2008:18:00:00‘E.recoverdatabaseuntiltimestamp‘09/28/2008:18:00:00‘

考题 Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'

考题 You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()A、backup database plus archivelogB、backup database plus archivlog until time ‘10:00‘C、backup database plus archivelog timeout ‘10:00‘D、backup database plus archivelog duration 10:00

考题 You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database:  SET UNTIL TIME = ’2000-12-09:11:44:00’;  RESTORE DATABASE; RECOVER DATABASE;  How should the commands be executed? ()A、Only the SET command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.

考题 Which command would correctly start a TSPITR of the USERS tablespace?()  A、 recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary ,,c/oracle/auxiliaryB、 recover tablespace users time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; time ,, 10/06/2008:22:42:00 auxiliary destination ,,c/oracle/auxiliaryC、 recover tablespace users to point-in.D、 recover tablespace users except time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliaryE、 recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary

考题 You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task?() A、 SYSTEMB、 SYSAUXC、 UNDOD、 USERSE、 TEMPF、 This restore is not possible

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

考题 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.

考题 What will be the end result of this set of RMAN commands?()   shutdown abort startup mount  restore datafile 4 until time ,,09/30/2008:15:00:00;  recover datafile 4 until time ,,09/29/2008:15:00:00;  alter database open resetlogs;A、 Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.B、 The restore command will fail.C、 The recover command will fail.D、 The alter database open resetlogs command will fail.E、 All these commands will fail because they must be in the confines of a run block.

考题 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 have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You enable Shadow Copies on all drives by using the default options. You run a full backup every Monday at 02:00. You run an incremental backup every day at 02:00, except on Monday. On Thursday at 14:00, a user reports that he accidentally deleted a file named File1.doc in a shared folder named //Server1/Data/. The user reports that the file was last updated at 09:00 on Thursday. You need to restore the latest version of File1.doc. What should you restore? ()A、the file by using the Previous Versions ClientB、the file from the full backup performed on MondayC、the file from the incremental backup performed on ThursdayD、the user’s computer by using Automated System Recovery (ASR)

考题 You manage a server that runs Windows Server 2008 R2.The D:/Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00.You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server.What should you do on the server?()A、Run the Recover d:/payroll command.B、Run the Wbadmin restore catalog -backuptarget:D: -version:10/29/2007-09:00 quiet command.C、Run the Wbadmin start recovery -backuptarget:D: -version:10/29/2007-09:00 overwrite quiet command.D、Run the Wbadmin start recovery -version:10/29/2007-09:00 -itemType:File -items:d:/Payroll -overwrite -recursive quiet command.

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least.  So what action should you perform to achieve this goal?()  A、You should restore the full backup B、You should restore the database snapshot from 16:30 hours. C、You should restore the database snapshot from 17:30 hours D、You should restore both the full backup and the differential backup. 

考题 You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You enable Shadow Copies on all drives by using the default options. You run a full backup every Monday at 02:00. You run an incremental backup every day at 02:00, except on Monday. On Thursday at 14:00, a user reports that he accidentally deleted a file named File1.doc in a shared folder named //Server1/Data/. The user reports that the file was last updated at 09:00 on Thursday. You need to restore the latest version of File1.doc. What should you restore? ()A、the file by using the Previous Versions ClientB、the file from the full backup performed on MondayC、the file from the incremental backup performed on ThursdayD、the user’s computer by using Automated System Recovery (ASR)

考题 You manage a server that runs windows server 2008. The D:/payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00. You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server. What should you do on the server?()A、Run the recover d:/Payroll command.B、Run the WBadmin restore catalog-backuptarget:D:-version: 10/29/2007-09:00 coverwrite cquiet command.C、Run the wbadmin start recovery-backuptarget:D:-version: 10/29/2007 -09:00 coverwrite cquiet command.D、Run the wbadmin start recovery-version:10/29/2007 -09:00 –itemtype:file –file –items d:/payroll –overwrite –recursive cquiet command.

考题 You manage a server that runs Windows Server 2008. The D:///Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00. You need to restore all the files in the D:///Payroll folder back to the most recent backup version without affecting other folders on the server. What should you do on the server?()A、 Run the Recover d:/Payroll comamndB、 Run the WBadmin restore catalog-backuptarget:D:// -version: 10/29/2007-09:00 Cquiet commandC、 Run the WBadmin start recovery-backuptarget:D:// -version: 10/29/2007-09:00 Coverwrite Cquiet commandD、 Run the Wbadmin start recovery-version:10/29/2007-09:00 -itemType:File -items d:/payroll -overwrite - recursive Cquiet command.

考题 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. 

考题 Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA、 b, a, c, d, eB、 a, c, b, d, fC、 c, a, b, d, eD、 c, a, b, d, fE、 e, a, b, d, c

考题 单选题You manage a server that runs Windows Server 2008 R2.The D:/Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00.You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server.What should you do on the server?()A Run the Recover d:/payroll command.B Run the Wbadmin restore catalog -backuptarget:D: -version:10/29/2007-09:00 quiet command.C Run the Wbadmin start recovery -backuptarget:D: -version:10/29/2007-09:00 overwrite quiet command.D Run the Wbadmin start recovery -version:10/29/2007-09:00 -itemType:File -items:d:/Payroll -overwrite -recursive quiet command.

考题 单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least.  So what action should you perform to achieve this goal? ()A You should restore the full backup B You should restore the database snapshot from 16:30 hours. C You should restore the database snapshot from 17:30 hours D You should restore both the full backup and the differential backup.

考题 单选题You manage a server that runs Windows Server 2008 R2. The D:/Payroll folder is corrupted. The most recent backup version is 10/29/2007-09:00. You need to restore all the files in the D:/Payroll folder back to the most recent backup version without affecting other folders on the server. What should you do on the server?()A Run the Recover d:/payroll command.B Run the Wbadmin restore catalog -backuptarget:D: -version:10/29/2007-09:00 quiet command.C Run the Wbadmin start recovery -backuptarget:D: -version:10/29/2007-09:00 overwrite quiet command.D Run the Wbadmin start recovery -version:10/29/2007-09:00 -itemType:File -items:d:/Payroll -overwrite -recursive quiet command.

考题 单选题Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? ()A restore datafiles until time '09/28/2008:21:03:11'B restore database files until time '09/28/2008:18:00:00'C restore database until time '09/28/2008:18:00:00'D recover database until time '09/28/2008:18:00:00'E recover database until timestamp '09/28/2008:18:00:00'

考题 单选题You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?()   a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’  c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database openA  b, d, eB  b, d, fC  c, a, b, d, eD  c, a, b, d, fE  a, b, d, e

考题 单选题Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogsA  b, a, c, d, eB  a, c, b, d, fC  c, a, b, d, eD  c, a, b, d, fE  e, a, b, d, c

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