MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The SSMS graphical user interface includes the following pages, on which you can configure backup options:Choose three.
A
General
B
Specialsed
C
Media Option
D
Medium Option
E
Backup Option
Explanation: 

Detailed explanation-1: -A backup of data in a complete database (a database backup), a partial database (a partial backup), or a set of data files or filegroups (a file backup).

Detailed explanation-2: -Microsoft SQL Server allows three basic types of SQL Server backup: Full backup. Differential backup. Transaction log backup.

Detailed explanation-3: -Microsoft SQL Server supports five types of backup: full, differential, transaction log, tail log, and copy-only backup.

There is 1 question to complete.