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.
Encryption keys for columns are stored inside the database. Only master encryption key is stored outside the database in Oracle Wallet.
So answer is: A and B.
According to:
http://docs.oracle.com/cd/B28359_01/network.111/b28530/asotrans.htm#BABHFIJA
When a table contains encrypted columns, a single key is used regardless of the number of encrypted columns. This key is called the column encryption key. The column encryption keys for all tables, containing encrypted columns, are encrypted with the database server master encryption key and stored in a dictionary table in the database. No keys are stored in the clear.
As shown in Figure 3-1, the master encryption key is stored in an external security module that is outside the database and accessible only to the security administrator. For this external security module, Oracle uses an Oracle wallet as described in this chapter. Storing the master encryption key in this way prevents its unauthorized use.
A, B
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABBJGBA
http://docs.oracle.com/cd/B28359_01/network.111/b28530/asotrans.htm#BABHFIJA
why B)? your second link informs: ” master encryption key is stored in an external security module that is OUTSIDE the database and accessible only to the security administrator.”
B) is incorrect, what if the user use the master encryption key to encrypt the secureFiles?