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

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

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

What are REPEAT , LOOP and WHILE statements used for?

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

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

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

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

What is the use of DELIMETER command in MySQL?

Explain GRANT command in MySQL

What is MySQL Workbench?

What is difference between BLOB and TEXT in MySQL?

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

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

Explain the use of FEDERATED tables in MySQL

What different stored objects are supported in MySQL?

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

What is mysqldump ?

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

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