Only case 1
Only case 2
Only case 3
Case 1 and 2
Case 2 and 3
Case 1 and 3
All cases, case 1, case 2, case 3
第1题:
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?()
第2题:
Which of the following options is true about shutting down an Automatic Storage Management (ASM) instance?()
第3题:
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL> shutdown immediate;What is the result of executing this command?()
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
第4题:
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()
第5题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第6题:
If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?()
第7题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()
第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 have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()
第10题:
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()