数据库2(国外英文资料).docVIP

数据库2(国外英文资料) There is a teachers list (teachers number, teachers name, job title, basic salary), where the basic salary is related to the teachers job title. The feasible solution to this constraint is (). A is defining A view on the teachers table B defines a stored procedure on the teachers table The C has a trigger that defines insert and modification actions on the teachers table D defines a scalar function on the teachers table The following is a false statement about query optimization A query that is sent to the database frequently is replaced by A stored procedure that improves query efficiency B is the ability to index the properties that appear frequently in query conditions, which can improve query efficiency C first performs the table connection condition, then the query condition is executed to improve the query efficiency It is helpful to improve query efficiency by objectifying and maintaining views that are frequently accessed There is a teachers list (teachers number, name, department, salary) to find out that the average salary of the teachers in the department is higher than the average salary of all teachers. The correct statement is a. SELECT the department, the AVG (salary) FROM the teachers watch WHERE AVG (salary) B SELECT the department, the AVG (salary) FROM the teachers watch WHERE AVG (salary) GROUP BY wage C SELECT the department, the AVG (salary) FROM the teachers watch GROUP BY department HAVING AVG (salary) (the salary) FROM the teachers watch D SELECT the department, the AVG (salary) FROM the teachers watch GROUP BY department WHERE AVG (salary) In SQL SERVER, the process of taking parameters is the correct method (). A process name parameter Process name (parameter) C procedure name = parameter ABC can be D The following description is false There is only one master data file in each data file. B log files can exist in any file group. The C main data file is the PRIMARY file group by default. The D file group is for the better impl