1Z0-061 · Question #209
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…
The correct answer is D. SELECT cust_name, cust_address FROM customers. 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…
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:
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?
Options
- ASELECT * FROM customers
- BSELECT name, address FROM customers;
- CSELECT id, name, address, phone FROM customers;
- DSELECT cust_name, cust_address FROM customers;
- ESELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
How the community answered
(21 responses)- B14% (3)
- C5% (1)
- D76% (16)
- E5% (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
Community Discussion
No community discussion yet for this question.