Your database instance is running with full workload after d

第1题：

You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

• A、You performed rollback after commit.
• B、If a log switch occurs in your database.
• C、Thearchiverfails to generate an archived log file.
• D、Instance recovery fails to find one of the redo log files.
• E、A long-running query is unable to get read-consistent image.
• F、If you perform manual undo management operations in auto mode.

第2题：

You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）

• A、The instance would normally abort.
• B、The instance would not be affected.
• C、The instance would be invalid， so would have to be aborted.
• D、The instance would remain open， but the LGWR process would fail.
• E、The instance would remain open and would automatically create the missing file

第3题：

第4题：

Which two prerequisites are needed for performing workload capture and replay？（）

• A、Close all sessions performing queries using database links
• B、running the database in shared server mode
• C、The database on which the workload is replayed has to be a restore of the original database to a specific SCN
• D、setting up the directory to capture the workload

第5题：

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、the retention period to support flashback
• B、the expected length of the longest-running query
• C、the number of undo tablespaces in the database
• D、the size of the Flash Recovery Area for the database instance

第6题：

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）

• A、by using the SQL access advisor
• B、by using the Automatic Workload Repository report
• C、by running the Automatic Database Diagnostic Monitor （ADDM）
• D、by using the Automatic Workload Repository Compare Period report
• E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

第7题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

• A、 the datafiles associated with the SYSTEM tablespace
• B、 the datafiles associated to the DATA1 tablespace
• C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
• D、 all the datafiles in the database

第8题：

第9题：

You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）

• A、Start the instance and open the database， instance recovery automatically recoverscontrol files
• B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
• C、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）
• D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
• E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

第10题：

Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）

• A、The extents in undo tablespace retain data until the next full database backup.
• B、The extents containing committed data in the undo tablespace are never overwritten.
• C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
• D、The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.