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

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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” 相关考题
考题 Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having active online redo log files is also corrupted.-The hardware is repaired and the paths for online redo log files and control files are still valid.Which option would you use to perform the recovery of database till the point of failure?()A. Restore the latest whole backup, perform complete recovery, and open the database normallyB. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option

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

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

考题 Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number (SCN)

考题 You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option?()A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

考题 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 maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

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

考题 Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process? ()A、open the database with the RESETLOGS optionB、open the database with the RESTRICTED optionC、recover all the data files to the same system change number (SCN)D、recover to the required SCN only that data file in which the error occurred

考题 Examine the following scenario:   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure?()  A、 Restore the latest whole backup,perform complete recovery,and open the database normally B、 Restore the latest whole backup,perform incomplete recovery,and open the database with the  RESETLOGS option.C、 Restore the latest backups control file,perform complete recovery,and open the database with the RESETLOGS option.D、 Restore the latest backup control file,perform incomplete recovery using backup control file,and open the database with the RESETLOG option.

考题 You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility

考题 You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery

考题 You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement:   SQLALTER DATABASE OPEN RESETLOGS;   What will be the resultant log sequence numbers?()A、 0 and 1B、 1 and 2C、 1005 and 1006D、 1006 and 1007

考题 单选题You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()A  incomplete recoveryB  complete recoveryC  recovery using the Flashback Database featureD  recovery using the export/import utility

考题 单选题You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A  user managed complete recoveryB  user managed incomplete recoveryC  RMAN-based complete recoveryD  RMAN-based incomplete recovery

考题 单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()A You performed rollback after commit.B If a log switch occurs in your database.C Thearchiverfails to generate an archived log file.D Instance recovery fails to find one of the redo log files.E A long-running query is unable to get read-consistent image.F If you perform manual undo management operations in auto mode.

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

考题 单选题Consider the recovery steps in each of the cases given below:  Case 1:  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files, open the database using the RESETLOGS option.  Back up the database.  Case 2:  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3: Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery?()A only case 1B only case 2C only case 3D case 1 and 2E case 2 and 3F case 1 and 3G all cases: case 1, case 2 and case 3

考题 单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?()A Restore the latest whole backup, perform complete recovery, and open the database normallyB Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option

考题 单选题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 recoveryB restore all the data files from last Sunday’s backup, and then perform a cancel­based recoveryC restore all the data files from last Sunday’s backup, and then perform a change­based recoveryD restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery

考题 单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A  The target database must be in the MOUNT mode to ensure restoration of the datafiles.B  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C  The control file must be recreated.D  The database must be opened with the RESETLOGS option.

考题 单选题Examine the following scenario:   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure?()A  Restore the latest whole backup,perform complete recovery,and open the database normally B  Restore the latest whole backup,perform incomplete recovery,and open the database with the  RESETLOGS option.C  Restore the latest backups control file,perform complete recovery,and open the database with the RESETLOGS option.D  Restore the latest backup control file,perform incomplete recovery using backup control file,and open the database with the RESETLOG option.

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

考题 单选题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 maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday.  How will you recover the dropped table, SCOTT.EMPLOYEE?()A  by using the Flashback Table featureB  by using the Flashback Database featureC  by performing incomplete recovery using RMAN utilityD  by performing incomplete recovery using user-managed recovery

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