All challenges
Multiple ChoiceIntermediate 30s

Index Purpose

Choose the best answer for: database indexes
Options
  1. 1Indexes slow down all queries and consume extra disk space
  2. 2Indexes speed up SELECT queries at the cost of write performance
  3. 3Indexes replace primary keys as the unique row identifier
  4. 4Indexes are for sorting only and never actually speed reads

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle