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?
- 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
- B.
An INDEX speeds up searches, but a PRIMARY KEY does not.
- C.
A PRIMARY KEY can only be applied to numeric columns, whereas an INDEX can be applied to any column type.
- 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 freeLoading lesson…

