SQL MCQ for Exams Quiz - 2

1. Which operator is used to select values within a range in SQL?

BETWEEN

WITHIN

RANGE

LIMIT

2. Which SQL function returns the smallest value from a specified column?

MIN()

LEAST()

SMALL()

LOWER()

3. How do you specify that a column cannot contain NULL values?

NOT EMPTY

NO NULL

IS EMPTY

NOT NULL

4. Which SQL clause is used to return only distinct (unique) values?

UNIQUE

DISTINCT

DIFFERENT

SEPARATE

5. What is the default sorting order in SQL when using the `ORDER BY` clause?

Descending

Ascending

Random

Alphabetical

6. Which SQL command is used to modify the structure of an existing table?

MODIFY

ALTER

UPDATE

CHANGE

7. Which SQL statement is used to insert a new row into a table?

INSERT INTO

ADD ROW

UPDATE ROW

NEW ROW

8. Which SQL keyword is used to join tables based on a condition?

UNION

LINK

JOIN

CONNECT

9. How do you retrieve records where a columns value is between two specific values?

SELECT * FROM table WHERE column IN (value1, value2)

SELECT * FROM table WHERE column BETWEEN value1 AND value2

SELECT * FROM table WHERE column RANGE value1 AND value2

SELECT * FROM table WHERE column >= value1 AND <= value2

10. Which SQL function calculates the average value of a numeric column?

AVG()

SUM()

MEAN()

MEDIAN()

---

---

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