A.to find the tax percentage for each of the employees
B.to list the name, job_id, and manager name for all the employees
C.to find the name, salary, and the department name of employees who are not working with Smith
D.to find the number of employees working for the Administrative department and earning less than 4000
E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
第1题:
( 2 )现有如下两个关系模式:
Employees ( Eid , Name , DeptNO )
Departments ( DeptNO , DeptName , TotalNumber )
Employees 关系模式描述了职工编号、姓名和所在部门编号; Departments 关系模式描述了部门编号、名称和职工总人数。
请 按 SQL Serve r 所采用 的 Tansact — SQ L 语法格式编写实现具有功能的后触发型触发器 : 每当在Employee s表中插入一行数据时,相应部门的职工总人数就加 1 。( 10 分)
第2题:
7. If I _______ you,l_______ take an umbrella with me.
A. was ; should
B. was ; would
C. were ; will
D. were ; would
第3题:
现有如下两个关系模式:
Employees(Eid,Name,DeptNO)
Departments(DeptNO,DeptName,TotalNumber)
Employees关系模式描述了职工编号、姓名和所在部门编号;Departments关系模式描述了
部门编号、名称和职工总人数。
请按SQL Server所采用的’rransact—SQL语法格式编写实现具有如下功能的后触发型触
发器:每当在Employees表中插入一行数据时,相应部门的职工总人数就加1。
第4题:
“You ____ have a wrong number,” she said. “There’s no one of that name here.”
A. need
B. can
C. must
D. would
第5题:
A.should
B.have to
C.must
D.would
第6题:
”You ____ have a wrong number,” she said. “There’s no one of that name here.”
A. need
B. can
C. must
D. would
第7题:
If you don’t like to swim, you _____as well stay at home.
A)should B)may C)can D)would
选B,因为might/may as well 或者 just as well 都是表达"不妨,做好...的意思."
第8题:
A.没有给表employees和表departments加别名
B.没有给列department_id加别名
C.不能用employees.department_id=departments.department_id作为条件
D.SELECT后面的department_id没有指定是哪个表
第9题:
已知关系模式R的全部属性集U={A,B,C,D,E,G}及函数依赖集:
F=(AB→C,C→A,BC→D,ACD→B,D→EG,BE→C,CG→BD,CE→AG}求属性集闭包(BD)+
(2) 现有如下两个关系模式:
Employees(Eid,Name,DeptNO)
Departments(DeptNO,DeptName,TotalNumber)
Employees关系模式描述了职工编号、姓名和所在部门编号;Departments关系模式描述了部门编号、名称和职工总
第10题:
当用户单击 Button控件时,将触发的事件是button_click