Q. Mark for review 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 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.
- Oracle Overview
- Oracle Training Course
- Oracle Interview Questions
- Difference Between Oracle 11g and 12c and 10g
- Ora 28001 The Password Has Expired Error
- BR*Tools Documentation
- Oracle Wait Events Interview Questions
- Difference Between Primary, Secondary and Clustered Indexes in DBMS
- Difference Between Hot and Cold Backup
- Oracle Partitioning Interview Questions
- Update Statement Works in Oracle Architecture
- Differences Between SAP HANA and Oracle