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?
A.
password-mode encryption
B.
dual-mode encryption
C.
transparent encryption
D.
default encryption
A but be aware of the fact that there is an syntax error: ‘SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES;’ probably they meant: ‘SET ENCRYPTION IDENTIFIED BY ONLY FOR ALL TABLESPACES;’
ONLY => password encryption!!!
Correct syntax is: ‘SET ENCRYPTION IDENTIFIED BY password ONLY ON FOR ALL TABLESPACES;’
B
I think that syntax is correct:
The following example sets the encryption password for all tablespaces (where password is a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dual-mode encryption:
SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;