Backup - SQL Server Questions and Answers

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Backup”.

1. Backing up your SQL Server database is essential for _______ your data.
a) protecting
b) preventing
c) replication
d) none of the mentioned
View Answer

Answer: a
Explanation: SQL Server offers many options for creating backups.

2. Point out the correct statement.
a) Using differential backups can save available space
b) Using full backups can save available space
c) Using partial backups can save available space
d) None of the mentioned
View Answer

Answer: a
Explanation: Using differential backups can save available space and speed up the process of making frequent backups to decrease the risk of data loss.

3. How many types of backups are provided by SQL Server?
a) 5
b) 6
c) 7
d) 8
View Answer

Answer: d
Explanation: DatabaseBackup is the SQL Server Maintenance Solution’s stored procedure for backing up databases.

4. Features provided by SQL Server backups include ________________
a) Wire compression of data for optimal backup and restore time
b) Supports full and transaction log style backups
c) Backup of MS SQL Server databases without interrupting running MS SQL Server services
d) All of the mentioned
View Answer

Answer: d
Explanation: Secure and automated backup of your company’s databases with no downtime; easy to deploy and administer.

5. Point out the wrong statement.
a) SQL Server 2003 Enterprise and later versions support compressing backups
b) SQL Server 2008 Enterprise and later versions support compressing backups
c) SQL Server 2000 Enterprise and later versions support compressing backups
d) All of the mentioned
View Answer

Answer: b
Explanation: DatabaseBackup is supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

6. Backup can occur while the database is in ___________ state.
a) Online
b) Offline
c) Restoring
d) All of the mentioned
View Answer

Answer: a
Explanation: Offline Data Cannot Be Backed Up.

7. Which of the following is not a type of backup?
a) database backup
b) data backup
c) table backup
d) all of the mentioned
View Answer

Answer: c
Explanation: In order to select a proper SQL Server backup type, a SQL Server administrator needs to understand the difference between the major backup.

8. _________ backups represent the whole database at the time the backup finished.
a) copy-only backup
b) database backup
c) data backup
d) all of the mentioned
View Answer

Answer: b
Explanation: Differential database backups contain only changes made to the database since its most recent full database backup.

9. Which of the following backups contain transaction logs?
a) copy-only backup
b) database backup
c) data backup
d) none of the mentioned
View Answer

Answer: d
Explanation: Log backup includes backup of transaction logs that includes all log records that were not backed up in a previous log backup.

10. ____________ contains data from only some of the filegroups in a database.
a) copy-only backup
b) database backup
c) data backup
d) partial
View Answer

Answer: d
Explanation: Partial backups consist of data in the primary filegroup, every read/write filegroup and any optionally-specified read-only files.

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

« Prev - SQL Server Questions and Answers – Recovery

» Next - SQL Server Questions and Answers – Database Maintenance

Related Posts:

Recommended Articles: