Quiz #1 - RMAN Database Management

Which RMAN command is used to create a duplicate of a database?

• CREATE DATABASE

• DUPLICATE TARGET DATABASE

• BACKUP DATABASE

• RESTORE DATABASE

What is the purpose of a duplicate database in RMAN?

• To replace the original database

• For reporting and testing without affecting the original

• To delete the original data

• To upgrade RMAN version

Which of the following is required before using DUPLICATE DATABASE?

• Flashback logs

• Archive logs

• Control file autobackup

• A target database connection

What RMAN feature allows restoring from another server’s backup?

• Incremental backup

• Data pump

• Duplicate without target connection

• Transport tablespace

Which view shows details of RMAN backup jobs?

• V$RMAN_STATUS

• V$BACKUP_SET

• V$RMAN_BACKUP_JOB_DETAILS

• V$SESSION_WAIT

What does the RMAN “LIST BACKUP” command show?

• Current users

• Archived redo logs

• All RMAN backup sets and pieces

• Instance memory usage

What is the use of the RMAN “SHOW ALL” command?

• Displays server parameters

• Lists obsolete backups

• Displays current RMAN configuration

• Lists database users

Which command shows backups no longer needed?

• LIST OBSOLETE

• SHOW EXPIRED

• REPORT OBSOLETE

• LIST BACKUP SUMMARY

Which RMAN feature can reduce the size of backup sets?

• Parallelism

• Checkpointing

• Backup optimization

• Compression

What RMAN feature enables simultaneous datafile backups?

• Channels

• Control files

• Logs

• Archive redo