SQL: GROUP Functions

SQL: GROUP Functions

8th Grade - Professional Development

97 Qs

quiz-placeholder

Similar activities

100-200 <<ICT>>

100-200 <<ICT>>

University

100 Qs

AWS Services Quiz Class 7

AWS Services Quiz Class 7

Professional Development

99 Qs

SK SPM F5 (All Chapters)

SK SPM F5 (All Chapters)

11th Grade

100 Qs

(ROOM 2) TEST QUIZIZ OPEN LREK ASLAB  KOMPUTER 2024

(ROOM 2) TEST QUIZIZ OPEN LREK ASLAB KOMPUTER 2024

University

100 Qs

Apex and Salesforce Quiz 1

Apex and Salesforce Quiz 1

University

100 Qs

N5CS: Database Design

N5CS: Database Design

9th Grade

100 Qs

Mid-term cybersecurity

Mid-term cybersecurity

University

100 Qs

Python + Turing Lab + Code Combat + Computaional Thinking

Python + Turing Lab + Code Combat + Computaional Thinking

8th Grade

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?