V$SESSION_EVENT
V$SESSION
V$WAITS
V$WAITSTAT
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?()
第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?()
第3题:
A.V$SESSION_EVENT
B.V$SESSION
C.V$WAITS
D.V$WAITSTAT
E.V$SESSION_LONGOPS
第4题:
What view might you use to try to determine how long a particular backup will take?()
第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?()
第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?()
第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?()
第8题:
A.V$SESSION_EVENT
B.V$SESSION
C.V$WAITS
D.V$WAITSTAT
E.V$SYSSTAT
第9题:
Which view provides information on the backup status of the datafiles in the database?()
第10题:
Which view provides information on the backup status of the datafiles in the database?()