Oracle
1Z0-047 · Question #145
1Z0-047 Question #145: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.
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
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.