Oracle
1Z0-074 · Question #44
You execute this command in your database: ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL; How does this affect the creation of tablespaces?
The correct answer is B. TEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud. https://blogs.oracle.com/pshuff/database-options-advanced-security
New Features for Security
Question
You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL; How does this affect the creation of tablespaces?
Options
- AUser tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are
- BTEMP and UNDO tablespaces are transparently encrypted with AES128 by default only in the cloud.
- CTEMP and UNDO tablespaces are transparently encrypted with AES128 by default in an on-premise
- DUser tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are
- EUser tablespaces with no ENCRYPTION clause specified in the CREATE TABLESPACE statement are
How the community answered
(29 responses)- A3% (1)
- B79% (23)
- C10% (3)
- D3% (1)
- E3% (1)
Explanation
https://blogs.oracle.com/pshuff/database-options-advanced-security
Topics
#ENCRYPT_NEW_TABLESPACES#tablespace encryption#DDL setting#TEMP UNDO encryption
Community Discussion
No community discussion yet for this question.