Oracle Database: Program with PL/SQL — Question 36

Which two statements are true about PL/SQL AOIs for SecureFiles?

Answer options

• A. DBMS_LOB can be used to compress SecureFiles columns.
• B. When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.
• C. If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.
• D. An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).

Correct answer: B, C

Explanation

Option B is correct because it specifies that encryption for SecureFiles LOB data is mandatory when using DBMS_DATAPUMP. Option C is also correct as it states that an exception will be raised if a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE. Options A and D are incorrect as they do not accurately reflect the functionalities related to SecureFiles and PL/SQL AOIs.