Interview Questions - MySQL Interview Questions

Database testing basically include the following.

1)Data validity testing.

2)Data Integritity testing

3)Performance related to data base.

Using DATEDIFF()

SELECT DATEDIFF(NOW(),'2007-07-15');

Ans:

CHAR is a fixed length data type.

SELECT CURTIME();
SELECT CURDATE();
SELECT CURRENT_TIME();
SELECT CURRENT_DATE();

Ans:

MySQL SET function can take zero or more values, but at the maximum it can take 64 values.

Links