nerdexam
Oracle

1Z0-047 · Question #166

View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement: SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]') = 1; Which…

The correct answer is D. It would display all the street addresses where the first character is not a letter of the alphabet. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the data in the LOCATIONS table. Evaluate the following SOL statement:

SELECT street_address FROM locations WHERE REGEXP_INSTR(street_address,'[^[: alpha:]]') = 1; Which statement is true regarding the output of this SOL statement?

Exhibit

1Z0-047 question #166 exhibit

Options

  • AIt would display all the street addresses that do not have a substring 'alpha'.
  • BIt would display all the street addresses where the first character is a special character.
  • CIt would display all the street addresses where the first character is a letter of the alphabet.
  • DIt would display all the street addresses where the first character is not a letter of the alphabet.

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    10% (2)
  • C
    5% (1)
  • D
    81% (17)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice