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: Which SELECT statement…

The correct answer is D. SELECT cust_name, cust_address. 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…

Basic SQL SELECT Statements

Question

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:

Which SELECT statement accomplishes this task?

Options

ASELECT*
BSELECT name, address
CSELECT id, name, address, phone
DSELECT cust_name, cust_address
ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;

How the community answered

(39 responses)

A
5% (2)
B
3% (1)
C
13% (5)
D
77% (30)
E
3% (1)

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.

Topics

#SELECT statement#column projection#table query#basic SELECT

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice