可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You need to produce a report for mail


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 customer
参考答案
参考解析:
分类:1Z0-007题库