Windowing MCQ

Test your knowledge with important Windowing MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Windowing MCQs on Bissoy. Bissoy App

• LAST_VALUE comes in the category of _____________
  ক

  Ranking window function

  খ

  Associate window function

  গ

  Analytic window functions

  ঘ

  All of the mentioned
• Which of the following function is an analytic window function?
  ক

  LAG

  খ

  LEAD

  গ

  FIRST_VALUE

  ঘ

  None of the mentioned
• How many types of window functions are present in SQL Server?
  ক

  3

  খ

  4

  গ

  5

  ঘ

  6
• Which of the following is not a type of window function?
  ক

  Ranking window function

  খ

  Associate window function

  গ

  Analytic window functions

  ঘ

  All of the mentioned
• Which of the function is not a ranking window function?
  ক

  RANK

  খ

  NTILE

  গ

  ROW_NUMBER

  ঘ

  None of the mentioned
• Point out the wrong statement related to window function.
  ক

  They are used to provide details of a backup plans

  খ

  They are used to provide details of an aggregation

  গ

  They are used to provide details of an aggregation

  ঘ

  None of the mentioned
• Which is the most important benefit of window function?
  ক

  Aggregation

  খ

  Association

  গ

  Generalization

  ঘ

  All of the mentioned
• Windowing function was added in which of the following versions of SQL Server?
  ক

  2003

  খ

  2005

  গ

  2008

  ঘ

  None of the mentioned
• Which of the following is a set function?
  ক

  RANK

  খ

  NTILE

  গ

  Window

  ঘ

  All of the mentioned