OCP Backup & Recovery

Question 1

What is the primary purpose of Oracle RMAN (Recovery Manager)?

Accepted Answer

To perform backup and recovery tasks

Answer

To manage user access rights

Answer

To provide real-time data replication

Answer

To monitor database performance

Question 2

What is an Oracle database archive log used for?

Accepted Answer

To store changes made to the database

Answer

To store user authentication details

Answer

To track backup processes

Answer

To log SQL queries

Question 3

Which backup strategy provides the fastest recovery time?

Accepted Answer

Full backup with incremental backups

Answer

Full backup only

Answer

Incremental backup only

Answer

Differential backup only

Question 4

What does Oracle Flashback technology allow you to do?

Accepted Answer

Recover database to a specific point in time

Answer

Backup database tables

Answer

Perform real-time replication

Answer

Track SQL query performance

Question 5

What is the Oracle Data Guard feature used for?

Accepted Answer

Data protection and disaster recovery

Answer

Real-time data replication

Answer

Online backups

Answer

Managing database security

Question 6

What is the difference between a hot backup and a cold backup in Oracle?

Accepted Answer

Cold backup occurs while the database is offline

Answer

Hot backup is more secure than cold backup

Answer

Hot backup requires less storage

Answer

Cold backup involves incremental backups

Question 7

Which Oracle tool helps you restore a database to a previous point in time?

Accepted Answer

RMAN

Answer

SQL*Plus

Answer

Oracle Flashback

Answer

Oracle Enterprise Manager

Question 8

What should be included in a successful disaster recovery plan for an Oracle database?

Accepted Answer

Backup schedules, redundancy, and recovery procedures

Answer

Only backup schedules

Answer

Only offsite backups

Answer

Backup schedules and security protocols

Question 9

What is an incremental backup in Oracle?

Accepted Answer

It only backs up data modified since the last backup

Answer

It backs up all data, regardless of changes

Answer

It only backs up archived logs

Answer

It performs full database backups