COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The BACKUP DATABASE statement is used in SQL Server to create a full back up of an existing SQL database.
Detailed explanation-2: -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-3: -Explanation: Offline Data Cannot Be Backed Up. 7. Which of the following is not a type of backup? Explanation: In order to select a proper SQL Server backup type, a SQL Server administrator needs to understand the difference between the major backup.
Detailed explanation-4: -The backup operation copies the data in the database to the backup file. The backup contains only the actual data in the database and not any unused space. Therefore, the backup is usually smaller than the database itself.