21 real Advanced Analytics questions from the SQL bank, as asked in Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd — free to start.
1. What is Window frame clause?
Senior
A.the part of a window definition that uses ROWS or RANGE to bound which surrounding rows the calculation includes
B.a function that distributes the partition's rows into a specified number of roughly equal buckets and labels each row with its bucket number
C.a reusable window specification declared once in a WINDOW clause and referenced by name across several functions
D.a function that returns the value from the first row of the current window frame
A.Window frame clause — the part of a window definition that uses ROWS or RANGE to bound which surrounding rows the calculation includes
B.Window frame clause — a reusable window specification declared once in a WINDOW clause and referenced by name across several functions
C.Window frame clause — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
D.Window frame clause — a function giving the relative rank of a row as its rank minus one divided by the number of partition rows minus one
5. Which term means: "a function that distributes the partition's rows into a specified number of roughly equal buckets and labels each row with its bucket number"?
A.NTILE — the part of a window definition that uses ROWS or RANGE to bound which surrounding rows the calculation includes
B.NTILE — a function that returns the value from the first row of the current window frame
C.NTILE — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
D.NTILE — a function that distributes the partition's rows into a specified number of roughly equal buckets and labels each row with its bucket number
11. Which term means: "a function giving the cumulative distribution, the fraction of partition rows with a value less than or equal to the current row"?
A.CUME_DIST — a function giving the cumulative distribution, the fraction of partition rows with a value less than or equal to the current row
B.CUME_DIST — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
C.CUME_DIST — a function that returns the value from the first row of the current window frame
D.CUME_DIST — a function giving the relative rank of a row as its rank minus one divided by the number of partition rows minus one
A.PERCENT_RANK — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
B.PERCENT_RANK — a function that distributes the partition's rows into a specified number of roughly equal buckets and labels each row with its bucket number
C.PERCENT_RANK — a function giving the relative rank of a row as its rank minus one divided by the number of partition rows minus one
D.PERCENT_RANK — a reusable window specification declared once in a WINDOW clause and referenced by name across several functions
17. Which term means: "the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY"?
A.Default window frame — the part of a window definition that uses ROWS or RANGE to bound which surrounding rows the calculation includes
B.Default window frame — a function giving the relative rank of a row as its rank minus one divided by the number of partition rows minus one
C.Default window frame — a function that returns the value from the first row of the current window frame
D.Default window frame — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
A.Named window — a function that distributes the partition's rows into a specified number of roughly equal buckets and labels each row with its bucket number
B.Named window — a reusable window specification declared once in a WINDOW clause and referenced by name across several functions
C.Named window — the implicit RANGE bound from the partition start through the current row and its peers used when no explicit frame is written with an ORDER BY
D.Named window — a function that returns the value from the first row of the current window frame
Answers, AI explanations, and a scored voice mock interview
Sign up free to check your answers with explanations, ask the AI tutor anything on any question, and take one full AI mock interview — scored like a real panel.