OCP CBT Question 525

Please solve the following question.

Examine the following SQL statement: ```sql SELECT employee_id AS "ID Number", first_name || ' ' || last_name AS "Employee Full Name", salary FROM employees; ``` Which statement is true regarding the execution of this query?

EMPLOYEES Table Structure
DESCRIBE employees;
Name                           Null?    Type
------------------------------ -------- -------------
EMPLOYEE_ID                    NOT NULL NUMBER(6)
FIRST_NAME                              VARCHAR2(20)
LAST_NAME                      NOT NULL VARCHAR2(25)
EMAIL                          NOT NULL VARCHAR2(25)
PHONE_NUMBER                            VARCHAR2(20)
HIRE_DATE                      NOT NULL DATE
JOB_ID                         NOT NULL VARCHAR2(10)
SALARY                                  NUMBER(8,2)
COMMISSION_PCT                          NUMBER(2,2)
MANAGER_ID                              NUMBER(6)
DEPARTMENT_ID                           NUMBER(4)

The column "ID Number" will display the employee ID, and "Employee Full Name" will display the concatenated first and last names. Both aliases are valid.

The query will return an error because column aliases contain spaces and are not enclosed in single quotation marks.

The query will return all employees, displaying only the EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY columns.

The column alias "ID Number" is valid, but "Employee Full Name" will cause an error because of the space and lack of single quotes.