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 NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_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;
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 NULLCUST_NAME VARCHAR2(100) NOT NULLCUST_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;
相关考题:
—Must I be in hospital for a week, Doctor? —No, you_________. You can go back home tomorrow.A. mustn’t B. needn’t C. must
--Must we finish our homework now? --No, you ______. You _______ finish it after school. A.needn't , mayB.mustn't , mayC.can't , canD.needn't , must
May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t
9. _______you _______ stay at home today?A. Do ; have toB. Must; have toC. Have; toD. Do ; must
—_______ I return the book to the library this week?— No, you _______.You can keep it until the end of this month. A.Must; needn’tB.Can; can’tC.May; mustn’tD.Can; mustn’t
3.—__________ 1 go out for a while?—No,you __________ You must finish your homework first.A. Must,needn'tB. Can,mayC. May,mustn'tD. May,must