多选题Which two statements about subqueries are true?（）AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FR

题目
多选题
Which two statements about subqueries are true?（）
A

A single row subquery can retrieve data from only one table.

B

A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

C

A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.

D

A single row subquery can retrieve data from more than one table.

E

A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

F

A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

相似考题

1.Which two statements are true about pool－based source NAT? ()(Choose two.)A. PAT is not supported.B. PAT is enabled by default.C. It supports the address-persistent configuration option.D. It supports the junos-global configuration option.

2.Which two statements are true about precedence values in policy?() (Choose two.)A. 1 is the default precedence.B. A lower number is preferred.C. A higher number is preferred.D. 100 is the default precedence.

3.Which two statements about VACLs on Cisco Nexus 7000 Series Switches are true？ （）A、 A single VACL can be shared across two or more VDCs.B、 Use of VACLs requires no special license to be installed.C、 VACLs make use of IP or MAC ACLs.D、 Only options drop and forward are permitted.

4.Which two statements are true about AH?() (Choose two.)A. AH provides data integrity.B. AH is identified by IP protocol 50.C. AH is identified by IP protocol 51.D. AH cannot work in conjunction with ESP

更多“Which two statements about subqueries are true?（）”相关问题

  • 第1题：

    Which two statements are true about L2TP tunnels?（） (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第2题：

    Which two statements about the Cisco Nexus 1000V VSM are true?（）

    • A、It performs switching decisions and forwarding for the VEM
    • B、It can be run on a virtual machine
    • C、It can be used for remote VEM switching Iine cards

    正确答案:B,C

  • 第3题：

    Which two statements about VPLS are true？ （）

    • A、There is a full mesh of pseudowires.
    • B、There is a partial mesh of pseudowires.
    • C、Only L2TPv3 can be used for pseudowire establishment.
    • D、There is split-horizon to avoid loops.

    正确答案:A,D

  • 第4题：

    Which two statements are true about precedence values in policy?（） (Choose two.)

    • A、1 is the default precedence.
    • B、A lower number is preferred.
    • C、A higher number is preferred.
    • D、100 is the default precedence.

    正确答案:B,D

  • 第5题：

    Which two statements are true regarding subqueries? （）

    • A、A subquery can retrieve zero or more rows 
    • B、Only two subqueries can be placed atone level 
    • C、A subquery can be used only in SQL query statements 
    • D、A subquery can appear on either side of a comparison operator 
    • E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 

    正确答案:A,D

  • 第6题：

    Which two statements about subqueries are true? （）

    • A、A subquery should retrieve only one row.
    • B、A subquery can retrieve zero or more rows.
    • C、A subquery can be used only in SQL query statements.
    • D、Subqueries CANNOT be nested by more than two levels.
    • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
    • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

    正确答案:B,F

  • 第7题：

    Which three statements about subqueries are true? （）

    • A、Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
    • B、Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
    • C、Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
    • D、Amultiplerowsubquerycanbecomparedusingthe"；>；"；operator.
    • E、AsinglerowsubquerycanusetheINoperator.
    • F、Amultiplerowsubquerycanusethe"；="；operator.

    正确答案:B,C,E

  • 第8题：

    多选题
    Which two statements are true about L2TP tunnels?（） (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


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

  • 第9题：

    多选题
    Which two statements are true about AH?（） (Choose two.)
    A

    AH provides data integrity.

    B

    AH is identified by IP protocol 50.

    C

    AH is identified by IP protocol 51.

    D

    AH cannot work in conjunction with ESP


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

  • 第10题：

    多选题
    Which two statements about SCSI are true？ （）
    A

    The bus is limited to 32 devices

    B

    It is a full duplex serial standard

    C

    It is a half-duplex serial standard

    D

    It allows up to 320 MB/s of shared channel bandwidth


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

  • 第11题：

    多选题
    Which two statements about subqueries are true? （）
    A

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


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

  • 第12题：

    多选题
    Which two statements are true about WHERE and HAVING clauses? （）
    A

    A WHERE clause can be used to restrict both rows and groups.

    B

    A WHERE clause can be used to restrict rows only.

    C

    A HAVING clause can be used to restrict both rows and groups.

    D

    A HAVING clause can be used to restrict groups only.

    E

    A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

    F

    A HAVING clause CANNOT be used in subqueries.


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

  • 第13题：

    Which two statements are true about traffic shaping？（）

    • A、Out-of-profile packets are queued.
    • B、It causes TCP retransmits.
    • C、Marking/remarking is not supported.
    • D、It does not respond to BECN and ForeSight Messages.
    • E、It uses a single/two-bucket mechanism for metering.

    正确答案:A,C

  • 第14题：

    Which two statements about OSPF IPv6 routing are true？（）

    • A、It requires OSPF version 3.
    • B、automatically detects neighbors over NHMA interfaces
    • C、It supports encryption using
    • D、It uses LSA type 9
    • E、It uses LSA type 8

    正确答案:A,E

  • 第15题：

    Which two statements are true about pool-based source NAT? （）(Choose two.)

    • A、PAT is not supported.
    • B、PAT is enabled by default.
    • C、It supports the address-persistent configuration option.
    • D、It supports the junos-global configuration option.

    正确答案:B,C

  • 第16题：

    Which two statements are true about WHERE and HAVING clauses? （）

    • A、A WHERE clause can be used to restrict both rows and groups.
    • B、A WHERE clause can be used to restrict rows only.
    • C、A HAVING clause can be used to restrict both rows and groups.
    • D、A HAVING clause can be used to restrict groups only.
    • E、A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
    • F、A HAVING clause CANNOT be used in subqueries.

    正确答案:B,D

  • 第17题：

    Which two statements are true about standard database auditing（）

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第18题：

    Which two statements are true about record groups?（）

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第19题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level
    • C、Constraints can be created after the table is created
    • D、Constraints can be created at the same time the table is created
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

    正确答案:C,D

  • 第20题：

    多选题
    By default, which two statements are true about export routing polices?（）
    A

    Export polices can evaluate only active routes

    B

    Export polices can evaluate all routes

    C

    Export polices can be applied to the forwarding table

    D

    Export polices can be applied to interfaces


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

  • 第21题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level

    C

    Constraints can be created after the table is created

    D

    Constraints can be created at the same time the table is created

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view


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

  • 第22题：

    多选题
    Which three statements about subqueries are true? （）
    A

    Asinglerowsubquerycanretrieveonlyonecolumnandonerow.

    B

    Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.

    C

    Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.

    D

    Amultiplerowsubquerycanbecomparedusingthe；>；；operator.

    E

    AsinglerowsubquerycanusetheINoperator.

    F

    Amultiplerowsubquerycanusethe；=；operator.


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

  • 第23题：

    多选题
    Which two statements are true regarding subqueries? （）
    A

    A subquery can retrieve zero or more rows

    B

    Only two subqueries can be placed atone level

    C

    A subquery can be used only in SQL query statements

    D

    A subquery can appear on either side of a comparison operator

    E

    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement


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

  • 第24题：

    多选题
    Which two statements are true about traffic shaping？（）
    A

    Out-of-profile packets are queued.

    B

    It causes TCP retransmits.

    C

    Marking/remarking is not supported.

    D

    It does not respond to BECN and ForeSight Messages.

    E

    It uses a single/two-bucket mechanism for metering.


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

相关内容