Loading...

SQL Server

Point out the correct statement
  1. Windowing functions were added to the standard SQL:2003
  2. Windowing functions were added to the standard SQL:2008
  3. Windowing functions were added to the standard SQL:2012
  4. Windowing functions were added to the standard SQL:2014
Windowing functions were added to the standard SQL:2014
  1. 2003
  2. 2005
  3. 2008
  4. None of the mentioned
Which is the most important benefit of window function ?
  1. Aggregation
  2. Association
  3. Generalization
  4. All of the mentioned
Point out the wrong statement related to window function
  1. They are used to provide details of an backup plans
  2. They are used to provide details of an aggregation
  3. They are used to provide details of an aggregation
  4. None of the mentioned
Which of the the function is not a ranking window function
  1. RANK
  2. NTILE
  3. ROW_NUMBER
  4. None of the mentioned
Which of the following is not a type of window function
  1. Ranking window function
  2. Associate window function
  3. Analytic window functions
  4. All of the mentioned
How many types of window functions are present in SQL Server
  1. 3
  2. 4
  3. 5
  4. 6
Which of the following function is a analytic window function
  1. LAG
  2. LEAD
  3. FIRST_VALUE
  4. None of the mentioned
LAST_VALUE comes in the category of
  1. Ranking window function
  2. Associate window function
  3. Analytic window functions
  4. All of the mentioned
Which of the following is not a ranking function
  1. RANK
  2. NTILE
  3. ROW_NUMBER
  4. All of the mentioned