GK Question

technology medium true_false

A clustered index determines the physical order of data in a table, and only one clustered index can exist per table.

  1. True
  2. False

Answer: True

Clustered index physically sorts table data rows based on index key values. Since data can be sorted in only one order, a table can have only one clustered index (usually on primary key). Non-clustered indexes store logical order separately with pointers to data rows; multiple non-clustered indexes are allowed.

Topic Database & Programming
Exam Relevance Banking, SSC JE, Railway