Which step is required for recover from an instance failure? ()
第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?()
第2题:
Which of the following locations contains the System Restore option in Windows XP?()
第3题:
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.
第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?()
第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?()
第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?()
第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?()
第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()
第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?()
第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?()