Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

In EXPLAIN output, which value in the type column indicates a full table scan?

  1. A const
  2. B ref
  3. C range
  4. D ALL
Answer

ALL

ALL means every row is examined. On a large table this usually signals a missing or unusable index.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as