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.
The answer should be C & D
http://content.yudu.com/Library/A1suc0/BeITCertifiedOracleF/resources/content/10.swf
how legit is that site?
I Agree with you Balthazar
it must be C&D
C & D the only answer
Cleared Oracle Database 11g 1Z0-051 exam last weekend!
Scored 90%! (The passing score is 60%)
There were 64 questions in my actual 1Z0-051 test.
Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.
Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!
I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive:
drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!