Home »
MCQs »
Oracle MCQs
Oracle NOT and OR Conditions MCQs
Oracle NOT and OR Conditions MCQs: This section contains multiple-choice questions and answers on NOT and OR Conditions in Oracle.
Submitted by Anushree Goswami, on June 27, 2022
1. NOT conditions are used with Oracle ____ statements.
- SELECT
- UPDATE
- INSERT
- All of the above
Answer: D) All of the above
Explanation:
NOT conditions are used with Oracle SELECT, INSERT, UPDATE and DELETE statements.
Discuss this Question
2. To negate a given condition, use the ____ condition.
- OR
- NOR
- XOR
- NOT
Answer: D) NOT
Explanation:
To negate a given condition, use the NOT condition.
Discuss this Question
3. What is the syntax of Oracle NOT?
- Condition NOT
- NOT Condition
- NO Condition
- Condition NO
Answer: B) NOT Condition
Explanation:
"NOT Condition" is the syntax of Oracle NOT.
Discuss this Question
4. Which of the following is a parameter in NOT?
- Expression
- Pattern
- Condition
- None
Answer: C) Condition
Explanation:
Condition is the parameter in NOT.
Discuss this Question
5. When more than ____ condition is true, the OR operator checks them all and returns the result if any one of them is true.
- One
- Two
- Three
- Four
Answer: A) One
Explanation:
When more than one condition is true, the OR operator checks them all and returns the result if any one of them is true.
Discuss this Question
6. Which of the following comes in the syntax of Oracle OR?
- Where
- Condition
- OR
- All of the above
Answer: D) All of the above
Explanation:
The following comes in the syntax of Oracle OR - Where, Condition and OR.
Discuss this Question
7. What is the parameter in the syntax of Oracle OR?
- Condition 1
- Condition 2
- Condition n
- All of the above
Answer: D) All of the above
Explanation:
The parameter in the syntax of Oracle OR is condition1, condition 2, ..., condition n.
Discuss this Question
8. If any one of condition 1, condition 2, or condition_n is true, the record is ____.
- Returned
- Not returned
- Partially returned
- None
Answer: A) Returned
Explanation:
If any one of condition 1, condition 2, or condition_n is true, the record is returned.
Discuss this Question