🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Every column
  2. B.Only DATE columns
  3. C.PRIMARY KEY and UNIQUE columns
  4. 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 →