创建一个名为salary的数据库，主数据文件的逻辑名salary_data,物理名salary.mdf,初始大小为5M，增长方式为15%；日志文件逻辑名salary_log，物理名salary.ldf，初始大小为2M，增长速度2M，最大值30M。所有文件存放在D盘的salary文件夹中

选择下列函数运行后的输出NestList[Log,10,3] A: {Log[10],Log[Log[10]],Log[Log[Log[10]]]} B: {10,Log[10],Log[Log[10]],10+Log[Log[Log[10]]]} C: {Log[10],Log[Log[10]],Log[Log[Log[Log[10]]]]} D: {10,Log[10],Log[Log[10]],Log[Log[Log[10]]]}

以下语句错误的是（） A: SELECTrank，AVG（salary）FROMpeopleGROUPBYrankHAVINGAVG（salary）>1000 B: SELECTrank，AVG（salary）FROMpeopleHAVINGAVG（salary）>1000GROUPBYrank； C: SELECTAVG（salary）FROMpeopleGROUPBYrankHAVINGAVG（salary）>1000； D: SELECTrank，AVG（salary）FROMpeopleGROUPBYrankWHEREAVG（salary）>1000；

Finally I got my ____. A: salary raised B: risen salary C: salary rise D: salary to rise

下面哪个语句关于GROUP BY 和HAVING语句的使用是正确的？（) A: A.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_IDHAVING AVG(SALARY) > 3000; B: B.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_ID ,DEPARTMENT_IDHAVING AVG(SALARY) > 3000; C: C.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY AVG(SALARY)HAVING AVG(SALARY) > 3000; D: D.SELECT JOB_ID , DEPARTMENT_ID , AVG(SALARY)FROM EMPLOYEES GROUP BY JOB_ID , DEPARTMENT_IDHAVING SALARY > 3000;

以下语句错误的是() A: LECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; B: SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 C: SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; D: SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; E: SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000;

如果除了月工资，年终还发放全年工资的40%作为年终奖，计算每个公司的年收入( ) A: SELECT name, salary*(12+ salary*12*0.4) FROM job; B: SELECT name, salary*12+ 0.4 FROM job; C: SELECT name, salary*12+ salary*0.4 FROM job; D: SELECT name, salary*12+ salary*12*0.4 FROM job;

查询各类别的公司中比该类别最小工资高300元的公司、工资、类别 A: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) ; B: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type ) + 300; C: SELECT name, salary, type FROM job WHERE salary > 300; D: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) + 300;

salary

CentOS操作系统的日志文件默认保存在哪个路径（） A: /etc/log B: /var/log C: /usr/log D: /log