Which SELECT statement accomplishes this task?

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?

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;



Leave a Reply 1

Your email address will not be published. Required fields are marked *