SQL MCQ for Exams Quiz - 3

1. Which SQL keyword is used to remove a table from a database?

DROP

DELETE

REMOVE

ERASE

2. Which SQL statement is used to change the data in a table?

ALTER

UPDATE

CHANGE

MODIFY

3. What does the SQL `LIKE` operator do?

Finds exact matches

Compares column data with regular expressions

Searches for patterns in a column

Sorts values in a column

4. Which wildcard character is used with the `LIKE` operator to represent zero or more characters?

?

_

%

*

5. Which clause is used to specify conditions on aggregated results (like using `GROUP BY`)?

WHERE

HAVING

ORDER BY

LIMIT

6. How do you rename a column in SQL using the `SELECT` statement?

SELECT column AS new_name

SELECT column RENAME new_name

SELECT column CHANGE new_name

SELECT column SET new_name

7. Which SQL command is used to combine the results of two queries?

UNION

COMBINE

MERGE

JOIN

8. What does the `TRUNCATE` statement do in SQL?

Deletes specific rows

Deletes all rows in a table without logging individual row deletions

Deletes the table structure

Modifies a table structure

9. How do you add a new column to an existing table?

MODIFY TABLE table_name ADD COLUMN column_name

UPDATE TABLE table_name ADD COLUMN column_name

ALTER TABLE table_name ADD column_name datatype

INSERT INTO table_name ADD COLUMN column_name

10. Which SQL statement is used to delete a database?

DELETE DATABASE

DROP DATABASE

REMOVE DATABASE

ERASE DATABASE

---

---

Your Result

Your Score

Score in percentage

Answers 1

Answers 2

Answers 3

Answers 4

Answers 5

Answers 6

Answers 7

Answers 8

Answers 9

Answers 10