1Z0-146 · Question #52
Which two statements correctly describe the features of SecureFiles? (Choose two.)
The correct answer is A. Compression does not entail table or index compression and vice-versa. C. Encryption stores the encryption keys for the LOB columns outside the database. https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#ADLOB4444 CREATE TABLE Usage Notes for Compression "SecureFile compression does not entail table or index compression and vice-versa." https://docs.oracle.com/cd/E29505_01/network.1111/e10746/asotrans.htm…
Question
Which two statements correctly describe the features of SecureFiles? (Choose two.)
Options
- ACompression does not entail table or index compression and vice-versa.
- BEncryption stores the encryption keys for the LOB columns inside the database.
- CEncryption stores the encryption keys for the LOB columns outside the database.
- DCompression stores identical data occurring two or more times in the same LOB column as a
How the community answered
(28 responses)- A71% (20)
- B11% (3)
- D18% (5)
Explanation
https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#ADLOB4444 CREATE TABLE Usage Notes for Compression "SecureFile compression does not entail table or index compression and vice-versa." https://docs.oracle.com/cd/E29505_01/network.1111/e10746/asotrans.htm "To prevent unauthorized decryption, TDE stores the encryption keys in a security module external to the database." Feature in paragraph D is called deduplication, not compression: https://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#ADLOB4444 "The option DEDUPLICATE enables you to specify that LOB data which is identical in two or more rows in a LOB column should all share the same data blocks."
Topics
Community Discussion
No community discussion yet for this question.