nerdexam
Oracle

1Z0-007 · Question #114

Which two are true about aggregate functions? (Choose two.)

The correct answer is A. You can use aggregate functions in any clause of a SELECT statement. D. You can pass column names, expressions, constants, or functions as parameter to an aggregate function. See the full explanation below for the reasoning.

Question

Which two are true about aggregate functions? (Choose two.)

Options

  • 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
  • CYou can mix single row columns with aggregate functions in the column list of a SELECT statement
  • DYou can pass column names, expressions, constants, or functions as parameter to an aggregate function.
  • EYou can use aggregate functions on a table, only by grouping the whole table as one single group.
  • FYou cannot group the rows of a table by more than one column while using aggregate functions.

How the community answered

(52 responses)
  • A
    83% (43)
  • B
    2% (1)
  • C
    2% (1)
  • E
    6% (3)
  • F
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice