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.

You may also like...

Leave a Reply

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