nerdexam
IBM

C2090-558 · Question #32

Given the query shown below: What will happen?

The correct answer is A. All rows will be retrieved in which item_desc contains the characters 'pencil'. See the full explanation below for the reasoning.

Question

Given the query shown below:

What will happen?

Options

  • AAll rows will be retrieved in which item_desc contains the characters 'pencil'.
  • BAll rows will be retrieved in which item_desc does not contain the characters 'pencil'.
  • CAll rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.
  • DAll rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any

How the community answered

(18 responses)
  • A
    83% (15)
  • B
    11% (2)
  • D
    6% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice