SQL4-Join/aggregate functions/group by

SQL4-Join/aggregate functions/group by

University

19 Qs

quiz-placeholder

Similar activities

Linked list 1

Linked list 1

University

20 Qs

SQL

SQL

10th Grade - University

20 Qs

SQL and Database Quiz

SQL and Database Quiz

University

15 Qs

Aplikasi Pengolah Angka

Aplikasi Pengolah Angka

12th Grade - University

20 Qs

SQL T2

SQL T2

University

23 Qs

Tryout TIK level 6.1

Tryout TIK level 6.1

6th Grade - University

20 Qs

Google Sheets ReViEw

Google Sheets ReViEw

KG - University

18 Qs

ICT Short Quiz

ICT Short Quiz

University

20 Qs

SQL4-Join/aggregate functions/group by

SQL4-Join/aggregate functions/group by

Assessment

Quiz

Computers

University

Medium

Created by

M Ling

Used 52+ times

FREE Resource

19 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 CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a GROUP BY function?

MAX

MIN

NVL

AVG

3.

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

4.

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 ;

5.

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)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Nested Tables

NUMBER

CLOB

DATE

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?