SQL: GROUP Functions

SQL: GROUP Functions

8th Grade - Professional Development

97 Qs

quiz-placeholder

Similar activities

Database final

Database final

University

96 Qs

Quizz1

Quizz1

University

95 Qs

PRJ301

PRJ301

University

95 Qs

untitled

untitled

12th Grade - University

99 Qs

Google Sheets for Middle School

Google Sheets for Middle School

6th - 8th Grade

100 Qs

Penilaian Pasca UASA: SQL

Penilaian Pasca UASA: SQL

8th - 9th Grade

102 Qs

Windows OS Certification Review

Windows OS Certification Review

9th - 12th Grade

95 Qs

Uas Basisdata

Uas Basisdata

University

100 Qs

SQL: GROUP Functions

SQL: GROUP Functions

Assessment

Quiz

Computers

8th Grade - Professional Development

Hard

Created by

Chetna Dass

Used 24+ times

FREE Resource

97 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a GROUP BY function?

MAX

MIN

NVL

AVG

2.

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image


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 ;

4.

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)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Nested Tables

NUMBER

CLOB

DATE

6.

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;

12

6

9

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

7.

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;

12

6

9

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
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?