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_ID. NUMBER(4). NOT NULL
CUST_NAME. VARCHAR2(100). NOT NULL
CUST_ADDRESS. VARCHAR2(150)
CUST_PHONE. VARCHAR2(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.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-24
Chapter 1: Overview of Oracle Databases