Skip to content

Search for:

GK Quiz
Sports Quiz
Space Quiz
Festivals Quiz

Python Quiz
GK Quiz
Space Quiz
Sports Quiz

Search for:

Test Your Knowledge

SQL Quiz
0

Quiz on SQL Analytic Functions

by Quiz Orbit Team

SQL Analytic Functions such as LEAD(), LAG(), NTILE(), FIRST_VALUE(), and LAST_VALUE() are powerful tools for analyzing data within ordered partitions. These functions provide access to adjacent row values without complex self-joins, making them essential for time-series, trend analysis, and advanced reporting.

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 15
1. Question
What does the LAG() function do in SQL?
- Returns the next row's value
- Returns the current row value
- Returns a previous row’s value
- Aggregates column values
Correct
Incorrect
Question 2 of 15
2. Question
What is the primary use of the LEAD() function in SQL?
- To find max value
- To retrieve next row’s value
- To sort rows
- To find first row
Correct
Incorrect
Question 3 of 15
3. Question
Which analytic function is used to distribute rows into buckets or groups?
- RANK()
- NTILE()
- LAG()
- DENSE_RANK()
Correct
Incorrect
Question 4 of 15
4. Question
What happens if the LEAD() function tries to access a row beyond the result set?
- Error
- NULL is returned
- Zero is returned
- Last row is repeated
Correct
Incorrect
Question 5 of 15
5. Question
What does this query return?
LAG(salary, 1) OVER (ORDER BY salary)
- Salary of next row
- Salary of previous row
- Difference between rows
- Rank of salary
Correct
Incorrect
Question 6 of 15
6. Question
Which clause must be used with analytic functions like LAG() and LEAD()?
- GROUP BY
- ORDER BY inside OVER()
- HAVING
- WHERE
Correct
Incorrect
Question 7 of 15
7. Question
How many groups are created by NTILE(4) on 10 rows?
- 2
- 3
- 4
- 5
Correct
Incorrect
Question 8 of 15
8. Question
Which analytic function returns the first value in the partition?
- FIRST_VALUE()
- LEAD()
- NTILE()
- RANK()
Correct
Incorrect
Question 9 of 15
9. Question
Which function returns the last value within an ordered partition?
- LAST()
- MAX()
- LAST_VALUE()
- RANK()
Correct
Incorrect
Question 10 of 15
10. Question
How is NTILE() different from RANK() or DENSE_RANK()?
- It doesn't rank
- It groups rows
- It sorts alphabetically
- It aggregates values
Correct
Incorrect
Question 11 of 15
11. Question
What’s the result of LAG(price, 2, 0) if only 1 previous row exists?
- NULL
- Error
- 0
- Previous row value
Correct
Incorrect
Question 12 of 15
12. Question
Can LAG() and LEAD() be used with partitions?
- No
- Only LAG
- Only LEAD
- Yes, with PARTITION BY
Correct
Incorrect
Question 13 of 15
13. Question
Which of the following is NOT an analytic function?
- LAG()
- NTILE()
- LEAD()
- COUNT()
Correct
Incorrect
Question 14 of 15
14. Question
What does FIRST_VALUE() consider by default?
- Alphabetic order
- Order by row ID
- Order specified in OVER()
- NULLs first
Correct
Incorrect
Question 15 of 15
15. Question
In which scenario is NTILE() most helpful?
- Getting top 10 salary
- Finding moving average
- Splitting data into quartiles
- Joining tables
Correct
Incorrect

Summary

SQL Analytic Functions like LEAD(), LAG(), NTILE(), FIRST_VALUE(), and LAST_VALUE() enhance your ability to perform row-by-row comparisons, rank distribution, and time-based trends—all without messy joins. These are crucial tools for reporting, trend analysis, and BI dashboards.

Tags: analytic function quiz in sql mcq on sql analytic functions quiz on analytic function in sql quiz on sql analytic functions SQL Quiz sql quiz on analytic functions

Quiz Orbit Team

At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Next story Quiz on Cumulative Totals & Running Totals in Power BI
Previous story Quiz on Variables in Power BI DAX

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.