Index Exam

Download PDF

Test…test.  this is only a test.

Each questions is worth between 0 and 10 points, with the correct answer being worth 10, the worst answer being worth 0, and questions that are partially right, or not horrible are somewhere between 0 and 10.

This is an evaluation to determine if you have the right information to be creating create indexes.
With indexes a little information can be more dangerous than not knowing about indexes.

Does adding an index always improve performance?


How many columns is too many in an index?


If 2 indexes are added to a table with the exact same columns in the same order, what does it do to performance?


What is the best data type to use for a clustered index?

Best implies best for overall system performance, maintenance, sustainability.


Question 1 of 4


Leave a Reply

Your email address will not be published. Required fields are marked *


4 × two =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions