What is the outcome?

Examine the structure of the MEMBERS table:
Name Null? Type
—————— ————— ——————————
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
You execute the SQL statement:
SQL > SELECT member_id, ‘ ‘ , first_name, ‘ ‘ , last_name “ID FIRSTNAME LASTNAME
” FROM members;
What is the outcome?

A.
It fails because the alias name specified after the column names is invalid.

B.
It fails because the space specified in single quotation marks after the first two column names is invalid.

C.
It executes successfully and displays the column details in a single column with only the alias column
heading.

D.
It executes successfully and displays the column details in three separate columns and replaces only the
last column heading with the alias.