21 Advanced Querying questions from the SQL bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
A.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
B.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
C.the technique of turning distinct row values into columns to produce a cross-tabulated summary
D.a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
Answer + AI explanation with Pro
2. Which term means: "a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query"?
Junior
A.LATERAL join
B.PIVOT
C.CUBE
D.CASE expression
Answer + AI explanation with Pro
3. Which statement is correct?
Junior
A.CASE expression — a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
B.CASE expression — a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
C.CASE expression — a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
D.CASE expression — a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
Answer + AI explanation with Pro
4. What is ROLLUP?
Mid
A.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
C.a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
D.a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
Answer + AI explanation with Pro
5. Which term means: "a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions"?
Mid
A.GROUPING SETS
B.ROLLUP
C.CASE expression
D.PIVOT
Answer + AI explanation with Pro
6. Which statement is correct?
Mid
A.ROLLUP — a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.ROLLUP — the technique of turning distinct row values into columns to produce a cross-tabulated summary
C.ROLLUP — a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
D.ROLLUP — a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
Answer + AI explanation with Pro
7. What is CUBE?
Mid
A.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
C.a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
D.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
Answer + AI explanation with Pro
8. Which term means: "a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns"?
Mid
A.CUBE
B.GROUPING SETS
C.LATERAL join
D.ROLLUP
Answer + AI explanation with Pro
9. Which statement is correct?
Mid
A.CUBE — a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
B.CUBE — a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
C.CUBE — a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
D.CUBE — a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
Answer + AI explanation with Pro
10. What is GROUPING SETS?
Senior
A.a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
B.a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
C.the technique of turning distinct row values into columns to produce a cross-tabulated summary
D.a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
Answer + AI explanation with Pro
11. Which term means: "a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass"?
Senior
A.CASE expression
B.GROUPING SETS
C.LATERAL join
D.keyset pagination
Answer + AI explanation with Pro
12. Which statement is correct?
Senior
A.GROUPING SETS — a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.GROUPING SETS — a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
C.GROUPING SETS — a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
D.GROUPING SETS — a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
Answer + AI explanation with Pro
13. What is PIVOT?
Mid
A.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
C.a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
D.the technique of turning distinct row values into columns to produce a cross-tabulated summary
Answer + AI explanation with Pro
14. Which term means: "the technique of turning distinct row values into columns to produce a cross-tabulated summary"?
Mid
A.ROLLUP
B.PIVOT
C.LATERAL join
D.GROUPING SETS
Answer + AI explanation with Pro
15. Which statement is correct?
Mid
A.PIVOT — a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
B.PIVOT — a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
C.PIVOT — a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
D.PIVOT — the technique of turning distinct row values into columns to produce a cross-tabulated summary
Answer + AI explanation with Pro
16. What is LATERAL join?
Senior
A.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.the technique of turning distinct row values into columns to produce a cross-tabulated summary
C.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
D.a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
Answer + AI explanation with Pro
17. Which term means: "a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row"?
Senior
A.PIVOT
B.CASE expression
C.LATERAL join
D.GROUPING SETS
Answer + AI explanation with Pro
18. Which statement is correct?
Senior
A.LATERAL join — a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
B.LATERAL join — a GROUP BY extension generating hierarchical subtotal rows plus a grand total along the listed dimensions
C.LATERAL join — a GROUP BY extension letting you specify exactly which combinations of grouping columns to aggregate in one pass
D.LATERAL join — a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
Answer + AI explanation with Pro
19. What is keyset pagination?
Senior
A.a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
B.a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
C.a GROUP BY extension producing subtotals for every possible combination of the listed grouping columns
D.a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
Answer + AI explanation with Pro
20. Which term means: "a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET"?
Senior
A.keyset pagination
B.GROUPING SETS
C.CASE expression
D.CUBE
Answer + AI explanation with Pro
21. Which statement is correct?
Senior
A.keyset pagination — a join form (called CROSS APPLY in SQL Server) letting a subquery on the right reference columns from the table on the left for each row
B.keyset pagination — the technique of turning distinct row values into columns to produce a cross-tabulated summary
C.keyset pagination — a paging technique that fetches the next page by filtering on the last seen sort key, avoiding the growing cost of skipping rows with a large OFFSET
D.keyset pagination — a construct that returns different values based on evaluated conditions, providing if-then-else logic inside a query
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Advanced Querying question come with Pro.