itgle.com

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()A.B.C.D.

题目
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()

A.

B.

C.

D.

相似考题

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

2.下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。A.select employeesno，ename Name，job from employees where ename=‘SMITH’B.select employeesno，ename ‘Name’，job from employees where ename=SMITHC.select employeesno，ename “Name”，job from employees where ename=‘SMITH’D.select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’

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

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没有指定是哪个表

参考答案和解析
参考答案：B, D
更多“Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?() ”相关问题

  • 第1题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables:EMPLOYEESEMPLOYEE_ID NUMBERDEPARTMENT_ID NUMBERMANAGER_ID NUMBERLAST_NAME VARCHAR2(25)DEPARTMENTSDEPARTMENT_ID NUMBERMANAGER_ID NUMBERDEPARTMENT_NAME VARCHAR2(35)LOCATION_ID NUMBERYou want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?（）

    A. SELECT last_name, department_name, location_id FROM employees , department ;

    B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;

    C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;

    D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;


    参考答案：D

  • 第2题：

    Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.EMPLOYEESNOT NULL,EMPLOYEE_ID NUMBERPrimary KeyVARCHAR2EMP_NAME(30)VARCHAR2JOB_ID(20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT_IDcolumn of theDEPARTMENTStableDEPARTMENTSNOT NULL, PrimaryDEPARTMENT_ID NUMBERKeyVARCHAR2DEPARTMENT_NAME(30)References NGR_IDMGR_ID NUMBERcolumn ofthe EMPLOYEES tableForeign key toLOCATION_ID NUMBERLOCATION_IDcolumn of theLOCATIONS tableLOCATIONSNOT NULL, PrimaryLOCATION_ID NUMBERKeyVARCHAR2CITY|30)Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）

    A. SELECT emp_name, department_name, city FROM employees e JOIN departments d USING (department_id) JOIN locations 1 USING (location_id) WHERE salary > 10000;

    B. SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 JOIN ON (e.department_id = d.department id) AND (d.location_id =1.location_id) AND salary > 10000;

    C. SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE salary > 10000;

    D. SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary > 10000;

    E. SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;


    参考答案：A, D

  • 第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题：

    Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000?（）

    A.

    B.

    C.

    D.

    E.


    参考答案：C

  • 第5题：

    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);


    参考答案：F

  • 第6题：

    如果存在一张表格表示员工信息 Employees（ID,Name,Gender,ReportsTo），其中 ReportsTo 为外码，用于表示该员工的直接上级领导，那么要查询出结果（ID,Name,LeaderName），SQL 是Select ID, Name, u.Name As LeaderName From Employees e JOIN Empoyees u ON e.ID = u.ReportsTo


    错误

相关内容