Upgrade Oracle DBA 11g to Oracle Database 12c — Question 14

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

Answer options

• A. password-mode encryption
• B. dual-mode encryption
• C. transparent encryption
• D. default encryption

Correct answer: A

Explanation

The correct answer is A, as the command explicitly sets encryption using a password for all tablespaces. The other options are not applicable here since dual-mode refers to a combination of encryption methods, transparent encryption does not require a password, and default encryption does not specify a password-based method.