Which two are true about aggregate functions? ()

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

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)


参考答案:C, E

第2题:

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

第3题:

Which of the following is NOT true about the centrifugal separator?

A.It can be applied to separate two liquids

B.It cannot separate solids which contaminated in the oil.

C.It consists of purifier and clarifier

D.The centrifuge arranged to separate two liquids is known as purifier


答案:B

第4题:

Which two IntServ functions are required on a router?()

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

正确答案:A,E

第5题:

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

第6题:

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

第7题:

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

第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, C

第9题:

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

第10题:

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

更多相关问题