Which step is required for recover from an instance failure? ()A、Start up only.B、Restore needed data files, then start up.C、Complete restore from backup, then start up.D、Perform point in time recovery, then start up.

题目

Which step is required for recover from an instance failure? ()

  • A、Start up only.
  • B、Restore needed data files, then start up.
  • C、Complete restore from backup, then start up.
  • D、Perform point in time recovery, then start up.
参考答案和解析
正确答案:A
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()

  • A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.
  • B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.
  • D、 Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.

正确答案:A

第2题:

Which of the following locations contains the System Restore option in Windows XP?()

  • A、Control Panel Administrative tools.
  • B、Control Panel Security Center.
  • C、System Properties, Start up and Recovery.
  • D、Help and support from the Start menu.

正确答案:D

第3题:

Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.


参考答案:B, C

第4题:

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday, client A drops a table at 8:00 a.m. as follows:  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9:00 a.m. on the same table as follows:  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1:  ORA/x7f00942: table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()

  • A、retrieve the table by using the flashback feature
  • B、restore all the data files from last Sunday’s backup, and then perform a time­based recovery
  • C、restore all the data files from last Sunday’s backup, and then perform a log sequence recovery
  • D、restore all the data files from last Sunday’s backup, and then perform a cancel­based recovery
  • E、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored, and then perform a complete recovery

正确答案:B

第5题:

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

正确答案:B

第6题:

A user reports that every time they start up their computer it stops with a bluescreen error. Whichof the following methods will give an alternate method of trying to start up a Windows computer?()

  • A、Press the F4 key during start up.
  • B、Hold down the left Shift key during start up.
  • C、Press the F2 key during start up.
  • D、Press the F8 key during start up.

正确答案:D

第7题:

In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()

  • A、 import the database from the last export
  • B、 restore all the members in the group from the last backup
  • C、 drop the lost member from the database and then add a new member to the group
  • D、 restore all the database files from the backup and then perform a complete recovery
  • E、 restore all the database files from the backup and then perform an incomplete recovery

正确答案:C

第8题:

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()

  • A、Take the USERS tablespace offline and re-create the lost data file.
  • B、Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
  • C、Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
  • D、Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

正确答案:C

第9题:

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.

正确答案:B

第10题:

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation?()

  • A、recover using Oracle Flashback Database technology
  • B、restore the data files from backup and perform a complete recovery
  • C、restore only the corrupted data file and perform tablespace recovery
  • D、restore the data files from backup and perform cancel-based recovery
  • E、restore the entire database from the most recent backup and start the instance and open the database

正确答案:E

更多相关问题