
SQL4-Join/aggregate functions/group by
Authored by M Ling
Computers
University
Used 52+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
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
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
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
15 questions
Javascript Array dan Object
Quiz
•
University
18 questions
Multiplexers
Quiz
•
University
20 questions
Skill Competition Quiz 2024
Quiz
•
10th Grade - University
15 questions
GDSC Intro Quiz
Quiz
•
University
20 questions
2. Ayo Main Quiz Lagi
Quiz
•
University - Professi...
17 questions
Grade 4 Computer Science Quiz
Quiz
•
4th Grade - University
14 questions
Microsoft Excel Advanced Features
Quiz
•
1st Grade - University
20 questions
Spreadsheet Fundamentals - Quiz2
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
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