Rigorous Mysql Test - 84+ MCQs: MySQL test: Assess Your Database Skills with MySQL Questions and Answers

1. What is the purpose of the SQL INNER JOIN clause?

To include all rows from both tables in the result set

To include only the rows that have matching values in both tables

To exclude rows that have matching values in both tables

To filter rows based on a condition

2. Which SQL function is used to calculate the average value of a numeric column?

COUNT()

SUM()

AVG()

MAX()

3. What is the purpose of the MySQL LIMIT clause?

To limit the number of rows returned by a query

To filter data

To group rows that have the same values

To create a new table

4. What is a foreign key in MySQL?

A key used to open a foreign database

A primary key of another table that is used to establish a link between the tables

A key used to encrypt data

A unique identifier for a row in a table

5. Which SQL statement is used to add a new row to a table?

INSERT INTO

ADD ROW

CREATE ROW

ADD RECORD

6. What is the result of combining two or more tables in SQL called?

Table union

Table intersection

Table combination

Table join

7. What is the purpose of the SQL TRUNCATE TABLE statement?

To delete all rows from a table

To add a new column to a table

To change the data type of a column

To modify the structure of a table

8. What does the SQL DELETE statement do?

Deletes all data from a table

Deletes a table structure

Deletes specific rows from a table

Deletes a database

9. Which SQL keyword is used to insert data into a table?

INSERT

SELECT

UPDATE

DELETE

10. Which SQL statement is used to remove a table from a database?

DELETE TABLE

DROP TABLE

REMOVE TABLE

REMOVE FROM

MySQL MCQ Test 5