Examine the structure 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 f

题目
Examine the structure 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 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 then 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.You’ll be punished by law if you ________ your child.(A) use(B) abuse(C) used(D) abused

2.在执行语句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没有指定是哪个表

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

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

更多“Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?() ”相关问题

  • 第1题：

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

    A. need

    B. can

    C. must

    D. would


    正确答案：C

  • 第2题：

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

  • 第3题：

    已知关系模式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语句中指定的操作都已成功执行，并且所有的约束检查也成功完成后，才执行此触发器，即后触发型触发器。

  • 第4题：

    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。

  • 第5题：

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

    A.should

    B.have to

    C.must

    D.would


    参考答案：C

  • 第6题：

    “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。

相关内容