Backup And Recovery MCQs

Backup And Recovery MCQs

Answer these 10+ Backup And Recovery MCQs and see how sharp is your knowledge of Backup And Recovery.
Scroll down and let's start!

1: Without redo log information the online backup is worthless.

A.   False

B.   True

2: SAP backup parameters are stored in which profile?

A.   InitSID.ora

B.   Instance profile

C.   InitSID.pfl

D.   InitSID.sap

3: Which program is used for taking backup of SAP system when connected to the DataProtector backup tool?

A.   Backint

B.   Backnst

C.   Brbackup

D.   None

4: In which mode is control file generated?

A.   STARTUP

B.   Mount

C.   NO MOUNT

D.   STARTUP RESTRICT

5: SAP online and offline database backup can be done by using which program?

A.   Brconnect

B.   Brrecover

C.   Brrestore

D.   Brbackup

6: SAP backup logs can be seen from which transaction code?

A.   DB02

B.   DB12

C.   DB13

D.   DB50

7: What is online redo log?

A.   An Oracle database requires at least two online redo log groups

B.   Redo logs record all changes made to a database's data files

C.   All

D.   Each redo log group there is at least one online redo log member

8: What is the meaning of RESETLOGS?

A.   RESETLOGS will not initlize the logs and will generate new log sequence number

B.   RESETLOGS will initlize the logs and will generate new log sequence number

C.   None

D.   RESETLOGS will initlize the logs and will not generate new log sequence number

9: Database statistics update can be run from OS level also?

A.   False

B.   True

10: Select the correct SQL command for generating control file?

A.   RECOVER DATABASE USING BACKUP CONTROL FILE

B.   ALTER DATABASE BACKUP CONTROL FILE TO TRACE

C.   ALTER DATABASE CONTROL FILE TO TRACE

D.   RECOVER DATABASE USING BACKUP CONTROL FILE TO TRACE

11: If it can be applied, the least-damaging recovery option is ________.

A.   Restoration from backup tapes

B.   Total reinstallation

C.   Repair during continuing server operation

12: Disaster recovery is __________ an information technology (it) problem.

A.   Mostly

B.   Only.

C.   Not just.

D.   Not