MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A single backup is called a backup set, and is written to a media set, which can contain up to how many backup devices
A
32
B
64
C
128
D
None of the above
Explanation: 

Detailed explanation-1: -Either a tape drive or a disk file that is provided by the operating system. A backup can be written to from 1 to 64 backup devices.

Detailed explanation-2: -A media set is an ordered collection of backup media, tapes or disk files, or Azure Blobs, to which one or more backup operations have written using a fixed type and number of backup devices.

Detailed explanation-3: -Maximum transfer size is the maximum amount of data transferred at a time during a backup operation. The default value is 2, 097, 152 bytes (or 2048 KB). You can enter any value from 65, 536 bytes (or 64 KB) to 4, 194, 304 bytes (or 4 MB). All data is transferred in multiples of 64 KB.

Detailed explanation-4: -A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. Usually, taking a backup changes the database and affects how later backups are restored.

Detailed explanation-5: -Backup Sets and Backup Pieces A backup set contains one or more binary files in an RMAN-specific format. Each of these files is known as a backup piece. A backup set can contain multiple datafiles. For example, you can back up 10 datafiles into a single backup set consisting of a single backup piece.

There is 1 question to complete.