Loading...

SQL Server

Point out the wrong statement
  1. The ROW_NUMBER function simply assigns sequential numbering to the records of a result-set or to the records within groups of a result-set
  2. OVER clause is not required in all the ranking functions
  3. SQL Server introduced four different ranking functions
  4. All of the mentioned
Which of the following is the simplest ranking function
  1. RANK
  2. NTILE
  3. ROW_NUMBER
  4. None of the mentioned
Which of the clause is not mandatory
  1. OVER clause
  2. ORDER BY clause
  3. PARTITION BY clause
  4. All of the mentioned
Point out the wrong statement
  1. RANK() returns the rank of each row in the result set of partitioned column
  2. DENSE_RANK() is same as RANK() function. Only difference is returns rank without gaps
  3. NTILE() distributes the columns in an ordered partition into a specified number of groups
  4. ROW_NUMBER() returns the serial number of the row order by specified column
Which of the the function provides consecutive numbering except in the case of a tie
  1. RANK
  2. NTILE
  3. ROW_NUMBER
  4. None of the mentioned
Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function
  1. “The ranking function “ROW_NUMBER” must have an ORDER BY clause.”
  2. “The ranking function “ROW_NUMBER” must have an OVER BY clause.”
  3. “The ranking function “ROW_NUMBER” must have an PARTITION BY clause.”
  4. All of the mentioned
Which of the following functions are similar
  1. RANK and NTILE
  2. RANK and DENSE_RANK
  3. DENSE_RANK and NTILE
  4. None of the mentioned
Which of the following function is used when you want all tied rows to have the same ranking
  1. RANK
  2. NTILE
  3. ROW_NUMBER
  4. None of the mentioned
Select __________ from instructor where dept name= ’Comp. Sci.’ Which of the following should be used to find the mean of the salary
  1. Mean(salary)
  2. Avg(salary)
  3. Sum(salary)
  4. Count(salary)
The ________ connective tests for set membership, where the set is a collection of values produced by a select clause. The _________ connective tests for the absence of set membership
  1. Or, in
  2. Not in, in
  3. In, not in
  4. In, or