PrepAway - Latest Free Exam Questions & Answers

Tag: oracle database dynamic management views

What should you do to determine the dynamic management view that should be used?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com encompass administrating the SQL Server 2005 database named Certkiller -DB01.
Certkiller -DB01 contains a table that consists of a number of indexes. It has come to your attention that data modification performance has degraded and that some of the indexes are not used. You have received instruction from the CIO to determine which indexes are not used by queries since the last time Certkiller -DB01 started. You need to determine the dynamic management view that should be used.
What should you do?