Index Definition in SQL

1.

What is true about indexes?

   A.) Indexes enhance the performance even if the table is updated frequently
   B.) It makes harder for sql server engines to work to work on index which have large keys
   C.) It doesn’t make harder for sql server engines to work to work on index which have large keys
   D.) None of the mentioned

Answer: Option 'B'

It makes harder for sql server engines to work to work on index which have large keys

2.

What are composite indexes ?

   A.) Are those which are composed by database for its internal use
   B.) A composite index is a combination of index on 2 or more columns
   C.) Composite index can never be created
   D.) None of the mentioned

Answer: Option 'B'

A composite index is a combination of index on 2 or more columns

3.

A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.

   A.) Clustered
   B.) Non Clustered
   C.) Covering
   D.) B-Tree

Answer: Option 'C'

Covering

4.

How many types of indexes are there in sql server?

   A.) 1
   B.) 2
   C.) 3
   D.) 4

Answer: Option 'B'

2

5.

How non clustered index point to the data?

   A.) It never points to anything
   B.) It points to a data row
   C.) It is used for pointing data rows containing key values
   D.) None of the mentioned

Answer: Option 'C'

It is used for pointing data rows containing key values

Index Definition in SQL Download Pdf