Thách thức mọi câu hỏi phỏng vấn MySQL dành cho lập trình viên

What is the difference between commands create database and create schema in MySQL?

Explain GRANT command in MySQL

What is the use of DELIMETER command in MySQL?

What is mysqldump ?

What is index in MySQL? What is advantage of index?

What different stored objects are supported in MySQL?

What are Derived Columns. What possible problems can a derived column pose?

Both TIMESTAMP and DATETIME are used to store data and time. Explain difference between them and when
should one be used?

What are REPEAT , LOOP and WHILE statements used for?

What are key constraints. What different types of constraints are there in MySQL?

What is the use of IN and BETWEEN in MySQL queries?

What is Stored Function in MySQL. How are they different from Stored Procedure?

What is MySQL Workbench?

How can VIEW be used to provide security layer for your app?

What is a trigger. What are different type of triggers in MySQL?

What is difference between BLOB and TEXT in MySQL?

Explain the use of FEDERATED tables in MySQL

What are different TEXT data types in MySQL. What is difference between TEXT and VARCHAR ?

What happens if a parent row which is referenced by child row is being deleted in case of foreign key constraint?