Home » MCQs » Oracle MCQs

Oracle Comparison Operators MCQs

Oracle Comparison Operators MCQs: This section contains multiple-choice questions and answers on comparison operators in Oracle.
Submitted by Anushree Goswami, on June 22, 2022

1. A comparison operator is used with a ____ clause in Oracle.

1. Having
2. Where
3. Group By
4. Order By

Answer: B) Where

Explanation:

A comparison operator is used with a where clause in Oracle.

Discuss this Question

---

2. Which of the following is the comparison operator?

1. =
2. < 
3. > 
4. All of the above

Answer: D) All of the above

Explanation:

Operator =, <, > are all the comparison operators.

Discuss this Question

---

3. Which of the following is not the comparison operator?

1. !=
2. =!
3. <>
4. None

Answer: B) =!

Explanation:

The operator =! Is not the comparison operator.

Discuss this Question

---

4. Symbol of greater than or equal to -

1. <=
2. =
3. >=
4. None

Answer: C) >=

Explanation:

Symbol of greater than or equal to is >=.

Discuss this Question

---

5. Symbol of less than or equal to -

1. <=
2. =
3. >=
4. None

Answer: A) <=

Explanation:

Symbol of less than or equal to is <=.

Discuss this Question

---

6. Symbol of not equal is -

1. <> 
2. !=
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

Symbol of not equal is <>  or !=.

Discuss this Question

---

---