Multiple Choice Questions (MCQs) can significantly enhance your learning experience. They offer a quick and effective way to test your knowledge, helping you identify what you’ve mastered and where you need more study.

With immediate feedback, you can quickly correct mistakes and reinforce your understanding. MCQs are also engaging and less intimidating than long-form tests, making learning more enjoyable and motivating.

By using MCQs, you’ll feel more confident and prepared for any topic.

 

10. How would you write a query to find all records where a column value matches the pattern '%SQL%'?

'SELECT * FROM table WHERE column LIKE '%SQL%';'

'SELECT * FROM table WHERE column = '%SQL%''

'SELECT * FROM table WHERE column IN ('%SQL%');'

9. What does the INTERSECT operator do?

Returns the result set of two or more SELECT statements

Combines the result set of two or more SELECT statements

Returns the intersection of two or more SELECT statements

8. Which operator would you use to check if a value exists in a subquery?

'IN'

'EXISTS'

'ALL'

7. What is the result of SELECT 10 + 5 * 2;?

20

25

30

6. How would you write a query to find all records where a column value is not null?

SELECT * FROM table WHERE column IS NOT NULL;

SELECT * FROM table WHERE column = NOT NULL;

SELECT * FROM table WHERE column != NULL;

5. What is the purpose of the COALESCE operator?

Returns the first non-null value in a list

Concatenates strings

Performs arithmetic operations

4. How would you write a query to find all records where a column value is equal to 10 or 20?

SELECT * FROM table WHERE column = 10 AND column = 20;

SELECT * FROM table WHERE column BETWEEN 10 AND 20;

SELECT * FROM table WHERE column IN (10, 20);

3. What does the EXCEPT operator do?

Returns the result set of two or more SELECT statements

Combines the result set of two or more SELECT statements and removes duplicates

Returns the difference between two SELECT statements

2. Which operator is used to exclude duplicate rows from a result set?

UNION

UNION ALL

DISTINCT

1. What is the result of SELECT 9 * 3;?

27

12

8