Which two statements correctly describe the features of SecureFiles?

Which two statements correctly describe the features of SecureFiles? (Choose two.)

Which two statements correctly describe the features of SecureFiles? (Choose two.)

A.
Compression does not entail table or index compression and vice-versa.

B.
Encryption stores the encryption keys for the LOB columns inside the database.

C.
Encryption stores the encryption keys for the LOB columns outside the database.

D.
Compression stores identical data occurring two or more times in the same LOB column as a
single copy for the table.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


morriarti

morriarti

A, C
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.”