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

ANSWER: D)All of the above




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

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

ANSWER: A)DB12




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

ANSWER: A)brbackup




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

ANSWER: A)initSID.sap




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

A)True
B)False
View Answer / Hide Answer

ANSWER: A)True




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

ANSWER: A)backint




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

ANSWER: A)ALTER DATABASE BACKUP CONTROL FILE TO TRACE.




8)In which mode is control file generated ?

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

ANSWER: A)NO MOUNT




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

ANSWER: A)RESETLOGS will initlize the logs and will generate new log sequence number




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

A)True
B)False
View Answer / Hide Answer

ANSWER: A)True


Post your comment