以下哪两组联接关键字可以创建这样一个联接，该联接包括SELECT语句中指定的第一个表中的不匹配行？（）A、LEFT OUTER JOIN和FULL OUTER JOINB、RIGHTOUTERJOIN和LEFT OUTER JOINC、USING和HAVINGD、OUTER JOIN和USING

题目

以下哪两组联接关键字可以创建这样一个联接，该联接包括SELECT语句中指定的第一个表中的不匹配行？（）

  • A、LEFT OUTER JOIN和FULL OUTER JOIN
  • B、RIGHTOUTERJOIN和LEFT OUTER JOIN
  • C、USING和HAVING
  • D、OUTER JOIN和USING
相似考题

1.SQL语句中，SELECT命令中的JOIN是用来建立表间的联系短语，联接条件应出现在下列哪个短语中（ ）。A) WHEREB)ONC)HAVINGD)INNER

2.用SQL语句进行表的查询操作，使用 ()语句。如果要进行分组查询，应使用 ()子句;如果要对查询结果进行排序，要使用 () 子句;查询使用连接操作时，可以使用的外连接方式主要有左连接() ，右连接() ，全连接 () 等几种。A UPDATE ， ORDER BY， GROUP BY， LEFT JOIN， RIGHT JOIN， FULL JOINB SELECT ， GROUP BY， ORDER BY， LEFT JOIN，RIGHT JOIN， FULL JOINC SELECT ， ORDER BY ， GROUP BY ， LEFT JOIN， RIGHT JOIN，FULL JOIND SELECT ，GROUP BY ， ORDER BY ， RIGHT JOIN， LEFT JOIN， FULL JOIN

3.根据SQL标准，查询表student(sno,sname,sex,dept)中所有学生的选修课程数，其中选修记录在表SC(sno,cno,grade)中，两表中sno为关联字段。下面哪条语句合适?()A select sno,count(cno) from SCB select sno,count(cno) from studentC select a.sno,count(cno) from student a left outer join SCD select a.sno,count(cno) from SC left outer join student a

4.以下哪项用于左连接( )A.JOINB.RIGHT JOINC.LEFT JOIND.INNER JOIN

