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.