Multiple Choice Questions on Indexes
1. A nonclustered index greatly affect the ordering and storing of the data.
A) True
B) False
2. Full-text indexes are created using the
A) Create Index
B) Create Fulltext Index
C) Special System Stored Procedures
D) Both b & c
3. A ................ index is one which satisfies all requested columns in a query without performing a further lookup into the clustered index.
A) Clustered
B) Non-Clustered
C) Covering
D) B-tree
4. Each database can have only one clustered index.
A) True
B) False
5. While creating an index on a column(s) in MS SQL Server you can specify that the index on each column be either ascending or descending and this affects the performance.
A) True
B) False
6. In a ..................., the first row added to the indexis the first record in the table, the second row is the second record in the table and so on.
A) Clustered
B) Non-Clustered
C) Heap
D) CharIndex
7. In ........... index, instead of storing all of the columns for a record together, each column is stored separately with all of the other rows in an index.
A) Clustered
B) Column Store
C) Non-Clustered
D) Row Store
8. Without primary key, the creation of spatial index will not succeed.
A) True
B) False
9. If an index is ............................. the metadata and statistics continue to exist.
A) disabling
B) dropping
C) altering
D) Both a & b
10. Index rebuild and index reorganize is one and the same thing.
A) True
B) False
Answers
1. A nonclustered index greatly affect the ordering and storing of the data.
A) True
B) False
2. Full-text indexes are created using the
A) Create Index
B) Create Fulltext Index
C) Special System Stored Procedures
D) Both b & c
3. A ................ index is one which satisfies all requested columns in a query without performing a further lookup into the clustered index.
A) Clustered
B) Non-Clustered
C) Covering
D) B-tree
4. Each database can have only one clustered index.
A) True
B) False
5. While creating an index on a column(s) in MS SQL Server you can specify that the index on each column be either ascending or descending and this affects the performance.
A) True
B) False
6. In a ..................., the first row added to the indexis the first record in the table, the second row is the second record in the table and so on.
A) Clustered
B) Non-Clustered
C) Heap
D) CharIndex
7. In ........... index, instead of storing all of the columns for a record together, each column is stored separately with all of the other rows in an index.
A) Clustered
B) Column Store
C) Non-Clustered
D) Row Store
8. Without primary key, the creation of spatial index will not succeed.
A) True
B) False
9. If an index is ............................. the metadata and statistics continue to exist.
A) disabling
B) dropping
C) altering
D) Both a & b
10. Index rebuild and index reorganize is one and the same thing.
A) True
B) False
Answers