多选题In which two cases would you use an outer join?（）AThe tables being joined have NOT NULL columns.BThe tables being joined have only matched data.CThe columns being joined have NULL values.DThe tables being joined have only unmatched data.EThe tables bei

题目
多选题
In which two cases would you use an outer join?（）
A

The tables being joined have NOT NULL columns.

B

The tables being joined have only matched data.

C

The columns being joined have NULL values.

D

The tables being joined have only unmatched data.

E

The tables being joined have both matched and unmatched data.

F

Only when the tables have a primary key/foreign key relationship.

相似考题

1.In which case would you use a FULL OUTER JOIN? ()A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.

2.Which two commands would you use to discard a candidate configuration?()A. rollbackB. deleteC. delete 0D. rollback 0

3.In which three cases would you use the USING clause?（）A、You want to create a nonequijoin.B、The tables to be joined have multiple NULL columns.C、The tables to be joined have columns of the same name and different data types.D、The tables to be joined have columns with the same name and compatible data types.E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

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

参考答案和解析
正确答案： C,A
解析： 暂无解析
更多“In which two cases would you use an outer join?（）”相关问题

  • 第1题：

    In which two cases would you use an outer join? （）

    • A、The tables being joined have NOT NULL columns.
    • B、The tables being joined have only matched data.
    • C、The columns being joined have NULL values.
    • D、The tables being joined have only unmatched data.
    • E、The tables being joined have both matched and unmatched data.
    • F、Only when the tables have a primary key-foreign key relationship.

    正确答案:C,E

  • 第2题：

    You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

    • A、use enterprise manager
    • B、use DBMS_SQL package
    • C、use DBMS_AWR package
    • D、use PRVT_WORKLOAD package
    • E、query the AWR snapshot repository objects
    • F、use DBMS_WORKLOAD_REPOSITORY package

    正确答案:A,F

  • 第3题：

    Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）

    • A、&
    • B、ACCEPT
    • C、PROMPT
    • D、&&

    正确答案:D

  • 第4题：

    多选题
    Which three are true regarding the use of outer joins? （）
    A

    You cannot use IN operator in a condition that involves an outerjoin.

    B

    You use (+) on both sides of the WHERE condition to perform an outerjoin.

    C

    You use (*) on both sides of the WHERE condition to perform an outerjoin.

    D

    You use an outerjoin to see only the rows that do not meet the join condition.

    E

    In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.

    F

    You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.


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

  • 第5题：

    多选题
    In which three cases would you use the USING clause?（）
    A

    You want to create a nonequijoin.

    B

    The tables to be joined have multiple NULL columns.

    C

    The tables to be joined have columns of the same name and different data types.

    D

    The tables to be joined have columns with the same name and compatible data types.

    E

    You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.


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

  • 第6题：

    多选题
    In which two cases would you use an outer join? （）
    A

    The tables being joined have NOT NULL columns.

    B

    The tables being joined have only matched data.

    C

    The columns being joined have NULL values.

    D

    The tables being joined have only unmatched data.

    E

    The tables being joined have both matched and unmatched data.

    F

    Only when the tables have a primary key-foreign key relationship.


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

  • 第7题：

    多选题
    Which two commands would you use to discard a candidate configuration?（）
    A

    rollback

    B

    delete

    C

    delete 0

    D

    rollback 0


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

  • 第8题：

    多选题
    Which two commands would you use to view OSPF routes?（）
    A

    show ip route ospf

    B

    show ospf routes

    C

    show route protocol ospf

    D

    show route


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

  • 第9题：

    单选题
    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);


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

  • 第10题：

    单选题
    You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）
    A

    Update the view to use an outer join between the Customers and Sales tables.

    B

    Create a clustered index on the v CustomerSales view.

    C

    Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.

    D

    Create a stored procedure for the business analysts that uses the v CustomerSales view.


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

  • 第11题：

    Which three are true regarding the use of outer joins? （）

    • A、You cannot use IN operator in a condition that involves an outerjoin.
    • B、You use (+) on both sides of the WHERE condition to perform an outerjoin.
    • C、You use (*) on both sides of the WHERE condition to perform an outerjoin.
    • D、You use an outerjoin to see only the rows that do not meet the join condition.
    • E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
    • F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

    正确答案:D,E,F

  • 第12题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第13题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第14题：

    多选题
    Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter?（）
    A

    FIND_TIMER

    B

    CREATE_TIMER

    C

    SET_TIMER

    D

    DELETE_TIMER

    E

    GET_APPLICATION_PROPERTY


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

  • 第15题：

    多选题
    You receive an alarm that your Junos device is experiencing problems regarding temperature. Which two commands would you use to investigate this problem?（）
    A

    show chassis hardware

    B

    show chassis temperature-thresholds

    C

    show chassis pic fpc-slot <value> pic-slot <value>

    D

    show chassis environment


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

  • 第16题：

    多选题
    Without calling JTAC, which two troubleshooting tools on a MAG Series device would you use to identify the cause of an authentication failure?（）
    A

    Remote Debugging

    B

    System Snapshot

    C

    User Access logs

    D

    Policy Tracing


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

  • 第17题：

    单选题
    On a Cisco Catalyst 4500 Series, the fail LED is lit for one if its two power supplies. Which command would you use to check on this problem ?（）
    A

    Show module

    B

    Show errdisable detect

    C

    Show environment

    D

    Show diagnostic content


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

  • 第18题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第19题：

    单选题
    In which case would you use a FULL OUTER JOIN? （）
    A

    Both tables have NULL values.

    B

    You want all unmatched data from one table.

    C

    You want all matched data from both tables.

    D

    You want all unmatched data from both tables.

    E

    One of the tables has more data than the other.

    F

    You want all matched and unmatched data from only one table.


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

相关内容