86.Examine the structure and data of the CUST_TRANS table:
来源：互联网 发布：如何开展网络推广 编辑：程序博客网 时间：2024/05/22 10:40
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;
答案:ACD
解析：
A.正确，varchar可以隐式转成数字
B.错误，参考85
C.正确，和A一样
D.正确，参考85
E.错误，两个字符不能使用+运算符
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;
答案:ACD
解析：
A.正确，varchar可以隐式转成数字
B.错误，参考85
C.正确，和A一样
D.正确，参考85
E.错误，两个字符不能使用+运算符
0 0
- 86.Examine the structure and data of the CUST_TRANS table:
- 90.Examine the structure and data in the PRICE_LIST table:
- 85.View the Exhibit and examine the structure and data in the INVOICE table.
- 107.View the Exhibit and examine the structure and data in the INVOICE table.
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 13.View the Exhibit and examine the structure of the PRODUCTS table.
- 44.View the Exhibit and examine the structure of the ORD table.
- 52.View the Exhibit and examine the structure of the PRODUCTS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- 62.View the E xhibit and examine the structure of the CUSTOMERS table.
- 63.View the Exhibit and examine the structure of the PRODUCTS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 84.View the Exhibit and examine the structure of the EMPLOYEES table.
- 99.View the Exhibit and examine the structure of the PROMOTIONS table.
- 100.View the Exhibit and examine the structure of the PROMOTIONS table.
- HTML5 postMessage解决跨域、跨iframe窗口消息传递
- 关联其它表进行update数据
- ROM
- Dynamics CRM2013 从subgrid中打开快速创建窗体创建数据
- 键值对与键=值
- 86.Examine the structure and data of the CUST_TRANS table:
- 用链表实现栈
- Activity生命周期
- java修饰符作用域
- web Update node.js & npm on Mac
- Android 开发绕不过的坑：你的 Bitmap 究竟占多大内存？
- SetConsoleCtrlHandler
- Android数据存储之SharedPreferences 共享首选项/偏好设置
- Security Appscan Standard 漏洞扫描及补漏洞
