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 greater than or equal to 100?

SELECT * FROM table WHERE column = 100;

SELECT * FROM table WHERE column > 100;

SELECT * FROM table WHERE column >= 100;

9. What does the UNION operator do?

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

Returns the result set of two or more SELECT statements

Compares two values for inequality

Which operator is used to select records that match at least one of multiple conditions?

'AND'

'OR'

'LIKE'

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

6

8

4

6. Which operator is used to match a value against a pattern using wildcards?

'='

'IN'

'LIKE'

5. What is the result of SELECT 8 / 2;?

4

10

6

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

SELECT * FROM table WHERE column != 10;

SELECT * FROM table WHERE column = 10;

SELECT * FROM table WHERE column > 10;

3. What does the ANY operator do?

Compares a value to any value in another query

Checks if any record meets a condition

Matches any pattern

2. Which operator would you use to combine multiple conditions where either condition can be true?

'AND'

'OR'

'BETWEEN'

1. What is the result of SELECT 15 % 4;?

4

3

5