×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.