[单选题]

Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.

You 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 NATURAL JOIN departments;

B . SELECT last_name, department_name FROM employees JOIN departments ;

C . SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

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 FULL JOIN 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)

参考答案与解析：

相关试题

The（ ）may examine or re-examine the goods or takesamples from them straightaway in the absence of th

[单选题]The（ ）may examine or re-examine the goods or takesamples from them straight

  • 查看答案

    • Exhibit:UPDATE EzonexamConsolidatedSET D

    [单选题]E．xhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.When users run the query in the exhibit above the receive the foll

  • 查看答案

    • When a fire ____ at the National Exhibit

    [试题]Whenafire____attheNationalExhibitioninLondon,atleasttenpricelesspaintingswerecompletelydestroyed.(A)brokeoff(C)brokedown(B)brokeout(D)brokeup

  • 查看答案

    • The（ ）may examine or re-examine the goods or take samples from them straightaway in the absence of t

    [单选题]The（ ）may examine or re-examine the goods or take samples from them straigh

  • 查看答案

    • Button按钮控件

    [问答题] Button按钮控件

  • 查看答案

    • 若看到程序中有以下事件过程，则可以肯定的是，当程序运行时（　　）。<br />Private Sub Click_MouseDown（Button As Integer，Shift As

    [单选题]若看到程序中有以下事件过程，则可以肯定的是，当程序运行时（　　）。Private Sub Click_MouseDown（Button As Inte

  • 查看答案

    • Examine the structure of the EMPLOYEES t

    [单选题]Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhich UPDATE statement is valid?（）A . UPDATE employees SET first_name = 'John' SET last_name ='Smith'

  • 查看答案

    • A translation B interpretation C exhibit

    [单选题]A． translation B interpretation C exhibition D demonstration

  • 查看答案

    • Refer to the exhibit. Based on the outpu

    [单选题]Refer to the exhibit. Based on the output from the show command on RT1which statement is true? （）A . OSPFv3 uses global IPv6 addresses to establish neighbor adjacencies.B . RT1 has a subnet mask of 64 bits .C . RT1 has FastEthernet0/0 set as a DR

  • 查看答案

    • The economycontinued to [exhibit] signs of decline in September.

    [单选题]The economycontinued to [exhibit] signs of decline in September.A.playB.sen

  • 查看答案