itgle.com

单选题Which statement is true regarding subqueries?()A The LIKE operator cannot be used with single-row subqueries B The NOT IN operator is equivalent to IS NULL with single-row subqueries C =ANY and =ALL operators have the same functionality in multiple-row

题目
单选题
Which statement is true regarding subqueries?()
A

The LIKE operator cannot be used with single-row subqueries 

B

The NOT IN operator is equivalent to IS NULL with single-row subqueries 

C

=ANY and =ALL operators have the same functionality in multiple-row subqueries 

D

The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 


相似考题
参考答案和解析
正确答案: C
解析: 暂无解析
更多“Which statement is true regarding subqueries?()”相关问题
  • 第1题:

    Which statement is true regarding syslog on Junos devices?()

    • A、No logging is enabled by default
    • B、By default the information is stored in all file named events
    • C、Only the message severity level must be configured
    • D、You can configure the router to send log messages to the console

    正确答案:D

  • 第2题:

    Which two statements are true regarding the ORDER BY clause? ()

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第3题:

    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

  • 第4题:

    单选题
    Evaluate the following statement:   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()
    A

     They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

    B

     They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

    C

     They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

    D

     The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.


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

  • 第5题:

    单选题
    Which statement regarding the contents of the V$PARAMETER view is true?()
    A

    displays only the list of default values

    B

    displays only the list of all basic parameters

    C

    displays the currently in effect parameter values

    D

    displays only the list of all advanced parameters

    E

    displays the list of all the parameter files of a database


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

  • 第6题:

    单选题
    Regarding zone types, which statement is true?()
    A

    You cannot assign an interface to a functional zone.

    B

    You can specifiy a functional zone in a security policy.

    C

    Security zones must have a scheduler applied.

    D

    You can use a security zone for traffic destined for the device itself.


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

  • 第7题:

    单选题
    Which statement is true regarding syslog on Junos devices?()
    A

    No logging is enabled by default

    B

    By default the information is stored in all file named events

    C

    Only the message severity level must be configured

    D

    You can configure the router to send log messages to the console


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

  • 第8题:

    单选题
    Which statement is true regarding synonyms?()
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


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

  • 第9题:

    单选题
    Which statement is true regarding Flashback Version Query?()
    A

     It returns versions of rows only within a transaction.

    B

     It can be used in subqueries contained only in a SELECT statement.

    C

     It will return an error if the undo retention time is less than the lower bound time or SCN specified.

    D

     It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.


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

  • 第10题:

    多选题
    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
    解析: 暂无解析

  • 第11题:

    Identify the true statement regarding Temporary Coherence cluster members()

    • A、 it should have "localstorage" set to TRUE
    • B、 it should be configured so as to not trigger re-partitioning 
    • C、 both A and B are TRUE
    • D、 Neither A and B are TRUE

    正确答案:B

  • 第12题:

    Which statement is true regarding Flashback Version Query? ()

    • A、 It returns versions of rows only within a transaction.
    • B、 It can be used in subqueries contained only in a SELECT statement.
    • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
    • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

    正确答案:D

  • 第13题:

    Which statement is true regarding subqueries?()

    • A、The LIKE operator cannot be used with single-row subqueries 
    • B、The NOT IN operator is equivalent to IS NULL with single-row subqueries 
    • C、=ANY and =ALL operators have the same functionality in multiple-row subqueries 
    • D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 

    正确答案:D

  • 第14题:

    单选题
    Which of the following statement(s)is/are TRUE regarding a twin pedestal crane set().
    A

    The cranes may be operated independently

    B

    The cranes may be interconnected for twin operation

    C

    When twinned,the crane rotation on the foundation assembly is unlimited

    D

    All of the above


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

  • 第15题:

    单选题
    Which statement is true regarding NAT?()
    A

    NAT is not supported on SRX Series devices.

    B

    NAT requires special hardware on SRX Series devices.

    C

    NAT is processed in the control plane.

    D

    NAT is processed in the data plane.


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

  • 第16题:

    单选题
    Which statement is true regarding syslog on Junos devices?()
    A

    No logging is enabled by default.

    B

    By default, the information is stored in a file named events.

    C

    Only the message severity level must be configured.

    D

    You can configure the router to send log messages to the console.


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

  • 第17题:

    单选题
    Which statement is true regarding IPsec VPNs?()
    A

    There are five phases of IKE negotiation.

    B

    There are two phases of IKE negotiation.

    C

    IPsec VPN tunnels are not supported on SRX Series devices.

    D

    IPsec VPNs require a tunnel PIC in SRX Series devices.


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

  • 第18题:

    多选题
    Which three statements about subqueries are true? ()
    A

    Asinglerowsubquerycanretrieveonlyonecolumnandonerow.

    B

    Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.

    C

    Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.

    D

    Amultiplerowsubquerycanbecomparedusingthe;>;;operator.

    E

    AsinglerowsubquerycanusetheINoperator.

    F

    Amultiplerowsubquerycanusethe;=;operator.


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

  • 第19题:

    多选题
    Which three statements are true regarding subqueries?()
    A

    Subqueries can contain GROUP BY and ORDER BY clauses

    B

    Main query and subquery can get data from different tables

    C

    Main query and subquery must get data from the same tables

    D

    Subqueries can contain ORDER BY but not the GROUP BY clause

    E

    Only one column or expression can be compared between the main query and subquery

    F

    Multiple columns or expressions can be compared between the main query and subquery


    正确答案: C,E
    解析: 暂无解析