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

The average starting salary for graduates at a university is $25,000 with a standard deviation of $2000. A histogram of the data shows the shape to be very erratic so Chebyshev’s Theorem should be used. How many of the graduates would have a starting salary between 21,000 and 29,000?

You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（） A: SALARY form at runtime.  B: SALARY form at design time.  C: COMMISSION form at runtime.  D: COMMISSION form at design time.

You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（） A: SALARY form at runtime. B: SALARY form at design time. C: COMMISSION form at runtime. D: COMMISSION form at design time.&e

以下语句错误的是（） 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

The average starting salary for graduates at a university is $25,000 with a standard deviation of $2000. A histogram of the data shows the shape to be very erratic so Chebyshev’s Theorem should be used. How many of the graduates would have a starting salary between 21,000 and 29,000? A: at least 95% B: at least 68% C: at least 75% D: at least 89%

下面哪个语句关于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;