OCP-1Z0-051-2015-3题

QUESTION NO: 3
Here is the structure and data of the CUST_TRANS table:

Exhibit:

Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table.
Which three SQL statements would execute successfully? (Choose three.)
A. SELECT transdate + '10' FROM cust_trans;
B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
C. SELECT transamt FROM cust_trans WHERE custno > '11';
D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
Answer: A,C,D
Explanation:
表CUST_TRANS  列TRANSDATE是date类型

在英文版本的ORACLE中默认日期格式为'DD-MON-YY',例如'01-JAN-98'

A:对 日期类型可以和数字加减 E:错 日期类型不能和字母加减

B:错 赋值的日期格式不正确

C:对 日期类型可以查出来

D:对 日期格式为dd—month-yy 可以查 month为月份全称