In MySQL, what is the key difference between a PRIMARY KEY index and a regular…

GPSC College Teaching (CS/IT) 2025

In MySQL, what is the key difference between a PRIMARY KEY index and a regular INDEX?

  1. A.

    A PRIMARY KEY must contain a unique value for each row and cannot contain NULL values, while a regular INDEX can have duplicate values

  2. B.

    An INDEX speeds up searches, but a PRIMARY KEY does not.

  3. C.

    A PRIMARY KEY can only be applied to numeric columns, whereas an INDEX can be applied to any column type.

  4. D.

    A table can have multiple PRIMARY KEY indexes but only one INDEX.

Attempted by 83 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…