SQL Server Interview Questions - 36 | Snaprecruit.com

SQL Server Interview Questions - 36 | Snaprecruit.com

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

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon