Question

answer the following so i can double check my answers. use sql knowledge

Question 1

1. A table may have more than on clustered index.

   True

   False

10 points

Question 2

1. All columns in a covering index must be from the same table.

   True

   False

10 points

Question 3

1. Clustered indexes hold the data, not pointers to the data.

   True

   False

10 points

Question 4

1. It is a good idea to index BLOB objects.

   True

   False

10 points

Question 5

1. A nonclustered index does not store the table data itself.

   True

   False

10 points

Question 6

1. It is a good idea to build an index on a column that is needed in a sorted order.

   True

   False

10 points

Question 7

1. It is a good idea to build an index on the gender (male/female) of a person.

   True

   False

10 points

Question 8

1. A nonclustered index stores pointers to the table data or clustered index as part of the index keys.

   True

   False

10 points

Question 9

1. A nonclustered index is stored in the actual table structure.

   True

   False

10 points

Question 10

1. It is not possible to create the nonclustered index on a different filegroup from the base table.

   True

   False

10 points

Question 11

1. When a nonclustered index is created, the information used to build the index is placed in the same location as the table and therefore can't be stored on a different physical disk.

   True

   False

10 points

Question 12

1. Unique indexes are commonly implemented to support constraints such as the primary key and clustered indexes.

   True

   False

10 points

Question 13

1. If the selectivity of the data in the index columns is poor, the effectiveness of the index will be reduced.

   True

   False

10 points

Question 14

1. The more columns there are in an index, the more data writing has to take place when a process completes an update or an insertion of data.

   True

   False

10 points

Question 15

1. SQL Server keeps statistics on each column contained within an index if you have Auto Colulmn Statistics set to True.

   True

   False

Answer 1

1. False

Explanation: A clustered index tells about the order in which data is stored in table. Data can be stored only in one way,so there can be only one clustered index.Primary key constraints take care of that.

2. TRUE

EXPLANATION: yes, all columns must be from same table

3. TRUE

Explanation: the data in the table are stored on disk in the same order as the clustered index.

4. False:

Explanation: it is not advisable to index binary data.

5. TRUE:

Explanation: pointer to the data row is stored instead of data.

6. TRUE:

Explanation: indexing is done to sort the data

7. False

Explanation: Gender column can have only 3 values, it's bad practice to index that column.

8. true

Explanation: that is true about non-clustered index

9. false

Explanation: index is not stored in actual table structure.

10. True

Explanation: yes, we can move non-clustered index to other filegorup

11. False:

Explanation: no, we can't do that

12. True

Explanation: yes both primary and clustered index should be unique

13. true

Explanation: that is true statement

14. True

Explanation: yes , updation are insertion is prefred first

15. False

Explanation: no, that is not the true statement