> > Programming Languages MCQs > Backup And Recovery MCQs

Backup And Recovery MCQ

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

Mostly

Only.

Not just.

Not

Answer

Correct Answer: Not just.

Note: This Question is unanswered, help us to find answer for this one

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

Restoration from backup tapes

Total reinstallation

Repair during continuing server operation

Answer

Correct Answer: Repair during continuing server operation

Note: This Question is unanswered, help us to find answer for this one

Select the correct SQL command for generating control file?

RECOVER DATABASE USING BACKUP CONTROL FILE

ALTER DATABASE BACKUP CONTROL FILE TO TRACE

ALTER DATABASE CONTROL FILE TO TRACE

RECOVER DATABASE USING BACKUP CONTROL FILE TO TRACE

Answer

Correct Answer: ALTER DATABASE BACKUP CONTROL FILE TO TRACE

Note: This Question is unanswered, help us to find answer for this one

Database statistics update can be run from OS level also?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

What is the meaning of RESETLOGS?

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

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

None

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

Answer

Correct Answer: RESETLOGS will initlize the logs and will generate new log sequence number

Note: This Question is unanswered, help us to find answer for this one

What is online redo log?

An Oracle database requires at least two online redo log groups

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

All

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

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

SAP backup logs can be seen from which transaction code?

DB02

DB12

DB13

DB50

Answer

Correct Answer: DB12

Note: This Question is unanswered, help us to find answer for this one

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

Brconnect

Brrecover

Brrestore

Brbackup

Answer

Correct Answer: Brbackup

Note: This Question is unanswered, help us to find answer for this one

In which mode is control file generated?

STARTUP

Mount

NO MOUNT

STARTUP RESTRICT

Answer

Correct Answer: NO MOUNT

Note: This Question is unanswered, help us to find answer for this one

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

Backint

Backnst

Brbackup

None

Answer

Correct Answer: Backint

Note: This Question is unanswered, help us to find answer for this one

SAP backup parameters are stored in which profile?

InitSID.ora

Instance profile

InitSID.pfl

InitSID.sap

Answer

Correct Answer: InitSID.sap

Note: This Question is unanswered, help us to find answer for this one

Without redo log information the online backup is worthless.

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one