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

Your little girl is becoming very rude. You ________ scold her. A.mayB.canC.ought toD.need

--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

A:I haven't eaten all day.B: You __ be very hungry.A. shouldB. have toC. must

A: I haven't sat down all day.B: You _____be very tired.A. couldB. have toC. must

Our tradition ______ be different _____ yours.A、can;withB、must;withC、need;asD、may;from

—_______ 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