单选题You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）A V$SESSION B V$SYSSTAT C DBA_SEGMENTS D V$SORT_USAGE

第1题：

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

• A、V$SESSION 
• B、V$SYSSTAT 
• C、DBA_SEGMENTS 
• D、V$SORT_USAGE

第2题：

In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

• A、the V$LOG view
• B、the V$DBFILE view
• C、the V$LOGFILE view
• D、the V$INSTANCE_RECOVERY view
• E、Oracle Enterprise Manager Database Control

第3题：

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

• A、 V$SYSSTAT
• B、 V$SESSSTAT
• C、 V$RSRC_PLAN
• D、 V$RSRC_CONSUMER_GROUP

第4题：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

• A、 Query the V$FLASHBACK_DATABASE_LOG view.
• B、 Query the V$FLASHBACK_DATABASE_STAT view.
• C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
• D、 Query the V$RECOVERY_FILE_DEST view.

第5题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

• A、 Enable Flashback Data Archive for the tables.
• B、 Specify undo retention guarantee for the database.
• C、 Enable supplemental logging for the database.
• D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
• E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

第6题：

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

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

第7题：

What view might you use to try to determine how long a particular backup will take?（）

• A、V$SESSION_EVENT 
• B、V$SESSION 
• C、V$W0041ITS
• D、V$WAITSTAT 
• E、V$SESSION_LONGOPS 

第8题：

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

第9题：

You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

• A、the time when the last flashback operation in your database was performed
• B、the time when the first flashback operation in your database was performed
• C、a list of flashback operations performed in your database using SCN and time
• D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

第10题：

You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

• A、V$DATABASE 
• B、DBA_TABLES 
• C、SYSAUD$ 
• D、EMP