1z1-071 Free Dumps Study Materials
Question 13: Examine the structure of the MEMBERS table:
NameNull?Type
------------------ --------------- ------------------------------
MEMBER_IDNOT NULLVARCHAR2 (6)
FIRST_NAMEVARCHAR2 (50)
LAST_NAMENOT NULLVARCHAR2 (50)
ADDRESSVARCHAR2 (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 executes successfully and displays the column details in three separate columns and replaces
only the last column heading with the alias.
C. It executes successfully and displays the column details in a single column with only the alias
column heading.
D. It fails because the space specified in single quotation marks after the first two column names is
invalid.
Correct Answer: B