← Quiz: Indexing: all 10 questions
Quiz: Indexing · Question 10 of 10
Which columns get an index automatically in most databases?
Which columns get an index automatically in most databases?
- A.Every column
- B.Only DATE columns
- C.PRIMARY KEY and UNIQUE columns
- D.Only foreign keys
Answer & explanation
Correct answer: PRIMARY KEY and UNIQUE columns
The database needs these indexes to enforce uniqueness quickly.
Can you get the rest right without peeking?
Take the timed Quiz: Indexing quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →