Register
Question 1
A financial analyst needs to calculate the month-over-month sales growth. The table `MonthlySales` has columns `Product`, `SaleMonth`, and `TotalSales`. Which window function is best suited to retrieve the previous month's sales amount on the same row as the current month's sales to facilitate the calculation?
Correct Answer:
LAG(TotalSales) OVER (PARTITION BY Product ORDER BY SaleMonth)
Question 2
A marketing team wants to segment its customer base into four equal-sized groups (quartiles) based on their total purchase amount to identify top spenders. Which window function is specifically designed to divide an ordered partition of rows into a specified number of ranked groups?
Correct Answer:
NTILE(4)
Question 3
When calculating a 7-day moving average for website traffic, the data table `TrafficLog` has multiple entries for the same date. To ensure the window frame for the average calculation correctly includes all data from the 6 preceding calendar days plus the current day (regardless of the number of rows), which framing clause is most appropriate?
Correct Answer:
RANGE BETWEEN INTERVAL '6' DAY PRECEDING AND CURRENT ROW
Question 4
A data analyst wants to create a report showing each employee's salary alongside the highest salary within their respective department. Which of the following window functions, when used with `OVER (PARTITION BY Department ORDER BY Salary DESC)`, will correctly identify the top salary for the department on every employee's row?
Correct Answer:
FIRST_VALUE(Salary)
Question 5
A university needs to find the relative rank of each student's GPA, defined as the percentage of students with a GPA less than or equal to the current student's GPA. Which window function calculates this cumulative distribution?
Correct Answer:
CUME_DIST()
Question 1
Exam overview

About this Exam

Prepare with the Oracle Database SQL Certified Associate Exam [sql] practice quiz. This question bank includes 78 questions covering table, data, database, query, and sales. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

Oracle Database SQL Certified Associate Exam [sql]

This practice set contains 78 questions from the matching question bank and focuses on table, data, database, query, and sales. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions

ISC2 Certified in Cybersecurity Practice Exam

0 min

ArcGIS Online Administration Associate Practice Test

0 min

ArcGIS Online Administration Associate Practice Test

0 min

Arizona CNA Certified Nursing Assistant Practice Exam

0 min

Certified Professional Public Buyer (CPPB) Practice Exam

0 min

Certified Specialist Business Intelligence (CSBI) Practice Test

0 min