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*
B.
FROM customers;
C.
SELECT name, address
D.
FROM customers;
E.
SELECT id, name, address, phone
F.
FROM customers;
D seems to be the correct choice.
It’s incomplete here, check:
http://www.aiotestking.com/oracle/which-select-statement-accomplishes-this-task/