OCP 1Z0 051 86

来源：互联网发布：免费的统计软件编辑：程序博客网时间：2024/06/06 19:00

86. Examine the structure and data of the CUST_TRANS table:
CUST_TRANS
Name Null Type
CUSTNO NOT NULL CHAR(2)
TRANSDATE DATE
TRANSAMT NUMBER(6,2)
CUSTNO TRANSDATE TRANSAMT
11 01-JAN-07 1000
22 01-FEB-07 2000
33 01-MAR-07 3000
Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table.
Which 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;

TEST >CREATE TABLE CUST_TRANS(  2  CUSTNO CHAR(2) NOT NULL,  3  TRANSDATE DATE,  4  TRANSAMT NUMBER(6,2)  5  );表已创建。TEST >TEST >alter session set nls_date_language = 'american';会话已更改。TEST >alter session set nls_date_format='dd-mon-rr';会话已更改。TEST >TEST >INSERT INTO CUST_TRANS(CUSTNO,TRANSDATE,TRANSAMT )  2  SELECT 11,'01-JAN-07',1000 FROM dual  3  UNION ALL  4  SELECT 22,'01-FEB-07',2000 FROM dual  5  UNION ALL  6  SELECT 33,'01-MAR-07',3000 FROM dual;已创建 3 行。

TEST >SELECT transdate + '10' FROM cust_trans;TRANSDATE+'1------------11-jan-0711-feb-0711-mar-07已选择3行。TEST >SELECT * FROM cust_trans WHERE transdate   =   '01-01-07';SELECT * FROM cust_trans WHERE transdate   =   '01-01-07'                                               *第 1 行出现错误:ORA-01843: 无效的月份TEST >SELECT transamt FROM cust_trans WHERE custno > '11';  TRANSAMT----------      2000      3000已选择2行。TEST >SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';CU TRANSDATE      TRANSAMT-- ------------ ----------11 01-jan-07          1000已选择 1 行。已用时间:  00: 00: 00.00TEST >SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000                *第 1 行出现错误:ORA-01722: 无效数字

oracle中字符串连接符是 ||

TEST >SELECT custno || 'A' FROM cust_trans WHERE transamt > 2000;CUS---33A已选择 1 行。

Answer: ACD

0 0