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

Which index does InnoDB use to physically store the table rows?

  1. A The clustered index (primary key)
  2. B Any secondary index
  3. C The first index created
  4. D A hash index
Answer

The clustered index (primary key)

InnoDB stores the full row in the leaves of the clustered index. Secondary indexes store the indexed columns plus the primary key value.

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