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
Options
- Axxx-xxx-xxxx
- B(xxx) xxxxxxx
- C(xxx) xxx-xxxx
- Dxxx-(xxx)-xxxx
How the community answered
(23 responses)- A4% (1)
- B9% (2)
- C83% (19)
- D4% (1)
Community Discussion
No community discussion yet for this question.
