单选题What view might you use to try to determine how long a particular backup will take？（）A  V$SESSION_EVENTB  V$SESSIONC  V$WAITSD  V$WAITSTATE  V$SESSION_LONGOPS

第1题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第2题：

You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

• A、 V$BACKUP_CORRUPTION
• B、 V$COPY_CORRUPTION
• C、 V$DATABASE_BLOCK_CORRUPTION
• D、 RC_BACKUP_CORRUPTION

第3题：

第4题：

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 

第5题：

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

第6题：

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

第7题：

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

第8题：

第9题：

Which view provides information on the backup status of the datafiles in the database？（）  

• A、 V$BACKUP
• B、 V$BACKUP_STATUS
• C、 V$BACKUP_DATAFILE
• D、 V$DATAFILE_BACKUP
• E、 V$TABLESPCE_BACKUP

第10题：

Which view provides information on the backup status of the datafiles in the database?（）

• A、V$BACKUP
• B、V$BACKUP_STATUS 
• C、V$BACKUP_DATAFILE 
• D、V$DATAFILE_BACKUP 
• E、V$TABLESPCE_BACKUP