MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

SQL Server backup and restore operations occur within the context of the _______ model of the database.
a. backup
b. recovery
c. restore
d. none of the mentioned
Answer: b. recoverysanfoundry
Which model controls transaction log maintenance in SQL Server?
a. Backup model
b. Restore model
c. Recovery model
d. None of the mentioned
Answer: c. Recovery modelsanfoundry
How many types of recovery models does SQL Server provide?
a. 2
b. 3
c. 4
d. 5
Answer: b. 3sanfoundry
Which recovery model does not require log backups?
a. Simple
b. Full
c. Bulk-logged
d. All of the mentioned
Answer: a. Simplesanfoundry
Which recovery model is easier to manage?
a. Simple
b. Full
c. Bulk-logged
d. All of the mentioned
Answer: a. Simplesanfoundry
Which cannot be used in simple recovery mode?
a. Media recovery without data loss
b. Log shipping
c. Database mirroring
d. All of the mentioned
Answer: d. All of the mentionedsanfoundry
Which recovery model requires log backups?
a. Simple
b. Full
c. Bulk
d. All of the mentioned
Answer: b. Fullsanfoundry
How many types of backups can be run under Full recovery model?
a. 5
b. 6
c. 7
d. All of the mentioned
Answer: b. 6sanfoundry
Which is a special-purpose recovery model working like Full recovery?
a. Simple
b. Full
c. Bulk-logged
d. None of the mentioned
Answer: c. Bulk-loggedsanfoundry
Which T-SQL statement changes the Recovery Model?
a. ALTER DATABASE
b. ALTER TABLE
c. ALTER COLUMN
d. None of the mentioned
Answer: a. ALTER DATABASEsanfoundry
Which of the following is NOT a recovery technique?
a. Deferred Update
b. Immediate Update
c. Two-Phase Commit
d. Shadow Paging
Answer: c. Two-Phase Commitsanfoundry
What does Shadow Paging ensure during database recovery?
a. Safe update
b. Transaction log growth
c. Backup rotation
d. Differential backup
Answer: a. Safe updatesanfoundry
Which technique uses system log for recovery?
a. Backward management
b. System log-based
c. Differential
d. Incremental
Answer: b. System log-basedsanfoundry
Which is used for fast database recovery?
a. Deferred update
b. Incremental restore
c. Media restore
d. Archive backup
Answer: a. Deferred updatesanfoundry
Which backup type allows recovery to a specific point in time?
a. Differential
b. Transaction log
c. Full backup
d. Copy-only
Answer: b. Transaction logwayground
What happens if the backup chain is broken?
a. Database is auto-repaired
b. Transaction logs become invalid
c. Full recovery mode is enabled
d. Database becomes read-only
Answer: b. Transaction logs become invalidwayground
What does “WITH REPLACE” do during restore?
a. Merges new data
b. Prevents overwriting
c. Overwrites the existing database
d. Backs up before restoring
Answer: c. Overwrites the existing databasewayground
Which restore option allows more log restores afterward?
a. RESTORE WITH RECOVERY
b. RESTORE WITH NORECOVERY
c. RESTORE WITH STANDBY
d. RESTORE WITH KEEP_REPLICATION
Answer: b. RESTORE WITH NORECOVERYwayground
What is the purpose of “RESTORE WITH STANDBY”?
a. Keeps database in read-only and allows further log restores
b. Restores but keeps offline
c. Merges backups
d. Enables mirroring
Answer: a. Keeps database in read-only and allows further log restoreswayground
Which backup/restore method only stores changed data since last backup?
a. Full
b. Differential
c. Incremental
d. Copy-only
Answer: b. Differentialwayground
Which backup method is fastest to restore?
a. Incremental
b. Differential
c. Full
d. Mirror
Answer: c. Fullwayground
Which restore method requires applying more than one backup file sequentially?
a. Incremental
b. Full
c. Differential
d. Copy-only
Answer: a. Incrementalwayground
What type of restore can be performed using only the last full backup and one differential backup?
a. Mirror
b. Differential
c. Incremental
d. Partial
Answer: b. Differentialwayground
In which mode are transaction logs absolutely necessary for full data recovery?
a. Simple
b. Full
c. Bulk-logged
d. Minimal recovery
Answer: b. Fullsanfoundry
The process of restoring individual files rather than the whole backup is called?
a. Full restore
b. Granular restore
c. Partial restore
d. Point-in-time restore
Answer: c. Partial restoresanfoundry
What feature allows recovery from system database failures?
a. System database restore
b. Partial restore
c. Log shipping
d. Master backup
Answer: a. System database restoresanfoundry
Which restore involves user choosing exact date & time to restore?
a. Differential
b. Copy-only
c. Point-in-time
d. Simple
Answer: c. Point-in-timewayground
Which restore method is recommended for disaster recovery from massive system failure?
a. Partial
b. Media
c. Full
d. Copy-only
Answer: c. Fullwayground
What is the initial step in restoring a corrupted server?
a. Validate backups
b. Restart the system
c. Run transaction logs
d. Apply incremental backup
Answer: a. Validate backupssanfoundry
Which method should be used after restoring a full backup to apply recent changes?
a. Copy-only backup
b. Differential restore
c. Full restore
d. Transaction log restore
Answer: d. Transaction log restoresanfoundry
Which restore method evicts least data loss but takes longest time?
a. Full
b. Differential
c. Incremental
d. Snapshot
Answer: c. Incrementalwayground
Dependent restores, requiring last full and all subsequent incrementals, refer to?
a. Differential
b. Chain restore
c. Copy backup
d. Independent restore
Answer: b. Chain restorewayground
Which command is used to change a database’s recovery model to support point-in-time restore?
a. ALTER DATABASE
b. ALTER TABLE
c. UPDATE DATABASE
d. RECOVERY MODEL
Answer: a. ALTER DATABASEsanfoundry
Backups of system state in Windows are restored using?
a. NT Backup
b. System Restore
c. System State Restore
d. Shadow paging
Answer: c. System State Restorewayground
Which restore technique uses a page table to track original and updated data locations?
a. Deferred update
b. Backup restore
c. Shadow paging
d. Transaction log restore
Answer: c. Shadow pagingsanfoundry
What restores only a single table without affecting rest of the database?
a. Partial restore
b. Table-level restore
c. Differential restore
d. Point-in-time
Answer: b. Table-level restoresql-plsql.blogspot
Copy-only backup is useful when?
a. Data is very large
b. We don’t want to disturb backup chain
c. Transaction log is unreliable
d. Point-in-time restore is needed
Answer: b. We don’t want to disturb backup chainsanfoundry
Which particular restore method is fastest but has greatest risk of data loss?
a. Full
b. Differential
c. Incremental
d. None
Answer: c. Incrementalwayground
What should always be validated after restoration?
a. Backup timestamp
b. Data consistency
c. Backup location
d. Backup performance
Answer: b. Data consistencysanfoundry
If a differential backup is lost, what’s the restore plan?
a. Use full backup and incrementals
b. Use previous differential
c. Re-run backup
d. Use only transaction logs
Answer: a. Use full backup and incrementalswayground
The process of restoring server data to a different hardware is called?
a. Point-in-time
b. Bare-metal restore
c. Partial restore
d. Mirror restore
Answer: b. Bare-metal restoresanfoundry
Which method is ideal for minimizing storage used for backup?
a. Full
b. Differential
c. Incremental
d. Synthetic full
Answer: c. Incrementalwayground
What is essential for successful full server restore?
a. Only transaction log
b. The newest log backup
c. Complete latest full backup
d. Data warehousing
Answer: c. Complete latest full backupsanfoundry
What previous requirement is necessary before log restore?
a. Latest full backup must be restored
b. Latest incremental backup must be restored
c. Both
d. None
Answer: a. Latest full backup must be restoredsanfoundry
Which restore enables database file recovery rather than whole DB?
a. File-level restore
b. Point-in-time
c. Chain restore
d. Differential
Answer: a. File-level restoresanfoundry
Which Windows feature creates periodic restore points for recovery?
a. File History
b. Shadow copy
c. System Restore
d. Backup Service
Answer: c. System Restorewayground
Which process ensures the system log records all updates for database restore purposes?
a. Deferred update
b. Logging
c. Checkpointing
d. Patch management
Answer: b. Loggingsanfoundry
Which restore operation leaves the database in a non-operational state for additional operations?
a. Restore with recovery
b. Restore with norecovery
c. Restore with standby
d. Restore with keep_replication
Answer: b. Restore with norecoverywayground
Where would you find information about past backup and restore activity?
a. Event Viewer
b. Database history tables
c. SQL Server error logs
d. All of the mentioned
Answer: d. All of the mentionedsanfoundry
A backup file that is only used for restore purposes and not included in the backup chain is called?
a. Copy-only
b. Differential
c. Incremental
d. Chainless
Answer: a. Copy-onlysanfoundry

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info