You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、U

第1题：

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

• A、All control files are opened
• B、All redo files are opened
• C、The password file is opened
• D、The parameter file is opened
• E、All online data files are opened

第2题：

You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

• A、3 hours
• B、6 months
• C、until last year
• D、until last commit
• E、until the point when the undotablespacewas refreshed
• F、until the database is shut down and the memory erased

第3题：

You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）

• A、Restart the database instance and run the job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job

第4题：

You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

• A、Increase the undo return
• B、Create more undo segments
• C、Create another undotablespace
• D、Increase the size of the undotablespace

第5题：

You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）

• A、PMON coordinates media recovery.
• B、SMON coordinates instance recovery.
• C、PMON coordinates instance recovery.
• D、Undo Advisor would roll back all uncommitted transactions.
• E、SQL*PLUS reports an error with the message asking you to perform instance recovery. 

第6题：

You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）

• A、Event Viewer gives more details on the failure.
• B、The alert log file gives detailed information about the failure.
• C、PMON rolls back the transaction and releases the locks.
• D、SMON rolls back the transaction and releases the locks.
• E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
• F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

第7题：

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

第8题：

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

• A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
• B、 restore the entire database from the most recent backup and open it
• C、 recover the table by using the Flashback Table feature
• D、 perform point-in-time recovery to recover the table

第9题：

第10题：

第11题：

第12题：

第13题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第14题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第15题：

Which three statements are true about Flashback Database?（）

• A、Flashback logs are written sequentially, and are archived.
• B、Flashback Database uses a restored control file to recover a database.
• C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

第16题：

One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）

• A、uses undo data for roll forward
• B、uses Flashback Log for recovery
• C、uses online redo logs to roll back
• D、uses undo data to roll back the transaction
• E、uses Recovery Manager （RMAN） to roll back
• F、uses the System Monitor （SMON） background process to perform instance recovery

第17题：

You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

• A、 by using the Flashback Database feature
• B、 by using RMAN incomplete recovery
• C、 by performing a user-managed incomplete recovery
• D、 by dropping and re-creating the index tablespace

第18题：

You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and perform tablespace recovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第19题：

You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

• A、The trace file
• B、The fixed views
• C、The data dictionary views
• D、The operating system log fields
• E、The dynamic performance views.

第20题：

第21题：

第22题：

第23题：