多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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;
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题