Multiple Choice Questions on SQL Indexes
1) What is the purpose of index in SQL server?
a) It leads to enhance the query performance.
b) It leads to provide an index to a record.
c) It leads to perform fast searches.
d) None of the above
e) All of the above.
2) How many types of Indexes are there in SQL Server?
a) 1
b) 2
c) 3
d) 4
3) Which one is true about clustered index?
a) Clustered index is not associated with table at all.
b) Clustered Index is built by default on unique key columns.
c) Clustered Index is not at all built on unique key columns.
d) None of the above.
4) Table with clustered index are also called as clustered table?
a) True
b) False
5) How Non Clustered indexes points to the data?
a) It never points to anything.
b) It directly points to data row.
c) It is used for pointing data rows containing key values.
d) None of the above.
6) What is the syntax of creating Clustered Index with SQL query?
a) CREATE CLUSTERED INDEX Index_name ON Table_Name (Column_Name)
b) CREATE CLUSTERED INDEX ON Table_Name (Column_Name) WITH Index_name
c) CREATE CLUSTERED INDEX ON Table_Name
d) Clustered Index can’t be created with SQL Query.
7) What is true about indexes?
a) Index leads to enhance the performance even if the table is being updated so frequently.
b) It makes harder for SQL Server engine to work on indexes which have large key.
c) It doesn’t make harder for SQL Server engine to work on indexes which have large key.
d) None of the above.
8) Index sorts the records into a special data structure which is known as a B-tree?
a) True
b) False
9) Does index take space in Disk?
a) It stores in memory as and when required.
b) Yes, Indexes are stored on the disk.
c) Indexes are never stored on the disk.
d) Index takes no space.
10) What are composite indexes?
a) Are those which are composed by database for its internal use.
b) A composite index is combination of index on 2 or more columns.
c) Composite indexes can never be created.
d) None of the above
Answers