Home » Oracle » 1z0-061 » 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_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;
Correct Answer: D
Explanation/Reference:
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
Download Printable PDF. VALID exam to help you PASS.
|
|