SQL Server Interview Questions - 35 | Snaprecruit.com

SQL Server Interview Questions - 35 | Snaprecruit.com

SQL Server interview questions part 35

SQL Server interview questions part 35

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

1. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

Correct Answer is : sys.dm_exec_connections

2. ___________ is stored only in the Master database.

Correct Answer is : None of the mentioned

3. Which of the following requires VIEW SERVER STATE permission on the server ?

Correct Answer is : sys.dm_os_wait_stats

4. Point out the correct statement :

Correct Answer is : 510: CXPACKET indicates parallelism

5. How many types of wait occur in SQL Server ?

Correct Answer is : 3

6. The contents of sys.dm_os_wait_stats can be reset by running the following command:

Correct Answer is : DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);

7. Point out the wrong statement :

Correct Answer is : Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem

8. ______ waits occur when a worker requests access to a resource that is not available because the resource is being used by some other worker or is not yet available.

Correct Answer is : Resource

9. Which of the following wait occurs when a task is waiting for I/Os to finish ?

Correct Answer is : ASYNC_NETWORK_IO

10. When does BROKER_TO_FLUSH wait type event occurs ?

Correct Answer is : When the Service Broker lazy flusher flushes the in-memory transmission objects to a work table

11. Which of the following wait type is for internal use only ?

Correct Answer is : HADR_DBR_SUBSCRIBER_FILTER_LIST

12. _____________ wait type applies to SQL Server 2014 only.

Correct Answer is : LCK_M_U_ABORT_BLOCKERS

13. Which of the following is a set function ?

Correct Answer is : All of the mentioned

14. Point out the correct statement :

Correct Answer is : Windowing functions were added to the standard SQL:2003

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

Correct Answer is : 2008

16. Which is the most important benefit of window function ?

Correct Answer is : Aggregation

17. Point out the wrong statement related to window function :

Correct Answer is : They are used to provide details of an aggregation

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

Correct Answer is : RANK

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

Correct Answer is : Associate window function

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

Correct Answer is : 3

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon