Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()A.to find the tax percentage for each of the employeesB.to list the name, job_id, and manager name for

题目
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?()

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.现有如下两个关系模式：Employees(Eid，Name，DeptNO)Departments(DeptNO，DeptName，TotalNumber)Employees关系模式描述了职工编号、姓名和所在部门编号；Departments关系模式描述了部门编号、名称和职工总人数。请按SQL Server所采用的’rransact—SQL语法格式编写实现具有如下功能的后触发型触发器：每当在Employees表中插入一行数据时，相应部门的职工总人数就加1。

2.（ 2 ）现有如下两个关系模式：Employees （ Eid ， Name ， DeptNO ）Departments （ DeptNO ， DeptName ， TotalNumber ）Employees 关系模式描述了职工编号、姓名和所在部门编号； Departments 关系模式描述了部门编号、名称和职工总人数。请 按 SQL Serve r 所采用 的 Tansact — SQ L 语法格式编写实现具有功能的后触发型触发器 ： 每当在Employee s表中插入一行数据时，相应部门的职工总人数就加 1 。（ 10 分）

3.”You ____ have a wrong number,” she said. “There’s no one of that name here.”A. needB. canC. mustD. would

4.在执行语句SELECT department_id FROM employees,departments WHERE employees.department_id= departments.department_id;时报错,原因是()。A.没有给表employees和表departments加别名B.没有给列department_id加别名C.不能用employees.department_id=departments.department_id作为条件D.SELECT后面的department_id没有指定是哪个表

更多“Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?() ”相关问题

  • 第1题：

    7． If I _______ you，l_______ take an umbrella with me．

    A． was ; should

    B． was ; would

    C． were ; will

    D． were ; would


    正确答案：D
    7．D【解析】虚拟条件句中be动词用were，主句用 “would/should/could/might+动词原形”。故答案为D。

  • 第2题：

    "You _________ finish your homework before the dinner." said mother.

    A.should

    B.have to

    C.must

    D.would


    参考答案：C

  • 第3题：

    “You ____ have a wrong number,” she said. “There’s no one of that name here.”

    A. need

    B. can

    C. must

    D. would


    正确答案：C
    解析：must have意思是肯定有什么，依题意可得，答案是C。

  • 第4题：

    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 都是表达"不妨,做好...的意思."

  • 第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关系模式描述了部门编号、名称和职工总


    正确答案：(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语句中指定的操作都已成功执行，并且所有的约束检查也成功完成后，才执行此触发器，即后触发型触发器。

  • 第6题：

    当用户单击 Button控件时,将触发的事件是button_click


    Button

相关内容