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.
- Order by
- Group by
- Where
- 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.
- Pattern
- Points
- Circle
- Numbers
Answer: A) Pattern
Explanation:
Pattern matching is possible with Oracle LIKE conditions.
Discuss this Question
3. Syntax of LIKE condition -
- expression LIKE pattern
- LIKE expression pattern [ESCAPE 'escape_character' ]
- expression ESCAPE pattern [LIKE 'escape_character' ]
- 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?
- Expression
- Pattern
- Both A and B
- 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 -
- Rows
- Columns
- Dataset
- Fields
Answer: B) Columns
Explanation:
Expressions are the name of the columns.
Discuss this Question
6. Which of the following comes in a pattern?
- %
- -
- Both A and B
- 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 -
- String
- Single Character
- Double Character
- None
Answer: A) String
Explanation:
The % is used to match string.
Discuss this Question
8. The - is used to match ____.
- String
- Single Character
- Double Character
- 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?
- Expression
- LIKE
- ESCAPE
- 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