What happens when the below query is executed in SQL* Plus? SELECT COUNT () FROM dual ;

Throws exception "ORA-00909: invalid number of arguments"

Executes successfully and returns no output

Executes successfully and returns output as '1'

Throws exception "ORA-00904: "COUNT": invalid identifier" because COUNT function doesn't works with DUAL table

Examine the given table structure and predict the outcome of the following query.

The query throws error because equal sign cannot be used when searching for NULL value

The query returns the number of employees who have no commission

The query returns the number of employees in a department whose commission is NULL value

The query throws error because GROUP BY clause is missing in the query

Which of the following statements is true about the group functions?

The AVG function can be used only with numeric data.

The MIN function can be used only with numeric data.

The MAX function can be used only with date values.

The SUM function can't be part of a nested function.

Which of the following is a valid SELECT statement?

SELECT AVG ( retail - cost ) FROM books GROUP BY category ;

SELECT category , AVG ( retail - cost ) FROM books ;

SELECT category , AVG ( retail - cost ) FROM books WHERE AVG ( retail - cost ) > 8.56 GROUP BY category ;

SELECT category , AVG ( retail - cost ) Profit FROM books GROUP BY category HAVING profit > 8.56 ;

Which of the following statements is correct?

The GROUP BY clause is always processed before the HAVING clause.

The WHERE clause can contain a group function only if the function isn't also listed in the SELECT clause.

Group functions can't be used in the SELECT, FROM, or WHERE clauses.

The HAVING clause is always processed before the WHERE clause.

Which of the following is not a valid SQL statement?

SELECT MIN ( pubdate ) FROM books GROUP BY category HAVING pubid = 4 ;

SELECT MIN ( pubdate ) FROM books WHERE category = 'COOKING' ;

SELECT COUNT (*) FROM orders WHERE customer # = 1005;

