You need to produce a report for mailing labels for all customers.
The mailing label must have only the customer name and address.
The CUSTOMERS table has these columns:
CUST_IDNUMBER(4)NOT NULL
CUST_NAMEVARCHAR2(100)NOT NULL
CUST_ADDRESSVARCHAR2(150)
CUST_PHONEVARCHAR2(20)
Which SELECT statement accomplishes this task?
A.
SELECT * FROM customers
B.
SELECT name, address FROM customers;
C.
SELECT id, name, address, phone FROM customers;
D.
SELECT cust_name, cust_address FROM customers;
E.
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
Explanation:
This answer provides correct list of columns for the output.
Incorrect Answers
A:This answer does not provide correct list of columns for the output. It is not required to show all
columns of the table. Symbol “*” is used in the SELECT command to substitute a list of all columns
of the table.
B:This answer does not provide correct list of columns for the output. There are not NAME and
ADDRESS columns in the CUSTOMERS table.
C:This answer does not provide correct list of columns for the output. There are not ID, NAME,
ADDRESS or PHONE columns in the CUSTOMERS table.
E:This answer does not provide correct list of columns for the output. It is not required to show all
columns of the table.