Chapter 7, Using SecureFile LOBs
Question No. |
Answer |
Explanation |
---|---|---|
1 |
a, c, and d |
SecureFiles can reside only on ASSM tablespaces. They are free from LOB index contention and high water mark contention. Up to 4 MB, SecureFile LOB data can be cached under the WGC component of the buffer cache. |
2 |
a and d |
Being part of the advanced compression, compression in SecureFile doesn't affect performance. It is intelligently handled by the LOB manager to perceive the impact of compression on LOB data. |
3 |
b |
Compression, deduplication, and encryption are mutually exclusive features of a SecureFile. |
4 |
b |
Table compression has nothing to do with SecureFile compression. |
5 |
a and b |
|
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.