🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Query Processing and Optimization: all 10 questions

Quiz: Query Processing and Optimization · Question 3 of 10

A table has 20,000 rows and the column dept has 40 distinct values. About how many rows does the optimizer estimate for…

A table has 20,000 rows and the column dept has 40 distinct values. About how many rows does the optimizer estimate for dept = 'CSE'?

  1. A.40
  2. B.800
  3. C.20,000
  4. D.500
Answer & explanation

Correct answer: 500

n_r / V(A, r) = 20,000 / 40 = 500, assuming values are evenly spread.

Can you get the rest right without peeking?

Take the timed Quiz: Query Processing and Optimization quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →