MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What is the difference between primary key and candidate key?

Every row of a table is identified uniquely by the primary key. There is only one primary key for a table.

Primary Key is also a candidate key. By common convention, the candidate key can be designated as primary and which can be used for any foreign key references.




Next 5 interview question(s)

1
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
2
What are the drivers in MySQL?
3
What storage engines are used in MySQL?
4
Give string types available for column?
5
Difference between CHAR and VARCHAR?