Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

___________BACKUPS_ARE_TAKEN_IN_BULK_OR_FULL_RECOVERY_MODELS_ONLY.?$

A. Log
B. Active
C. Passive
D. Replica
Answer» B. Active
Discussion
2.

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
Answer» C. Bringing a SQL Server failover cluster instance (FCI) online
Discussion
3.

Which of the following checkpoint has ‘recovery interval’ less than zero ?#

A. Automatic
B. Direct
C. Indirect
D. All of the mentioned
Answer» B. Direct
Discussion
4.

Index page deallocation during a ________ operation is always fully logged.

A. DROP INDEX
B. CREATE INDEX
C. ALTER INDEX
D. None of the mentioned
Answer» B. CREATE INDEX
Discussion
5.

________ logging is not supported for memory-optimized tables.

A. Full
B. Minimal
C. Bulk
D. None of the mentioned
Answer» C. Bulk
Discussion
6.

ACTIVE_TRANSACTION has log_reuse_wait value :

A. 1
B. 2
C. 3
D. 4
Answer» E.
Discussion
7.

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
Answer» D. All of the mentioned
Discussion
8.

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
Answer» C. Supporting transactional replication
Discussion