Oracle Database SQL Certified Associate Exam [sql]

Access More Questions

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?

ROWS BETWEEN 6 PRECEDING AND CURRENT ROW RANGE BETWEEN INTERVAL '6' DAY PRECEDING AND CURRENT ROW ROWS UNBOUNDED PRECEDING RANGE BETWEEN 6 PRECEDING AND CURRENT ROW

Correct Answer:

RANGE BETWEEN INTERVAL '6' DAY PRECEDING AND CURRENT ROW

Access more questions from this quiz

Continue to Oracle Database SQL Certified Associate Exam [sql] for more practice questions and the full quiz experience.

Access More Questions