itgle.com

Which two are true about aggregate functions?()A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix

题目

Which two are true about aggregate functions?()

  • A、You can use aggregate functions in any clause of a SELECT statement.
  • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
  • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
  • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
  • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
  • F、You cannot group the rows of a table by more than one column while using aggregate functions.

相似考题
更多“Which two are true about aggrega”相关问题
  • 第1题:

    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

  • 第2题:

    Which statement about Belgium is NOT true?

    A.it is twice as big as Beijing.
    B.it has two major ethnic groups.
    C.it has gone through quite a few threats of division.
    D.it has no government.

    答案:D
    解析:

  • 第3题:

    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

  • 第4题:

    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

  • 第5题:

    Which statement about WSA user authentication is true?() 

    • A、 a single WSA can have multiple LDAP realms
    • B、 WSA supports LDAP but not NTLM
    • C、 WSA supports NTLM but not LDAP
    • D、 a single WSA can have up to two authentication realms: one for LDAP and for NTLM

    正确答案:A

  • 第6题:

    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

  • 第7题:

    Which two statements are true about using the isUserInRole method to implement security in a Java EEapplication?()

    • A、It can be invoked only from the doGet or doPost methods.
    • B、It can be used independently of the getRemoteUser method.
    • C、Can return "true" even when its argument is NOT defined as a valid role name in the deployment descriptor.
    • D、Using the isUserInRole method overrides any declarative authentication related to the method in which it is invoked.

    正确答案:B,C

  • 第8题:

    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

  • 第9题:

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

  • 第10题:

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

  • 第11题:

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

  • 第12题:

    Which statement about two lines spliced together is TRUE ________.

    A.Splicing is used to increase the circumference of each line

    B.Splicing two lines together is stronger than knotting two lines together

    C.Splicing is used to increase the overall strength of the line

    D.Splicing is used to prevent rotting of the lines bitter end


    正确答案:B

  • 第13题:

    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.

    正确答案:B,C

  • 第14题:

    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

  • 第15题:

    Which two statements about static NAT translations are true?()

    • A、They are always present in the NAT table.
    • B、They allow connection to be initiated from the outside.
    • C、They can be configured with access lists, to allow two or more connections to be initiated from the outside.
    • D、They require no inside or outside interface markings because addresses are statically defined.

    正确答案:A,B

  • 第16题:

    Which statement is true about the digital to analog conversion process?()

    • A、the two steps of digital to analog conversion are decompression and reconstruction of the analog signal
    • B、the two steps of digital to analog conversion are decoding and filtering
    • C、the two steps of digital to analog conversion are decompression and filtering of the analog signal
    • D、the two steps of digital to analog conversion are quantization and decoding

    正确答案:B

  • 第17题:

    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

  • 第18题:

    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

  • 第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题:

    单选题
    Which statement is true about the digital to analog conversion process?()
    A

    the two steps of digital to analog conversion are decompression and reconstruction of the analog signal

    B

    the two steps of digital to analog conversion are decoding and filtering

    C

    the two steps of digital to analog conversion are decompression and filtering of the analog signal

    D

    the two steps of digital to analog conversion are quantization and decoding


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

  • 第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
    解析: 暂无解析