Which option would be the correct format in the output?

Prev Question
Next Question

View the Exhibit and examine the details of the EMPLOYEES table.

Exam 1Z0-047 - Which option would be the correct format in the output?

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?

A.
xxx-xxx-xxxx

B.
(xxx) xxxxxxx

C.
(xxx) xxx-xxxx

D.
xxx-(xxx)-xxxx

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *