1. selectcount(*) from table1 where1=2;
结果为( )
A. null B. 0 C. 1 D. 会报错
2. selectsum(grzhye) from table1 where1=2;
结果为( )
A. null B. 0 C. 1 D. 会报错
3. selectsum(grzhye) from table1;
结果为( )
A. null B. 0 C. 300 D. 会报错
4. selectcount(*) from (selectsum(grzhye) from table1 where1=2);
结果为( )
A. 0 B. 1 C. null D. 会报错
5. selectavg(grzhye) from table1;
结果为( )
A. 100 B. 0 C. null D. 150
6. 执行以下语句会( )
altertable TABLE1
addconstraint udx_table1_cardno unique (CARDNO);
A. 成功 B. 报错
7. select * from table1 where cardno isnull; 如果优化方式按规则,是否会用到idx_table1_cardno索引( )
A.会 B.不会
8.select * from table1 where cardno ='123'; 如何优化方式按规则,是否会用到idx_table1_cardno索引( )
A.会 B.不会
9. selectmin(grzhye) from table1;
结果是( )
A. null B. 100 C. 报错
10. select id||cardno from table1 where id = '2';
结果会是:( )
A. null B. 2 C. 报错
11. Select100 + nullfrom dual; 结果是( )
A. null B. 100 C. 报错
12. Select100 * nullfrom dual; 结果是( )
A. null B. 100 C. 0 D. 报错
13. Select100 / nullfrom dual; 结果是( )
A. null B. 100 C. 0 D. 报错
14. Selectnull/0from dual; 结果是( )
A. null B. 0 C. 报错
15. select rylb,sum(grzhye)/count(rylb) from table1 groupby rylb;
会查到( )条记录
A. 0条 B. 2条 C. 3条 D. 报错
16. select100/sum(grzhye) from table1 where id='2';
结果是:( )
A. null B. 0 C. 100 D. 报错
17. update table1 set cardno = nullwhere id='2';update table1 set cardno = ''where id='2';
以上两句,( )
A. 效果是相同的 B. 只有第一句成功 C. 只有第二句成功
18. select * from table1 where cardno='';
会查到几条记录 ( )
A. 0 B. 1 C. 报错