Which of the following statements about Transparent Data Encryption (TDE) is NOT true?
A.
For a partitioned table, you can have some partitions in encrypted tablespaces and some in
non- encryptedtablespaces.
B.
For a partitioned table, you can encrypt a column in some partitions and not in others.
C.
A range-based selection condition can use an index with tablespace-based Transparent Data
Encryption(TDE).
D.
An index on a value in an encrypted tablespace does not have to be encrypted.
Explanation:
ORA-28346: an encrypted column cannot serve as a partitioning column
Cause: An attempt was made to encrypt a partitioning key column or createpartitioning index with
encrypted columns.
Action: The column must be decrypted.
ORA-28347: encryption properties mismatchCause: An attempt was made to issue an ALTER TABLE EXCHANGE
PARTITION | SUBPARTITION command, but encryption properties weremismatched.
Action: Make sure encryption algorithms and columns keys are identical. Thecorresponding
columns must be encrypted on both tables with the same salt andnon-salt flavor.
You can create an index on an encrypted column if it has been encrypted without salt.
TDE tablespace encryption also allows index range scans on data in encryptedtablespaces. This
is not possible with TDE column encryption.
If you need to perform range scans over indexed, encrypted,columns, then you should use TDE
tablespace encryption in place ofTDE column encryption.
As per the below documentation, the correct answers is C
http://docs.oracle.com/cd/B28359_01/network.111/b28530/asotrans.htm#CHDCGBAJ
3.1.2.1 Restrictions on Using Transparent Data Encryption
You cannot use transparent data encryption to encrypt columns used in foreign key constraints. This is because every table has a unique column encryption key.
Transparent data encryption encrypts and decrypts data at the SQL layer. Oracle Database utilities and features that bypass the SQL layer cannot leverage the services provided by transparent data encryption. Do not use transparent data encryption with the following database features:
Index types other than B-tree
Range scan search through an index
External large objects (BFILE)
Materialized View Logs
Synchronous Change Data Capture
Transportable Tablespaces
Original import/export utilities
the answer is D
C -> Range scan search through an index
B https://community.oracle.com/message/12766131