[Solved] Which of the following is the simplest ranking function?

McqMate

Q.	Which of the following is the simplest ranking function?
A.	rank
B.	ntile
C.	row_number
D.	none of the mentioned
Answer» C. row_number
Explanation: the row_number ranking function is the simplest of the ranking functions.its purpose in life is to provide consecutive numbering of the rows in the result set by the order selected in the over clause for each partition specified in the over clause.

3k

0

Do you find this helpful?

12

View all MCQs in

Information Retrival Techniques

Discussion

No comments yet

Related MCQs

Which of the following is not a ranking function?
Which of the following function is used when you want all tied rows to have the same ranking?
Which of the following function is used to find the column count of the particular resultset?
Which of the following is not an information domain required for determining function point in FPA ?
Which of the following function is used for k-means clustering?
Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?
Which function is used to return a handle to the database?
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is
Which of the function provides consecutive numbering except in the case of a tie?
F(X,Y,Z,M) = X`Y`Z`M`. The degree of the function is