MySQL MCQs with answers Page - 164

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 MySQL
Q. What does this query return?
Code: 
SELECT CONCAT('My', 'SQL');
  • (A) My SQL
  • (B) My-SQL
  • (C) MySQL
  • (D) Error
💬 Discuss
✅ Correct Answer: (C) MySQL

Explanation: `CONCAT()` joins two or more strings together.

📊 MySQL
Q. Which keyword is used to remove all records from a table without deleting the structure?
  • (A) DELETE
  • (B) DROP
  • (C) TRUNCATE
  • (D) REMOVE
💬 Discuss
✅ Correct Answer: (C) TRUNCATE

Explanation: `TRUNCATE` removes all records but keeps the table structure intact.

📊 MySQL
Q. Which command is used to view all databases in MySQL?
  • (A) SHOW DATABASES;
  • (B) LIST DATABASES;
  • (C) SELECT ALL DATABASES;
  • (D) DISPLAY DATABASES;
💬 Discuss
✅ Correct Answer: (A) SHOW DATABASES;

Explanation: `SHOW DATABASES;` lists all databases available on the server.

📊 MySQL
Q. Which command gives you the structure of a table?
  • (A) SHOW ALL FROM table;
  • (B) SHOW COLUMNS FROM table;
  • (C) DESCRIBE table;
  • (D) LIST table;
💬 Discuss
✅ Correct Answer: (C) DESCRIBE table;

Explanation: `DESCRIBE table;` shows column definitions and other metadata.

📊 MySQL
Q. What does `UNION` do in SQL?
  • (A) Combines rows from two tables and removes duplicates
  • (B) Updates records in two tables
  • (C) Creates a new table
  • (D) Links tables permanently
💬 Discuss
✅ Correct Answer: (A) Combines rows from two tables and removes duplicates

Explanation: `UNION` combines results of two `SELECT` queries and removes duplicate rows.

📊 MySQL
Q. Which MySQL function is used to get the current date and time?
  • (A) GETDATE()
  • (B) NOW()
  • (C) SYSDATE()
  • (D) CURRENT()
💬 Discuss
✅ Correct Answer: (B) NOW()

Explanation: `NOW()` returns the current date and time in MySQL.

📊 MySQL
Q. What does this query do?
Code: 
SELECT name FROM students WHERE age BETWEEN 18 AND 22;
  • (A) Selects students older than 18
  • (B) Selects students younger than 22
  • (C) Selects students aged exactly 18 and 22
  • (D) Selects students aged between 18 and 22 inclusive
💬 Discuss
✅ Correct Answer: (D) Selects students aged between 18 and 22 inclusive

Explanation: `BETWEEN` includes both boundary values: 18 and 22.

📊 MySQL
Q. Which SQL keyword is used to remove duplicate rows from the result set?
  • (A) REMOVE DUPLICATES
  • (B) DISTINCT
  • (C) UNIQUE
  • (D) DELETE DUPLICATE
💬 Discuss
✅ Correct Answer: (B) DISTINCT

Explanation: `DISTINCT` eliminates duplicate values from the result.

📊 MySQL
Q. What does `AUTO_INCREMENT` do in MySQL?
  • (A) Creates an index automatically
  • (B) Inserts random values
  • (C) Automatically increases column value
  • (D) Sorts values in ascending order
💬 Discuss
✅ Correct Answer: (C) Automatically increases column value

Explanation: `AUTO_INCREMENT` is used for automatically incrementing a numeric column.

📊 MySQL
Q. Which clause is used with GROUP BY to filter grouped results?
  • (A) WHERE
  • (B) HAVING
  • (C) IF
  • (D) FILTER
💬 Discuss
✅ Correct Answer: (B) HAVING

Explanation: `HAVING` is used to filter groups created by `GROUP BY`.

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play