更多“以下哪两组联接关键字可以创建这样一个联接，该联接包括SELECT语句中指定的第一个表中的不匹配行？（）A、LEFT OUTER JOIN和FULL OUTER JOINB、RIGHTOUTERJOIN和LEFT OUTER JOINC、USING和HAVINGD、OUTER JOIN和USING”相关问题

  • 第1题：

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


    参考答案：B

  • 第2题：

    在对SELECT-SQL命令中的设置为左联接的是______。

    A．INNER JOIN

    B．LEFT JOIN

    C．RIGHT JOIN

    D．FULL JOIN


    正确答案：B

  • 第3题：

    Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O‘Neal 6008Carter 50DEPARTMENT ID DEPTNAME05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4Which of the following queries will produce the same result set as the query above?（）

    A.SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4

    B.SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4

    C.SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4

    D.SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4


    参考答案：B

  • 第4题：

    使用下列（）命令可以使结果表中除了匹配行外，还包括右表有的但左表中不匹配的行。

    • A、LEFT OUTER JOIN
    • B、RIGHT OUTER JOIN
    • C、NATURAL JOIN
    • D、INNER JOIN

    正确答案:B

  • 第5题：

    使用下列哪个命令可以使结果表中除了匹配行外，还包括右表有的但左表中不匹配的行？（）

    • A、LEFT OUTER JOIN
    • B、RIGHT OUTER JOIN
    • C、NATURAL JOIN
    • D、INNER JOIN

    正确答案:B

  • 第6题：

    在SQL-SELECT语句中，设置内部联接的命令是（）。

    • A、INNER JOIN
    • B、LEFT JOIN
    • C、RIGHT JOIN
    • D、FULL JOIN

    正确答案:A

  • 第7题：

    Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）

    • A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
    • B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
    • C、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
    • D、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

    正确答案:D

  • 第8题：

    What is true regarding subqueries?（）

    • A、The inner query always sorts the results of the outer query
    • B、The outer query always sorts the results of the inner query
    • C、The outer query must return a value to the outer query
    • D、The inner query returns a value to the outer query
    • E、The inner query must always return a value or the outer query will give an error

    正确答案:E

  • 第9题：

    单选题
    The cylinder is fitted with internal liner so that a water space is left （） the liner and the outer wall.
    A

    around

    B

    among

    C

    in

    D

    between


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    使用下列（）命令可以使结果表中除了匹配行外，还包括右表有的但左表中不匹配的行。
    A

    LEFT OUTER JOIN

    B

    RIGHT OUTER JOIN

    C

    NATURAL JOIN

    D

    INNER JOIN


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）
    A

    SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx

    B

    SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

    C

    SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx

    D

    SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx


    正确答案： C
    解析： 暂无解析

  • 第12题：

    ( 难度：中等)多表关联时，以左表为主体进行关联所使用的关键字是？
    A.RIGHT JOIN
    B.INNER JOIN
    C.AND
    D.LEFT_JOIN

    答案:D

  • 第13题：

    Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their managers‘ 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 departments 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.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

    C.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments 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) RIGHT OUTER JOIN departments 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 departments d ON (e.department_id = d.department_id) ;


    参考答案：B

  • 第14题：

    SQLServer中左联接查询用left join，Oracle中用什么？


    正确答案：

     

    左连接:select(nvl(a.c,0)-nvl(b.c,0)) from a,b where a.id(+)=b.id
    右连接:select(nvl(a.c,0)-nvl(b.c,0)) from a,b where a.id=b.id(+)
    自连接:select(nvl(a.c,0)-nvl(b.c,0)) from a,b where a.id(+)=b.id(+)
    说明:加号写在左就是左连接,写在右就是右连接,看加号的方法来定

  • 第15题：

    Which statements concerning the correlation between the inner and outer instances of non-static inner classes are true？（）  

    • A、Member variables of the outer instance are always accessible to inner instances， regardless of their      accessibility modifiers.
    • B、Member variables of the outer instance can never be referred to using only the variable name within     the inner instance.
    • C、More than one inner instance can be associated with the same outer instance.
    • D、All variables from the outer instance that should be accessible in the inner instance must be declared     final.
    • E、A class that is declared final cannot have any inner classes.

    正确答案:A,C

  • 第16题：

    关于HQL的连接查询，说法错误的是（）。

    • A、inner join 或 join用于内连接
    • B、inner join fetch或 join fetch用于迫切内连接
    • C、left outer join fetch 或 left join fetch用于迫切左外连接
    • D、right outer join fetch 或 right join fetch用于迫切右外连接

    正确答案:D

  • 第17题：

    下列连接中能自动删除重复的列是（）。

    • A、INNER JOIN
    • B、LEFT OUTER JOIN
    • C、RIGHT OUTER JOIN
    • D、FULL OUTER JOIN

    正确答案:A

  • 第18题：

    设A、B两个表的记录数分别为5和6，对两个表做A left outer join B连接，查询结果中可获得（）条记录。

    • A、5
    • B、6
    • C、30
    • D、11

    正确答案:A

  • 第19题：

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

    正确答案:F

  • 第20题：

    单选题
    使用下列哪个命令可以使结果表中除了匹配行外，还包括右表有的但左表中不匹配的行？（）
    A

    LEFT OUTER JOIN

    B

    RIGHT OUTER JOIN

    C

    NATURAL JOIN

    D

    INNER JOIN


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    关于HQL的连接查询，说法错误的是（）。
    A

    inner join 或 join用于内连接

    B

    inner join fetch或 join fetch用于迫切内连接

    C

    left outer join fetch 或 left join fetch用于迫切左外连接

    D

    right outer join fetch 或 right join fetch用于迫切右外连接


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    下列连接中能自动删除重复的列是（）。
    A

    INNER JOIN

    B

    LEFT OUTER JOIN

    C

    RIGHT OUTER JOIN

    D

    FULL OUTER JOIN


    正确答案： C
    解析： 暂无解析

  • 第23题：

    ( 难度：中等)在Hive中，以下哪个SQL语句是错误的
    A.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE
    ＞ FROM CUSTOMERS c
    ＞ LEFT OUTER JOIN ORDERS o
    ＞ ON (ID = o.CUSTOMER_ID);
    B.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE
    ＞ FROM CUSTOMERS c
    ＞ RIGHT OUTER JOIN ORDERS o
    ＞ ON (ID = o.CUSTOMER_ID);
    C.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE
    ＞ FROM CUSTOMERS c
    ＞ FULL OUTER JOIN ORDERS o
    ＞ ON (ID = o.CUSTOMER_ID);
    D.hive＞ SELECT ID, NAME, o.AMOUNT, o.DATE
    ＞ FROM CUSTOMERS c
    ＞ FULL OUTER JOIN ORDERS o
    ＞ ON (ID = o.CUSTOMER_ID OR Name = o.Name);

    答案:D

相关内容