SQL Server Practice Test 2

1. The phrase “greater than at least one” is represented in SQL by ___________

2. Which of the following is not an aggregate function?

3. ___________ convert object properties into CSV objects.

4. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

5. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

6. Which of the following function returns true in the following code?

DECLARE @parent HierarchyId = (SELECT Node FROM H WHERE Name = 'Thuru')
DECLARE @parentNodeLevel int = (select NodeLevel from h where name = 'Thuru')
SELECT Node.ToString() AS NodeText, *  FROM H WHERE Node.IsDescendantOf(@parent) = 'TRUE' 
AND Node != @parent AND 
NodeLevel = @parentNodeLevel + 1

7. Select ID, name, dept name, salary * 1.1 where instructor;
The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

8. What is the hybrid model in SQL Server?

9. Which of the following function is used when you want all tied rows to have the same ranking?

10. Point out the wrong statement related to window function.