nerdexam
Oracle

1Z0-047 · Question #145

View the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL statement: SELECT phone_number, REGEXP_REPLACE(phone_number,'([[: digit: ]]{3})\.([[: digit: ]]{3})\.([[…

The correct answer is C. (xxx) xxx-xxxx. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL statement:

SELECT phone_number, REGEXP_REPLACE(phone_number,'([[: digit: ]]{3}).([[:

digit: ]]{3}).([[: digit: ]]{4})', ,(\1)\2-\3') "PHONE NUMBER" FROM employees; The query was written to format the PHONE_NUMBER for the employees. Which option would be the correct format in the output?

Exhibit

1Z0-047 question #145 exhibit

Options

  • Axxx-xxx-xxxx
  • B(xxx) xxxxxxx
  • C(xxx) xxx-xxxx
  • Dxxx-(xxx)-xxxx

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    9% (2)
  • C
    83% (19)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice