MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |
| 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 | |
| 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 | |
| 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 | |
| 5. |
________ logging is not supported for memory-optimized tables. |
| A. | Full |
| B. | Minimal |
| C. | Bulk |
| D. | None of the mentioned |
| Answer» C. Bulk | |
| 6. |
ACTIVE_TRANSACTION has log_reuse_wait value : |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 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 | |
| 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 | |