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 *


Time limit is exhausted. Please reload CAPTCHA.