Practice exercise
- Which of the following are true statements about the SecureFiles?
- It requires ASSM-enabled tablespace.
- A BFILE type column in a table can be declared as SecureFiles.
- A SecureFile is not affected by the LOB index contention.
- SecureFiles use a new cache component of the buffer cache to hold the LOB data.
- Identify the incorrect statement about the compression feature in SecureFiles.
- Compression might hit performance during the LOB write operation.
- Compression of SecureFiles is a part of the advanced compression feature in Oracle.
- Possible degrees of compression can be
MEDIUM
andHIGH
. - Oracle compresses all the LOB data at high priority, if the feature has been enabled for a SecureFile.
- The compression feature can be enabled only for encrypted ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.