You are working on the 24X7 database with high transaction v

第1题：

You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）

• A、The database performance would be enhanced.
• B、The redo log files would be get filled more frequently.
• C、The overall database performance would be degraded.
• D、The mean time to recover （MTTR） would be increased.

第2题：

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

• A、 VERSIONS_STARTSCN
• B、 VERSIONS_STARTTIME
• C、 VERSIONS_XID
• D、 VERSIONS_OPERATION

第3题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

• A、 You must use automatic undo management in the database.
• B、 You must configure OMF in your database.
• C、 You must configure ASM for storing the datafiles.
• D、 You must multiplex the online redo log file.

第4题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

• A、 To recover a dropped table.
• B、 To recover a dropped schema.
• C、 To recover data from a truncated table.
• D、 To view changes made by all the transactions during a given period of time.
• E、 To view changes made by a single transaction during a given period of time.

第5题：

In which two cases would you perform only consistent backup？（）

• A、You are working on a database where downtime is not tolerated.
• B、You are working on a database where downtime can be tolerated.
• C、You are working on a database that operates in ARCHIVELOG mode.
• D、You are working on a database that operates in NOARCHIVELOG mode.
• E、You are working on a database where all the tablespaces are locally managed.
• F、You are working on a database where control files and redo log files are multiplexed.
• G、You are working on a database where control files and redo log files are not multiplexed.

第6题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

• A、 V$FLASHBACK_DATABASE_LOG
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$DATABASE
• D、 V$UNDOSTAT

第7题：

You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

• A、The database crashes.
• B、The DBA needs to re-create the file.
• C、The file gets re-created automatically.
• D、The file gets restored automatically from the last backup.
• E、The DBA needs to perform a complete database recovery.
• F、The DBA needs to perform an incomplete database recovery.

第8题：

You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）

• A、The online redo log files and archived redo log files are required to accomplish the recovery.
• B、The uncommitted transaction will be committed at the next startup of the database instance.
• C、The uncommitted transaction is rolled back automatically at the next opening of the database.
• D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

第9题：

In the absence of shared storage between cluster nodes, which two actions can you take to configure a High Availability architecture?（）

• A、Move domain logs to a highly available database.
• B、Move server logs to a highly available database.
• C、Move transaction logs to a highly available database. 
• D、Move JMS persistent stores to a highly available database.
• E、Move error logs to a highly available database.

第10题：

You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

• A、 perform point-in-time recovery
• B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
• C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
• D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery