多选题Which two are true about aggregate functions? （）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mi

题目
多选题
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 parameters 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.

相似考题

1.Which of the following is NOT true about the centrifugal separator?A.It can be applied to separate two liquidsB.It cannot separate solids which contaminated in the oil.C.It consists of purifier and clarifierD.The centrifuge arranged to separate two liquids is known as purifier

2.Examine the description of the STUDENTS table:Which two aggregate functions are valid on the START_DATE column?()A. SUM(start_date)B. AVG(start_date)C. COUNT(start_date)D. AVG(start_date, end_date)E. MIN(start_date)F. MAXIMUM(start_date)

3.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.

4.Which two are functions of Oracle Workflow Directory Service? ()(Choose two.)A. manage workflow notificationsB. provide information about rolesC. store performer and roles relationshipsD. manage workflow session connection

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

  • 第1题：

    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


    参考答案：A, C

  • 第2题：

    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

  • 第3题：

    Which two IntServ functions are required on a router？（）

    • A、admission control
    • B、DSCP classification
    • C、monitoring
    • D、marking
    • E、scheduling

    正确答案:A,E

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

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

  • 第8题：

    多选题
    Which two are functions of Oracle Workflow Directory Service? （）(Choose two.)
    A

    manage workflow notifications

    B

    provide information about roles

    C

    store performer and roles relationships

    D

    manage workflow session connection


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

  • 第9题：

    多选题
    Which two functions of the Junos OS are handled by the data plane? （）(Choose two.)
    A

    NAT

    B

    OSPF

    C

    SNMP

    D

    SCREEN options


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

  • 第10题：

    多选题
    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.


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

  • 第11题：

    多选题
    Which two statements are true regarding single row functions?（）
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    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
    解析：

  • 第15题：

    Which of these statements about penultimate hop popping are true？（）

    • A、It is used only for directly connected subnets or aggregate routes
    • B、It can only be used with LDP.
    • C、It is only used when two or more labels are stacked.
    • D、It enables the Edge LSR to request a label pop operation from Its upstream neighbors
    • E、It is requested through TDP using a special label value that is also called the implicit-null value.
    • F、It is requested through LDP using a special label value that is also called the implicit-null value.

    正确答案:D,E,F

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

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

  • 第21题：

    多选题
    The ERX Edge Router can utilize which two classifiers?（）
    A

    multi field

    B

    policy classifier

    C

    quality of service

    D

    behavior aggregate


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

  • 第22题：

    多选题
    Which two are character manipulation functions? （）
    A

    TRIM

    B

    REPLACE

    C

    TRUNC

    D

    TO_DATE

    E

    MOD

    F

    CASE


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

  • 第23题：

    多选题
    Which two IntServ functions are required on a router？（）
    A

    admission control

    B

    DSCP classification

    C

    monitoring

    D

    marking

    E

    scheduling


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

  • 第24题：

    多选题
    Which two functions require the use of the CLI?（） (Choose two.)
    A

    adding a VLAN

    B

    adding a cluster

    C

    running a tcpdump

    D

    adding a target server


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

相关内容