SQL MCQ for Exams Quiz - 1

1. What does SQL stand for?

Structured Query Language

Simple Query Language

Sequential Query Language

Standard Query Language

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

INSERT

SELECT

UPDATE

DELETE

3. Which SQL clause is used to filter the result set based on a condition?

ORDER BY

GROUP BY

WHERE

HAVING

4. What is the function of the `COUNT()` function in SQL?

Counts the number of columns

Counts the number of rows

Counts the number of tables

Counts the number of views

5. Which SQL statement is used to remove data from a table?

DELETE

DROP

REMOVE

ALTER

6. Which SQL keyword is used to sort the result-set?

GROUP BY

ORDER BY

HAVING

SORT

7. How do you select all the columns from a table named "Customers"?

SELECT * FROM Customers

SELECT Customers

SELECT ALL FROM Customers

SELECT COLUMNS FROM Customers

8. Which SQL function is used to extract a portion of a string?

TRIM()

SUBSTRING()

LENGTH()

REPLACE()

9. What is the SQL command to create a new table?

CREATE TABLE

ADD TABLE

NEW TABLE

INSERT TABLE

10. Which SQL clause is used to group the result set based on one or more columns?

ORDER BY

GROUP BY

HAVING

DISTINCT

---

---

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