INTERVIEW QUESTIONS
Subject : MySql
LEVEL : BASICS
1. What is data? What is information?
2. What is Database?
3. What is the difference between file system and DBMS?
4. What is No SQL?
5. Different types of DBMS?
6. What is RDBMS?
7. What are the datatypes in MySql?
8. What are DDL,DML,DCL,TCL commands? Explain with
examples.
9. What is the difference between DROP and TRUNCATE in
MySQL?
10. How do you modify the structure of an existing table in
MySQL?
11. What is the purpose of the CREATE TABLE command?
Provide syntax.
12. How can you rename a column or table in MySQL?
13. Can you add multiple columns to a table in a single ALTER
TABLE statement? Give
an example.
14. What are the integrity constraints in MySql?
15. What is the difference between DELETE and TRUNCATE?
16. How can you insert multiple rows into a table using a single
INSERT statement?
17. Explain how to update specific rows in a table with an
example.
18. What is the difference between WHERE and HAVING in a
SELECT statement?
MYSQLBASICINTERVIEWQUESTIONS
19. Explain GROUP BY , ORDER BY, HAVING clauses in
MySql.
20. Explain IN, AND, NOT, ANY, ALL, BETWEEN, LIKE
keywords.
21. What is the use of the GRANT command in MySQL?
22. How do you revoke permissions from a user in MySQL?
23. What types of privileges can be granted to a MySQL user?
24. How do you list the privileges granted to a user in MySQL?
MYSQL BASIC INTERVIEW QUESTIONS PREPARED BY
RAJ KIRAN K (TechForBtechs)
25. What is the difference between ALL PRIVILEGES and
specific privileges like
SELECT, INSERT?
26. What is a transaction in MySQL and how is it started?
27. What is the purpose of COMMIT and ROLLBACK in
MySQL?
28. How does SAVEPOINT work in a transaction? Give an
example.
29. What happens if AUTOCOMMIT is set to 0 in MySQL?
30. How would you rollback to a specific point in a transaction?
MYSQLBASICINTERVIEWQUESTIONS