SELECT MAX ( COUNT ( customer #)) FROM orders GROUP BY customer#;

Which of the following statements is correct? (Select all that apply)

The WHERE clause restricts which rows are processed.

The HAVING clause determines which groups are displayed in the query results.

The COUNT function can be used to determine how many rows contain a NULL value.

Only distinct values are included in group functions, unless the ALL keyword is included in the SELECT clause.

Which of the following is a valid SQL statement?

SELECT customer #, COUNT(order#) FROM orders GROUP BY customer#;

SELECT customer #, order#, MAX(shipdate-orderdate) FROM orders GROUP BY customer# WHERE customer# = 1001;

SELECT customer #, COUNT(order#) FROM orders GROUP BY COUNT(order#);

SELECT customer #, COUNT(order#) FROM orders GROUP BY order#;

Which of the following SELECT statements lists only the book with the largest profit?

SELECT title , MAX ( retail - cost ) FROM books GROUP BY title ;

SELECT title , MAX ( retail - cost ) FROM books GROUP BY title HAVING MAX ( retail - cost );

SELECT title , MAX ( retail - cost ) FROM books ;

Which of the following SELECT statements lists the highest retail price of all books in the Family category?

SELECT MAX ( retail ) FROM books WHERE category = 'FAMILY' ;

SELECT MAX ( retail ) FROM books HAVING category = 'FAMILY' ;

SELECT retail FROM books WHERE category = 'FAMILY' HAVING MAX ( retail );

Which of the following is not a valid statement?

You must enter the ALL keyword in a group function to include all duplicate values.

The AVG function can be used to find the average calculated difference between two dates.

The MIN and MAX functions can be used on VARCHAR2 columns.

Which of the following SQL statements determines how many total customers were referred by other customers?

SELECT COUNT ( referred ) FROM customers ;

SELECT customer #, SUM(referred) FROM customers GROUP BY customer#;

SELECT COUNT (*) FROM customers ;

SELECT COUNT (*) FROM customers WHERE referred IS NULL ;

Examine the structure of the EMPLOYEES table as given. Which query will return the minimum salary in each department?

SELECT department_id , MIN ( salary ) from EMPLOYEES GROUP BY department_id ;

SELECT department_id , MIN ( salary ) from EMPLOYEES ;

SELECT department_id , MIN ( salary ) from EMPLOYEES GROUP BY salary ;

SELECT department_id , MIN ( salary ) from EMPLOYEES GROUP BY employee_id ;

Examine the structure for the table EMPLOYEES and Interpret the output of the below query

It executes successfully where COUNT(*) including NULLs and COUNT(all comm) excluding NULLs.

It throws error because only one aggregate function can be used in a query.

It throws error because GROUP BY clause is missing.

It executes successfully and returns same values for both.

Which of the following are true about group functions?

You can mix single row columns with group functions in the column list of a SELECT statement by grouping on the single row columns.

You can use group functions in any clause of a SELECT statement.

You can use group functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.

You can pass column names, expressions, constants, or functions as parameter to an group function.

Examine the structure of the table EMPLOYEES as given. You want to create a "emp_dept_sales" view by executing the following SQL statements. Which statement is true regarding the execution of the above statement?

The view will be created but no DML operations will be allowed on the view

The view will be created and you can perform DLM operations on the view

The view will not be created because the join statements are not allowed for creating a view

The view will not be created because the GROUP BY clause is not allowed for creating a view

Which of the following statements are true regarding views? (Select all that apply)

A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table

A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated

A sub query that defines a view cannot include the GROUP BY clause

A view is created with the sub query having the DISTINCT keyword can be updated

Examine the table structure as given. Which of the below SELECT query will display the maximum and minimum salary earned by each job category?

SELECT job , MAX ( salary ), MIN ( salary ) FROM employees GROUP BY job ;

SELECT job , MAX ( salary ), MIN ( salary ) FROM employees GROUP BY department_id ;

SELECT job , MAX ( salary ), MIN ( salary ) FROM employees ;

Two aggregate functions cannot be used together in SELECT statement.

Examine the table structure as given.

It executes successfully and lists the count of employees under each category having sum of salary greater than 5000.

It executes successfully and lists the count of employees under each job category but ignores the HAVING clause since "salary " is not in GROUP BY clause.

It throws error because HAVING clause is invalid.

It throws error because "salary " is not included in the GROUP BY clause.

What is true of using group functions on columns that contain NULL values?

Group functions on columns ignore NULL values.

Group functions on columns returning dates include NULL values.

Group functions on columns returning numbers include NULL values.

Group functions on columns cannot be accurately used on columns that contain NULL values.

Which of the following statetments are true about the usage of GROUP BY columns in a subquery?

Subqueries can contain GROUP BY and ORDER BY clauses.

Subqueries cannot contain GROUP BY and ORDER BY clauses.

Subqueries can contain ORDER BY but not the GROUP BY clause.

Subqueries cannot contain ORDER BY but can have GROUP BY clause.

Predict the outcome of the below query SELECT avg ( max ( salary )) FROM employees GROUP BY department_id HAVING avg ( max ( salary ))> 100 ;

It gives an error because the HAVING clause is not valid.

It gives an error because the GROUP BY expression is not valid.

It gives an error because aggregate functions cannot be nested in SELECT statement.

Predict the output of the below query SELECT avg ( salary ), department_id FROM employees GROUP BY department_id ;

It executes successfully and gives average salary in each department.

It gives error because an aggregate function cannot appear just after SELECT clause.

It gives error because GROUP BY clause is invalid.

It executes without errors but produces no output.

Predict the output of the below query SELECT lower ( job ), avg ( salary ) FROM employees GROUP BY upper ( job );

It throws error because case conversion in the SELECT list mismatches with the case conversion GROUP BY clause.

It executes successfully and displays "job" in lower case.

It executes successfully but display "job" in original case.

It throws error because singe row and aggregate functions cannot be used together.

Which of the below query executes successfully? (Select all that apply)

SELECT AVG ( salary ), MAX ( salary ) FROM employees ;

SELECT AVG ( salary ), MAX ( salary ) FROM employees GROUP BY department_id ;

SELECT employee_id , COUNT ( hiredate - sysdate ) FROM employees ;

SELECT AVG ( hiredate ) FROM employees ;

Identify the error in the below SELECT statement. SELECT department_id , AVG ( salary ) FROM employees GROUP BY department_id HAVING department_id > 10 ;

It executes successfully and displays average salary of departments higher than 10.

It throws error because non aggregated column cannot be used in HAVING clause.

It executes successfully but displays wrong result for the departments.

It throws error because HAVING clause must be placed before GROUP BY clause.

Predict the output of the below query SELECT department_id , AVG ( salary ) FROM employees GROUP BY department_id HAVING ( department_id > 10 and AVG ( salary )> 2000 );

It executes successfully and displays average salary of department higher than 10 and greater than 2000.

It throws error because multiple conditions cannot be given in HAVING clause.

It throws error because a non aggregate column cannot be used in HAVING clause.

It executes successfully but no result is displayed.

Which of the following statements are true? (Select all that apply)

AVG and SUM can be used only with numeric data types.

STDDEV and VARIANCE can be used only with numeric data types.

MAX and MIN cannot be used with LOB or LONG data types.

MAX can be used with LONG data type.

Examine the table structure as given.

No errors and it executes successfully

Multiple aggregate functions cannot be used in a single SELECT query

COUNT function cannot be used with DATE values

SQL: GROUP Functions

Authored by Chetna Dass

Computers

8th Grade - Professional Development

Used 24+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

97 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a GROUP BY function?

MAX

MIN

NVL

AVG

MULTIPLE SELECT QUESTION

30 sec • 1 pt

Which of the following functions can be used without GROUP BY clause in SELECT query? (Select all that apply)

COUNT

MAX

MIN

AVG

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following SELECT query returns the department number with maximum salary compensated to an employee? (Consider the table structure as given)

SELECT department_id , max(salary ) FROM employees ;

SELECT department_id , max(salary ) FROM employees GROUP BY department_id ;

SELECT max(salary ) FROM employees GROUP BY department_id ;

SELECT max(salary ) FROM employees ;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following statements are true about the COUNT function?

The COUNT function counts the number of rows

The COUNT(*) function counts the number of rows with duplicates and NULL values

The COUNT(DISTINCT) function counts the number of distinct rows

COUNT(*) is equivalent to COUNT(ALL)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the appropriate data types accepted by GROUP BY functions?

Nested Tables

NUMBER

CLOB

DATE

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.

SELECT COUNT (*) FROM t_count;

Throws exception because COUNT function doesn't works with NULL values

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.

SELECT COUNT (num) FROM t_count;

Throws exception because COUNT function doesn't works with NULL values

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

93 questions

Ôn Tập Giữa Học Kỳ 1 - Tin Học 11

Quiz

•

11th Grade - University

100 questions

Fundamentals of Information Systems

Quiz

•

Professional Development

100 questions

M3 R5 Chapter 8

Quiz

•

12th Grade - University

99 questions

AWS Services Quiz Class 7

Quiz

•

Professional Development

100 questions

N5CS: Database Design

Quiz

•

9th Grade

100 questions

SK SPM F5 (All Chapters)

Quiz

•

11th Grade

99 questions

Chapter 21: Common Types of Attacks

Quiz

•

11th Grade

100 questions

(ROOM 2) TEST QUIZIZ OPEN LREK ASLAB KOMPUTER 2024

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

30 questions

Quiz 1 Review

Quiz

•

University

SQL: GROUP Functions

Which of the following is NOT a GROUP BY function?

Which of the following functions can be used without GROUP BY clause in SELECT query? (Select all that apply)

Which of the following SELECT query returns the department number with maximum salary compensated to an employee? (Consider the table structure as given)

Which of the following statements are true about the COUNT function?

What are the appropriate data types accepted by GROUP BY functions?

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (*) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (ALL num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (DISTINCT num) FROM t_count;

What happens when the below query is executed in SQL* Plus?
SELECT COUNT() FROM dual;

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

SQL: GROUP Functions

Which of the following is NOT a GROUP BY function?

Which of the following functions can be used without GROUP BY clause in SELECT query? (Select all that apply)

Which of the following SELECT query returns the department number with maximum salary compensated to an employee? (Consider the table structure as given)

Which of the following statements are true about the COUNT function?

What are the appropriate data types accepted by GROUP BY functions?

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.SELECT COUNT (*) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.SELECT COUNT (num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.SELECT COUNT (ALL num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.SELECT COUNT (DISTINCT num) FROM t_count;

What happens when the below query is executed in SQL* Plus?SELECT COUNT() FROM dual;

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (*) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (ALL num) FROM t_count;

A table T_COUNT has 12 number values as 1, 2, 3, 32, 1, 1, null, 24, 12, null, 32, null. Predict the output of the below query.
SELECT COUNT (DISTINCT num) FROM t_count;

What happens when the below query is executed in SQL* Plus?
SELECT COUNT() FROM dual;