试题详情
- 单项选择题 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;
关注下方微信公众号，在线模考后查看
热门试题
- Which two are true a
- Which SELECT stateme
- Examine the structu
- Which substitution v
- You need to perform
- What is true about s
- What is true of usin
- TheEMPLOYEEtableshas
- The CUSTOMERS table
- TheORDERStablehasthe
- Which one is a syste
- Examinethestructureo
- EvaluatetheSQLstatem
- The EMPLOYEES table
- Which two statements
- Which three statemen
- Examine the descrip
- You need to modify t
- The EMPLOYEES table
- What does the FORCE