Examine the data in the EMPLOYEES and DEPARTMENTS tables.EMPLOYEESLAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000Kochhar 5000DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Sales20 Marketing30 Accounts40 AdministrationYou want to retrieve all employees, whether or not they have matching departments in the departments table.Which query would you use?()
A. SELECT last_name, department_name FROM employees , departments(+);
B. SELECT last_name, department_name FROM employees JOIN departments(+);
C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);
第1题:
( 2 )现有如下两个关系模式:
Employees ( Eid , Name , DeptNO )
Departments ( DeptNO , DeptName , TotalNumber )
Employees 关系模式描述了职工编号、姓名和所在部门编号; Departments 关系模式描述了部门编号、名称和职工总人数。
请 按 SQL Serve r 所采用 的 Tansact — SQ L 语法格式编写实现具有功能的后触发型触发器 : 每当在Employee s表中插入一行数据时,相应部门的职工总人数就加 1 。( 10 分)
第2题:
第3题:
检查
A.expect
B.except
C.excuse
D.examine
第4题:
UserSCOTTwantstoexporthisobjectsusingOracleDataPumpandexecutesthefollowingcommand:$expdpscott/tigerdirectory=EXPORT_DIRdumpfile=scott.dmpinclude=tableinclude=view:"like’%DEPARTMENTS%’"content=DATA_ONLYWhichtaskwouldthecommandaccomplish?()
A.A
B.B
C.C
D.D
E.E
第5题:
已知关系模式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关系模式描述了部门编号、名称和职工总
第6题: