Exam 1z0-061 topic 2 question 30 discussion

Actual exam question from Oracle's 1z0-061

Question #: 30
Topic #: 2

[All 1z0-061 Questions]

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

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

Show Suggested Answer

Suggested Answer: Explanation 🗳️

by cnyce at May 14, 2019, 4:02 p.m.

Comments

Submit Cancel

webdata

3 years, 3 months ago

A-B : False (We can't use agg functions in where clause) E-F : False So C&B are Good. D : True, we can use expressions in agg functions, i'ts not only for column name, we can do more like sum( case when col_1 > 2 then 1 else 0 end) for a count etc in test case.. C : True

upvoted 1 times