Oracle - Conditions MCQ

Oracle – Conditions

1 / 19

1. What is the purpose of the Oracle AND operator in a SQL condition?

Combines multiple conditions, and at least one must be true

Counts the number of rows

Negates a condition

Combines multiple conditions, and all must be true

2 / 19

2. Which SQL operator is used to combine multiple conditions with an OR relationship in Oracle SQL?

AND

NOT

XOR

3 / 19

3. In Oracle SQL, what does the AND operator do when used to combine conditions?

Negates the condition

At least one condition must be true for the overall condition to be true

All conditions must be true for the overall condition to be true

Counts the number of rows

4 / 19

4. What is the primary purpose of the Oracle OR operator in a SQL condition?

Combines multiple conditions, and all must be true

Counts the number of rows

Negates a condition

Combines multiple conditions, and at least one must be true

5 / 19

5. Which SQL operator in Oracle SQL is used for pattern matching in conditions?

NOT

BETWEEN

6 / 19

6. In Oracle SQL, what is the primary function of the IN operator in a condition?

Counts the number of rows

Joins tables

Orders rows

Checks if a value is in a list of specified values

7 / 19

7. What does the NOT operator do when used in a condition in Oracle SQL?

Negates the condition

Joins tables

Orders rows

Performs mathematical calculations

8 / 19

8. In Oracle SQL, what is the purpose of the IS NULL condition in a query?

Joins tables

Orders rows

Counts the number of rows

Checks if a value is null

9 / 19

9. Which SQL operator is used to check if a value is not null in a condition in Oracle SQL?

IS NULL

IS NOT NULL

10 / 19

10. In Oracle SQL, what does the BETWEEN operator allow you to do in a condition?

Check if a value is within a specified range

Count the number of rows

Calculate the sum of values

Join multiple tables

11 / 19

11. What is the primary purpose of the EXISTS operator in Oracle SQL conditions?

Checks if a subquery returns any rows

Performs mathematical calculations

Negates a condition

Counts the number of rows

12 / 19

12. Which SQL operator in Oracle SQL is used for regular expression pattern matching in conditions?

BETWEEN

NOT

REGEXP_LIKE

13 / 19

13. In Oracle SQL, what does the LIKE operator allow you to do in a condition?

Filter rows based on numeric values

Perform pattern matching on text values

Group rows

Count the number of rows

14 / 19

14. What is the outcome of using the OR operator to combine conditions in Oracle SQL?

Counts the number of rows

At least one condition must be true for the overall condition to be true

Negates the condition

All conditions must be true for the overall condition to be true

15 / 19

15. In Oracle SQL, what is the primary role of the AND operator when used to combine conditions?

Negates the condition

At least one condition must be true for the overall condition to be true

All conditions must be true for the overall condition to be true

Counts the number of rows

16 / 19

16. What is the primary purpose of the OR operator in Oracle SQL conditions?

Counts the number of rows

Combines multiple conditions, and at least one must be true

Negates a condition

Combines multiple conditions, and all must be true

17 / 19

17. Which SQL operator is used for pattern matching in Oracle SQL conditions?

BETWEEN

NOT

18 / 19

18. In Oracle SQL, what does the IN operator do in a condition?

Checks if a value is in a list of specified values

Counts the number of rows

Orders rows

Joins tables

19 / 19

19. In Oracle SQL, what is the purpose of the IS NULL condition?

Checks if a value is null

Orders rows

Joins tables

Counts the number of rows

Your score is

Oracle – Conditions MCQ