QuizzesNTILE — Concept Check
intermediate
sql

NTILE — Concept Check

Questions on NTILE. NTILE(n) distributes rows into n ranked buckets as evenly as possible, enabling quartile, decile, and percentile segmentation directly in SQL.

8 minutes 8 questions Pass at 70%
Time Limit
8 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

Questions in this quiz

8 questions on NTILE — Concept Check. Work through them here, then start the quiz to answer them and see your score.

  1. 1.A company wants to divide its customers into four spending groups. Which SQL function can they use to achieve this segmentation?

    • APERCENT_RANK()
    • BCUME_DIST()
    • CNTILE(4)
    • DRANK()
  2. 2.A retailer uses NTILE(10) to analyze sales data. What does each bucket represent?

    • AA decile of sales data
    • BA quartile of sales data
    • CA rank of sales data
    • DA percentile of sales data
  3. 3.A report shows customers in quartile 1 spend the least. What SQL function likely produced this grouping?

    • ANTILE(4)
    • BPERCENT_RANK()
    • CROW_NUMBER()
    • DCUME_DIST()
  4. 4.In a sales analysis, NTILE(10) is used. If there are 102 products, how many products are in the first decile?

    • A10
    • B11
    • C12
    • D9
  5. 5.A manager wants to find the top 10% spenders. Which function should they use?

    • ANTILE(10)
    • BPERCENT_RANK()
    • CCUME_DIST()
    • DROW_NUMBER()
  6. 6.A developer uses NTILE(4) but notices uneven group sizes. What might be the reason?

    • ANTILE(4) is only for quartiles
    • BThe total rows are not divisible by 4
    • CNTILE always creates equal groups
    • DNTILE requires a perfect division
  7. 7.A team uses PERCENT_RANK to evaluate performance. What does a rank of 0.9 indicate?

    • AThe row is in the top 10%
    • BThe row is in the bottom 10%
    • CThe row is in the middle 50%
    • DThe row is tied with 90%
  8. 8.Which function would you use to determine the cumulative distribution of a dataset?

    • ARANK()
    • BNTILE(n)
    • CCUME_DIST()
    • DPERCENT_RANK()