ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）A. SELECT last_name, manager_id, department_name
题目
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）
A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
相似考题
更多“ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all e ”相关问题
-
第1题：
UserSCOTTwantstoexporthisobjectsusingOracleDataPumpandexecutesthefollowingcommand：$expdpscott/tigerdirectory=EXPORT_DIRdumpfile=scott.dmpinclude=tableinclude=view："like’%DEPARTMENTS%’"content=DATA_ONLYWhichtaskwouldthecommandaccomplish？（）
A.A
B.B
C.C
D.D
E.E
参考答案：C
-
第2题：
已知关系模式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关系模式描述了部门编号、名称和职工总
正确答案：(BD)+=ABCDEG X(O)=BD；由D→EG可知X(1) =BDEG；再由BE→C可知X(2)→BDEGC；又有CG→BDCE→AG可知X(3)=BDEGCA因为X(3)中包含了所有的属性集即有(BD)+=X(3)=ABCDEG T—C(TNO．CNO)主码(TNOCNO)外码TNOCNO S—C(SNOCNO成绩)主码(SNOCNO)．外码SNOCNO (2) create trigger sql_tri on employees for
(BD)+=ABCDEG X(O)=BD；由D→EG可知X(1) =BDEG；再由BE→C，可知X(2)→BDEGC；又有CG→BD，CE→AG，可知X(3)=BDEGCA，因为X(3)中包含了所有的属性集，即有(BD)+=X(3)=ABCDEG T—C(TNO．CNO)主码(TNO，CNO)，外码TNO，CNO S—C(SNO，CNO，成绩)主码(SNO，CNO)．外码SNO，CNO (2) create trigger sql_tri on employees for 解析：本题考查了后触发器的Transact—SQL语句。其语法格式为：
CREATE TRIGGER触发器名称
0N |表名|视图名|
[WITH ENCRYPTION]
AS
SQL语句
AFTER和FOR，指定触发器只有在引发的SQL语句中指定的操作都已成功执行，并且所有的约束检查也成功完成后，才执行此触发器，即后触发型触发器。 -
第3题：
原始细胞CD41阳性的急性白血病属FAB分类的A.ALL-L
B.ALL-M6
C.ALL-M3
D.ALL-M7
E.ALL-M4答案：D解析：CD41为巨核细胞系分化发育过程学特异性标记，而根据中国急性白血病分型标准，巨核细胞白血病归于M7亚型。 -
第4题：
Whichbuilt－incopiesvaluesfromalistitemintoarecordgroup?()A.RETRIEVE_LIST
B.RETRIEVE_GROUP
C.RETRIEVE_LIST_ITEM
D.RETRIEVE_GROUP_FROM_LIST
E.RETRIEVE_GROUP_FROM_LIST_ITEM
参考答案：A
-
第5题：
YouhavetwocomputersnamedComputer1andComputer2thatrunWindows7.Computer1hastwolocaluseraccountsnamedUser1andUser2.OnComputer1,yourunScanstate.exe/all\\server1\data \computer1.OnComputer2,yourunLoadstate.exe/lac:Pa$$w0rd\\server1\data\computer1.YouneedtoensurethatUser1andUser2canlogontoComputer2.WhatshouldyoudoonComputer2?（）
A.Enablealluseraccounts.
B.Modifythedefaultpasswordpolicy.
C.ModifytheAllowlogonlocallyuserright.
D.AddUser1andUser2tothelocalAdministratorsgroup.
参考答案：A
-
第6题：
原始细胞CD41阳性的急性白血病属FAB分类的A.ALL-12
B.ALL-M6
C.ALL-M3
D.ALL-M7
E.ALL-M4答案：D解析：CD41为巨核细胞系分化发育过程学特异性标记，而根据中国急性白血病分型标准，巨核细胞白血病归于M7亚型。