Which two statements are true about PL/SQL AOIs for SecureFiles?
Which two statements are true about PL/SQL AOIs for SecureFiles?
Question:
Which two statements are true about PL/SQL AOIs for SecureFiles?
Options:
DBMS_LOB can be used to compress SecureFiles columns.
When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.
If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.
An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).
Correct Answer
The Correct Answer for this Question is
When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.
If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.