Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

WHICH_OF_THE_FOLLOWING_FUNCTION_IS_A_ANALYTIC_WINDOW_FUNCTION_??$

A. LAG
B. LEAD
C. FIRST_VALUE
D. None of the mentioned
Answer» C. FIRST_VALUE
Discussion
2.

LAST_VALUE_comes_in_the_category_of_:$

A. Ranking window function
B. Associate window function
C. Analytic window functions
D. All of the mentioned
Answer» D. All of the mentioned
Discussion
3.

How many types of window functions are present in SQL Server ?

A. 3
B. 4
C. 5
D. 6
Answer» B. 4
Discussion
4.

Which of the following is not a type of window function ?

A. Ranking window function
B. Associate window function
C. Analytic window functions
D. All of the mentioned
Answer» C. Analytic window functions
Discussion
5.

Which of the the function is not a ranking window function ?

A. RANK
B. NTILE
C. ROW_NUMBER
D. None of the mentioned
Answer» B. NTILE
Discussion
6.

Point out the wrong statement related to window function :

A. They are used to provide details of an backup plans
B. They are used to provide details of an aggregation
C. They are used to provide details of an aggregation
D. None of the mentioned
Answer» C. They are used to provide details of an aggregation
Discussion
7.

Which is the most important benefit of window function ?

A. Aggregation
B. Association
C. Generalization
D. All of the mentioned
Answer» B. Association
Discussion
8.

Windowing function was added in which of the following versions of SQL Server ?

A. 2003
B. 2005
C. 2008
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
9.

Which of the following is a set function ?

A. RANK
B. NTILE
C. Window
D. All of the mentioned
Answer» E.
Discussion