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
