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 is null?

'SELECT * FROM table WHERE column = NULL;'

'SELECT * FROM table WHERE column IS NULL;'

'SELECT * FROM table WHERE column LIKE NULL;'

9. What is the purpose of the ALL operator?

Compares a value to all values in another query

Checks if all records meet a condition

Matches a pattern

8. Which operator is used to negate a condition in SQL?

'AND'

'NOT'

'LIKE'

7. What is the result of SELECT 20 / 4;?

5

24

80

6. Which SQL operator is used to compare two values for inequality?

'='

'!='

'<'

5. How would you write a query to find all records where a column value is less than 50 and greater than 10?

SELECT * FROM table WHERE column BETWEEN 10 AND 50;

SELECT * FROM table WHERE column > 10 AND column < 50;

SELECT * FROM table WHERE column < 10 AND column > 50;

4. What does the EXISTS operator do in a subquery?

Checks if a subquery returns any rows

Checks if a value is within a range

Compares two values for equality

3. Which operator is used to find the remainder of a division in SQL?

'DIV'

'%'

'MOD'

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

20

12

8

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

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

SELECT * FROM table WHERE column BETWEEN 10 AND 20;

FROM table WHERE column = 10 AND column = 20;