Multiple choice technology databases

Choose the incorrect option about the sql server index

  1. Indexes use B-TREE for searching data.

  2. Can create more than one non clustered index on a table.

  3. Up to 256 columns can be combined into a single composite index key.

  4. If not specified, a nonclustered index is created.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Server indexes do use B-TREE structures (A is true), allow multiple nonclustered indexes per table (B is true), and create a nonclustered index by default when not specified (D is true). However, the limit for composite index columns is much lower than 256 - it's 16 columns (32 in some newer versions with limitations), making option C incorrect.

Keep practicing — related questions