达内C培训第二次月考附答案
考试场次:2013_09月考_9月2日_C++试卷名称:2013年09月 _C++_CSD/ESD1306(new) Xi妹汁每人地A稣业■书曰一辣门左西质cm江和旦, 1. 统计每个部口的人数并要求显不部口名称的SQL语句是? / . \ A. Select dept_id, count(dept_id), d. name from s_emp, s_dept d where dept_id=d. id group by dept_id B. Select dept_id, count (dept_id), sum(d. name) from s_emp, s_dept d where dept_id=d. id group by dept_id C. Select dept_id, count(dept_id), max(d. name) from s_emp, s_dept d where dept_id=d. id group by dept_id D. Select dept_id, count (dept_id), count (d. name) from s_emp, s_dept d where dept_id=d. id group by dept_id 正确答案:C 2. 打开共享库文件函数的是? r A. dlerror r B. dlsym v C. dlopen r D. dlclose 正确答案:C * 3.下面分组语句正确的是? A. Select name, dept_id from s_dept d, s_emp e where dept_id=idgroup by dept_id; B. Select e. name, dept_id from s_dept d, s_emp e where dept_id=d. id group by dept_id; C. Select e. name, dept_id from s_dept d, s_emp e where dept_id=d. id group by dept_id; D. Select max(name), dept_id from s_dept d, s_emp e where dept_id=d. id group by dept_id; 正确答案:D 4. 在建表时,经常需要用到约束,请问下面哪个不是常见约束? 厂A.主键 厂B.非空 17 C,回滚 1- D.外键 正确答案:C 5. 阅读如下代码: int fd = open(“a. txt”, 0_WR0NLY10_CREAT10_TRUNC, 0666): int flags = fcntl(fd, F_GETFL); printf(“flags=%d\n”, flags); switch ((空白处)){ case 0_RD0NLY: printf(“RDONLY n“);break; case O_WRONLY: printf(“WRONLY n“);break; case O_RDWR: printf(“RDWR\n“);break; } 空白处的条件应该是? 「 A. flags & 5 「 B. flags 17 C. flags & 3 厂 D. flags & 4 正确答案:C 6. 关于排序,下列说法错误的是? 「A,排序的关键字是order by 厂B.升序是默认排序顺序 1- C.降序的关键字是desc 17 D.不能使用多字段排序 正确答案:D ,, 7.下列建表的SQL语句错误的是? 厂 A. Create table test 123 ( Id number, Dname varchar2(30) ) 厂 B. Create table test 123 ( Id number, Dname varchar2(30), MyDate date ) 厂 C. Create table testl23( Id number, Dname char(30) ) » D. Create table test 123( Id number, name varchar2(30), ) 正确答案:B 8. 如果想在代码中禁止使用goto,可以采用的是? 「 A. #pragma GCC dependency goto [7 B, #pragma GCC poison goto 「 C. #pragma pack(2) 厂 D. #pragma GCC goto 正确答案:B 9. 显示所有的工资级别和级别对应的salary和first_name的SQL语句是? [7 A. Select grade, first_name, salary from s_emp, salgrade where salary(+) between losal and hisal B. Select grade, first_name, salary from s_emp, salgrade where salary between losal and hisal (+) C. Select grade, first_name, salary from s_emp, salgrade where salary between(+) losal and hisal D. Select grade, first_name, salary from s_emp, salgrade where salary(+) between losal and hisal (+) 正确答案:A 10. 下列内存区域中,一般不用来存放变量的是: 厂A. 栈区 匠B. 代码区 厂C. BSS段 厂D. 堆区 正确答案:B 关于动态库和静态库,下列说法错误的是? F A,打包静态库用的是ar命令。 匠B.打包共享库用的是gcc -share r C,静态库和共享库都必须配置环境变量才能使用 D. . a文件是静态库,而.so文件是共享库 正确答案:C 12.把工资大于1000的first_name, salary显示出来,按工资排序,工资相同 按 first_name 降序的SQL语句是? 「A. select first _name, salary from s_emp order by salary, first_name 「B. select first _name, salary from s_emp order by salary, first_name asc 「c. select first _name, salary from s_emp order by salary desc, first_name D. select first_name, salary from s_emp orde