"Clustered vs Nonclustered"

1. What is the primary characteristic of a clustered index?

It allows for multiple indexes on the same table. The leaf level is the table itself. It can be on any column without restriction. It must be unique.

2. Which of the following properties is NOT a desired characteristic of a good clustered key?

Narrow Ever-increasing Can be non-unique Static

3. Why might a reporting table benefit from a clustered index on '(OrderDate, OrderId)' instead of just 'OrderId'?

It reduces storage requirements. It allows for faster writes. It places related rows physically adjacent. It prevents the need for indexes altogether.

4. What is a heap in the context of database tables?

A table without any indexes at all. A clustered index on multiple columns. A temporary table for staging data. The default type of index in SQL Server.

Continue: "Composite Key Order and INCLUDE" → Review this lesson Retake quiz