Backup and recovery - SAP Basis questions

Backup and recovery - SAP Basis questions

1)What is online redo log ?

A)Redo logs record all changes made to a database's data files
B)An Oracle database requires at least two online redo log groups
C)Each redo log group there is at least one online redo log member
D)All of the above
View Answer / Hide Answer


2)SAP backup logs can be seen from which transaction code?

A)DB12
B)DB02
C)DB13
D)DB50
View Answer / Hide Answer


3)SAP online and offline database backup can be done by using which program ?

A)brbackup
B)brconnect
C)brrecover
D)brrestore
View Answer / Hide Answer


4)SAP backup parameters are stored in which profile ?

A)initSID.sap
B)initSID.ora
C)initSID.pfl
D)Instance profile
View Answer / Hide Answer


5)Database statistics update can be run from OS level also ?

A)True
B)False
View Answer / Hide Answer


6)Which program is used for taking backup of SAP system when connected to DataProtector backup tool ?

A)backint
B)backnst
C)brbackup
D)None of the above
View Answer / Hide Answer


7)Select the correct SQL command for generating control file ?

A)ALTER DATABASE BACKUP CONTROL FILE TO TRACE.
B)ALTER DATABASE CONTROL FILE TO TRACE
C)RECOVER DATABASE USING BACKUP CONTROL FILE TO TRACE
D)RECOVER DATABASE USING BACKUP CONTROL FILE
View Answer / Hide Answer


8)In which mode is control file generated ?

A)NO MOUNT
B)MOUNT
C)STARTUP RESTRICT
D)STARTUP
View Answer / Hide Answer


9)What is the meaning of RESETLOGS ?

A)RESETLOGS will initlize the logs and will generate new log sequence number
B)RESETLOGS will not initlize the logs and will generate new log sequence number
C)RESETLOGS will initlize the logs and will not generate new log sequence number
D)None of the above
View Answer / Hide Answer


10)Without redo log information the online backup is worthless.

A)True
B)False
View Answer / Hide Answer