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

8th Grade - Professional Development

•

97 Qs

Similar activities

EverFi Module 2

3rd - 10th Grade

•

100 Qs

Information Systems

1st - 10th Grade

•

100 Qs

INFORMATIKA 2

6th - 8th Grade

•

100 Qs

Python Quiz - Till Basic String

University

•

100 Qs

Computer Architecture Year 7 EOU Test

6th Grade - University

•

100 Qs

C programming Midterm

University

•

94 Qs

J277-01 Parts 1.1, 1.2 & 1.6

8th - 10th Grade

•

93 Qs

UH 3 Simdig semester 2

10th Grade

•

100 Qs

SQL: GROUP Functions

Quiz

•

Computers

•

8th Grade - Professional Development

•

Practice Problem

•

Hard

Chetna Dass

Used 24+ times

FREE Resource

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

Create a free account and access millions of resources

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

100 questions

Python Turtle Practice Questions

Quiz

•

10th Grade

93 questions

Cybersecurity Midterm

Quiz

•

9th - 12th Grade

100 questions

ĐỀ CƯƠNG ÔN TẬP MÔN TIN HỌC

Quiz

•

University

100 questions

Information Security Quiz

Quiz

•

Professional Development

101 questions

Computer Fundamentals

Quiz

•

Professional Development

93 questions

EHE Module 03: Information Security Threats

Quiz

•

12th Grade

100 questions

march2024 monthly test

Quiz

•

Professional Development

100 questions

Computer

Quiz

•

8th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Computers

18 questions

Company Logos

Quiz

•

6th - 8th Grade

28 questions

logos

Lesson

•

10th Grade

24 questions

CP1 - HTML Review

Quiz

•

9th Grade

SQL: GROUP Functions

97 questions

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;

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

SQL: GROUP Functions

97 questions

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;

Create a free account and access millions of resources

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;