Introduction to MySQL Quiz

Challenge your MySQL knowledge with this quiz. Test your understanding of relational databases, queries, and data management.

Question 1

What does SQL stand for?

Structured Query Language Simple Query Language Standard Query Language Structured Quick Language

Question 2

Which command is used to select data in MySQL?

SELECT GET FETCH PICK

Question 3

Which of the following is used to filter results in a SQL query?

WHERE HAVING FILTER WHERE AND

Question 4

What is the default port for MySQL?

3306 8080 5432 9000

Question 5

Which type of JOIN returns all rows from the left table and matching rows from the right table?

LEFT JOIN INNER JOIN RIGHT JOIN FULL JOIN

Question 6

What does the 'LIMIT' clause do in SQL?

Restrict the number of records returned Order records Join tables Group records

Question 7

Which of the following data types are used for storing text in MySQL?

VARCHAR INT FLOAT DATE

Question 8

Which function is used to count rows in SQL?

COUNT() SUM() AVG() TOTAL()

Question 9

Which command is used to delete a table in MySQL?

DROP TABLE DELETE TABLE REMOVE TABLE TRUNCATE TABLE

Question 10

What is a primary key in MySQL?

A unique identifier for each record A foreign key A type of index A column for storing images

Question 11

Which of the following is NOT a MySQL data type?

BOOLEAN DATE VARCHAR STRING

Question 12

Which command is used to update data in a table?

UPDATE ALTER MODIFY EDIT

Question 13

Which clause is used in SQL to group rows that have the same values?

GROUP BY ORDER BY DISTINCT JOIN

Question 14

Which keyword is used to sort the result set in MySQL?

ORDER BY SORT BY GROUP BY DISTINCT

Question 15

Which of the following SQL statements is used to add a new column to an existing table?

ALTER TABLE UPDATE TABLE MODIFY TABLE ADD COLUMN

Question 16

How can you change a column type in MySQL?

ALTER COLUMN CHANGE COLUMN MODIFY COLUMN UPDATE COLUMN

Question 17

What does the 'UNION' operator do in SQL?

Combines results from two SELECT statements Joins two tables Filters data Aggregates data

Question 18

Which MySQL statement is used to create a new database?

CREATE DATABASE NEW DATABASE MAKE DATABASE BEGIN DATABASE

Question 19

Which of the following is true about the 'IN' operator in SQL?

It checks if a value matches any value in a list It matches only exact values It is used for string operations It is a built-in function

Question 20

Which of the following operators is used to perform a pattern match in SQL?

LIKE MATCH IN REGEX

Question 21

Which SQL function is used to return the current date in MySQL?

CURDATE() CURRENT_DATE() DATE_NOW() NOW()

Question 22

What is a foreign key?

A key from another table A unique key in the same table A non-nullable key A key for indexing

Question 23

Which function is used to round a number in MySQL?

ROUND() RND() TRUNC() FLOOR()

Question 24

Which of the following can be used to prevent SQL injection?

Using prepared statements Using SELECT statements Disabling SQL queries Using wildcards

Question 25

Which MySQL clause is used to sort the result-set?

ORDER BY SORT GROUP BY RANK

Question 26

Which of the following can be used to remove duplicate records from a SELECT query?

UNIQUE NO_DUPLICATE DISTINCT REMOVE

Question 27

What is the purpose of the 'LIKE' keyword in MySQL?

To match exact values To perform pattern matching To sort records To change values

Question 28

Which MySQL function returns the current date and time?

TIME() SYSDATE() NOW() GETDATE()

Question 29

What does the 'GROUP BY' clause do in a SELECT query?

Filters data Groups rows that have the same values Orders rows alphabetically Creates indexes

Question 30

What is a 'foreign key' in MySQL?

A unique identifier for rows A field that refers to the primary key in another table A column that stores passwords A backup key