SQL Server interview questions part 36
SQL Server interview questions part 36
Take as many assements as you can to improve your validate your skill rating
Total Questions: 12
1. Which of the following function is a analytic window function ?
Correct Answer is : LEAD
2. LAST_VALUE comes in the category of :
Correct Answer is : Analytic window functions
3. The transaction log supports the following operations :
Correct Answer is : Recovery of individual transactions
4. Point out the correct statement :
Correct Answer is : Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database
5. Which of the log_reuse_wait_desc value has log_reuse_wait value 0 ?
Correct Answer is : NOTHING
6. ACTIVE_TRANSACTION has log_reuse_wait value :
Correct Answer is : 4
7. Point out the wrong statement :
Correct Answer is : Log truncation does reduce the size of the physical log file
8. ________ logging is not supported for memory-optimized tables.
Correct Answer is : Minimal
9. Index page deallocation during a ________ operation is always fully logged.
Correct Answer is : DROP INDEX
10. Which of the following checkpoint has ‘recovery interval’ less than zero ?
Correct Answer is : Automatic
11. Internal checkpoint are generated in response to the following event :
Correct Answer is : Bringing a SQL Server failover cluster instance (FCI) offline
12. __________ backups are taken in bulk or full recovery models only.
Correct Answer is : Log
