MySQL important Questions And Answers

MySQL Basic Questions and Answers (MCQ) 🕵️

1. Which command is used to create a new database in MySQL?

A) CREATE TABLE
B) CREATE DATABASE ✅
C) NEW DATABASE
D) ADD DATABASE

2. Which symbol is used for comments in MySQL (single line)?

A) -- ✅
B) //
C) #include
D) /**/

3. What is the default port number for MySQL?

A) 1521
B) 1433
C) 3306 ✅
D) 8080

4. Which data type is used to store decimal numbers in MySQL?

A) VARCHAR
B) DECIMAL ✅
C) CHAR
D) TEXT

5. Which SQL clause is used to filter records?

A) ORDER BY
B) GROUP BY
C) WHERE ✅
D) SELECT

6. Which statement is used to retrieve data from a database?

A) GET
B) SELECT ✅
C) FETCH
D) RETRIEVE

7. Which keyword is used to sort the result-set in ascending order by default?

A) ORDER BY ✅
B) SORT BY
C) GROUP BY
D) SEQUENCE

8. Which function is used to count rows in MySQL?

A) SUM()
B) COUNT() ✅
C) ROWS()
D) TOTAL()

9. Which command deletes all records but keeps the table structure?

A) DROP
B) DELETE
C) TRUNCATE ✅
D) REMOVE

10. Which clause is used with aggregate functions?

A) WHERE
B) GROUP BY ✅
C) ORDER BY
D) HAVING

11. What is the maximum length of a VARCHAR column in MySQL?

A) 255 ✅
B) 65,535
C) 1,000
D) 512

12. Which MySQL engine supports transactions?

A) MyISAM
B) InnoDB ✅
C) MEMORY
D) CSV

13. Which SQL keyword is used to remove duplicate rows in result?

A) UNIQUE
B) DISTINCT ✅
C) ONLY
D) DIFFERENT

14. Which SQL clause is used to rename a column in result-set?

A) AS ✅
B) RENAME
C) CHANGE
D) ALTER

15. Which function returns the current date in MySQL?

A) TIME()
B) SYSDATE() ✅
C) CURTIME()
D) NOWTIME()

16. Which operator is used for pattern matching in MySQL?

A) BETWEEN
B) LIKE ✅
C) MATCH
D) SEARCH

17. Which MySQL command is used to show all databases?

A) SHOW ALL
B) SHOW DATABASES ✅
C) LIST DATABASES
D) DESCRIBE DATABASE

18. Which SQL statement is used to update data in MySQL?

A) MODIFY
B) CHANGE
C) UPDATE ✅
D) ALTER

19. Which command is used to delete a database?

A) REMOVE DATABASE
B) DROP DATABASE ✅
C) DELETE DATABASE
D) CLEAR DATABASE

20. What is the default storage engine in MySQL (latest versions)?

A) MyISAM
B) InnoDB ✅
C) MEMORY
D) ARCHIVE

21. Which SQL command is used to add a new column?

A) INSERT COLUMN
B) ALTER TABLE … ADD COLUMN ✅
C) UPDATE TABLE
D) CREATE COLUMN

22. Which keyword is used to combine rows from two queries?

A) INTERSECT
B) UNION ✅
C) JOIN
D) COMBINE

23. What is the result of SELECT 2+3; in MySQL?

A) 23
B) 5 ✅
C) Error
D) NULL

24. Which statement creates a new table in MySQL?

A) CREATE DATABASE
B) CREATE SCHEMA
C) CREATE TABLE ✅
D) ADD TABLE

25. Which statement is used to see table structure?

A) SHOW STRUCTURE
B) DESCRIBE table_name ✅
C) VIEW TABLE
D) INFO TABLE