Home » MCQs » Oracle MCQs

Oracle LIKE Condition MCQs

Oracle LIKE Condition MCQs: This section contains multiple-choice questions and answers on LIKE Condition in Oracle.
Submitted by Anushree Goswami, on June 28, 2022

1. In the ____ clause of Oracle, the like condition is used when selecting, inserting, updating, and deleting.

1. Order by
2. Group by
3. Where
4. For

Answer: C) Where

Explanation:

In the where clause of Oracle, the like condition is used when selecting, inserting, updating, and deleting.

Discuss this Question

---

2. ____ matching is possible with Oracle LIKE conditions.

1. Pattern
2. Points
3. Circle
4. Numbers

Answer: A) Pattern

Explanation:

Pattern matching is possible with Oracle LIKE conditions.

Discuss this Question

---

3. Syntax of LIKE condition -

1. expression LIKE pattern 
2. LIKE expression pattern [ESCAPE 'escape_character' ]
3. expression ESCAPE pattern [LIKE 'escape_character' ]
4. expression LIKE pattern [ESCAPE 'escape_character' ]

Answer: D) expression LIKE pattern [ESCAPE 'escape_character' ]

Explanation:

Syntax of LIKE condition is:

expression LIKE pattern [ESCAPE 'escape_character']

Discuss this Question

---

4. What are the parameters in Oracle LIKE Condition?

1. Expression
2. Pattern
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The parameters in Oracle LIKE Condition are expressions and patterns.

Discuss this Question

---

5. Expressions are the name of the -

1. Rows
2. Columns
3. Dataset
4. Fields

Answer: B) Columns

Explanation:

Expressions are the name of the columns.

Discuss this Question

---

6. Which of the following comes in a pattern?

1. %
2. -
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The % and - come in a pattern.

Discuss this Question

---

7. The % is used to match -

1. String
2. Single Character
3. Double Character
4. None

Answer: A) String

Explanation:

The % is used to match string.

Discuss this Question

---

8. The - is used to match ____.

1. String
2. Single Character
3. Double Character
4. None

Answer: B) Single Character

Explanation:

The - is used to match single character.

Discuss this Question

---

9. Which of the following comes in the syntax of Oracle LIKE Condition?

1. Expression
2. LIKE
3. ESCAPE
4. All of the above

Answer: D) All of the above

Explanation:

Expression, LIKE and ESCAPE all comes in the syntax of Oracle LIKE Condition.

Discuss this Question

---

---