SQL Server Interview Questions - 36 | Snaprecruit.com
SQL Server Interview Questions - 36 | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
SQL Server interview questions part 36
SQL Server interview questions part 36
Back
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 ?
A. LAG
B. LEAD
C. FIRST_VALUE
D. None of the mentioned
Show Correct Answer
Correct Answer is :
LEAD
2. LAST_VALUE comes in the category of :
A. Ranking window function
B. Associate window function
C. Analytic window functions
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Analytic window functions
3. The transaction log supports the following operations :
A. Recovery of all incomplete transactions when SQL Server is started
B. Recovery of individual transactions
C. Supporting transactional replication
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Recovery of individual transactions
4. Point out the correct statement :
A. The Database Engine supports two types of checkpoints
B. Long-running uncommitted transactions decrease recovery time for all types of checkpoints
C. Log truncation deletes inactive virtual log files from the logical transaction log of a SQL Server database
D. All of the mentioned
Show Correct Answer
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 ?
A. CHECKPOINT
B. ACTIVE_TRANSACTION
C. NOTHING
D. All of the mentioned
Show Correct Answer
Correct Answer is :
NOTHING
6. ACTIVE_TRANSACTION has log_reuse_wait value :
A. 1
B. 2
C. 3
D. 4
Show Correct Answer
Correct Answer is :
4
7. Point out the wrong statement :
A. For performance reasons, the Database Engine performs modifications to database pages in memory
B. Log truncation does reduce the size of the physical log file
C. Log truncation is essential to keep the log from filling
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Log truncation does reduce the size of the physical log file
8. ________ logging is not supported for memory-optimized tables.
A. Full
B. Minimal
C. Bulk
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Minimal
9. Index page deallocation during a ________ operation is always fully logged.
A. DROP INDEX
B. CREATE INDEX
C. ALTER INDEX
D. None of the mentioned
Show Correct Answer
Correct Answer is :
DROP INDEX
10. Which of the following checkpoint has ‘recovery interval’ less than zero ?
A. Automatic
B. Direct
C. Indirect
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Automatic
11. Internal checkpoint are generated in response to the following event :
A. A database snapshot is deleted, whether explicitly or internally for DBCC CHECK
B. Bringing a SQL Server failover cluster instance (FCI) offline
C. Bringing a SQL Server failover cluster instance (FCI) online
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Bringing a SQL Server failover cluster instance (FCI) offline
12. __________ backups are taken in bulk or full recovery models only.
A. Log
B. Active
C. Passive
D. Replica
Show Correct Answer
Correct Answer is :
Log
Similar Interview Questions
Search for latest jobs
Find Jobs