ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam
Go to Exam

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 Hide Answer
Suggested Answer: Explanation 🗳️
by cnyce at May 14, 2019, 4:02 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
webdata
2 years, 10 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
webdata
2 years, 10 months ago
So C&D
upvoted 1 times
...
...
jackymak
3 years, 4 months ago
I think its B,C. The aggregate function can only use on select clause. And C is obvious. As to D, I cant imagine putting a function inside
upvoted 1 times
...
Sugar
5 years, 4 months ago
They themselves dont know the answer. Hence, no answer provided. C is the only answer here.
upvoted 1 times
...
Andy840
5 years, 4 months ago
A & D ?
upvoted 1 times
...
cnyce
5 years, 7 months ago
I believe answers are C & D...is this correct, and if so, can it be added to question please?
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago