QUESTION 14-Hybrid Columnar Compressed (HCC)

QUESTION 14
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)
A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Correct Answer: AEG
Section: (none)
Explanation
Explanation/Reference:
Explanation:
HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance
(ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar
Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise
Edition 11.2.0.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct
NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client
overcomes many of the challenges associated with using NFS with the Oracle Database with simple
configuration, better performance than traditional NFS clients, and offers consistent configuration across
platforms.

 

问题14

您计划使用Oracle Database 12c的数据库内归档特性，并以混合列压缩( Hybrid Columnar Compressed HCC)格式存储处于非活动状态超过三个月的行。

哪三种存储方式支持HCC的使用?(选择三个)。

A.ASM磁盘组，ASM磁盘由Exadata网格磁盘组成。

B.ASM磁盘组，ASM磁盘由任意存储区域网络阵列上的lun组成

C.ASM磁盘组，ASM磁盘由任何零填充nfs挂载文件组成

D.存储在ZFS中的数据库文件，使用传统的NFS挂载访问。

E.存储在ZFS中的数据库文件，使用Oracle Direct NFS特性访问

F.存储在任何文件系统中的数据库文件，使用Oracle Direct NFS特性访问

G. ASM磁盘组，ASM磁盘由Pillar Axiom Storage阵列上的lun组成

正确答案:AEG

部分:(一)

解释

解释/参考:

解释:

HCC需要使用Oracle存储- Exadata (A)， Pillar Axiom (G)或Sun ZFS存储设备

(ZFSSA)。

注意:

*混合柱状压缩，最初只能在Exadata上使用，已经扩展到支持Pillar Axiom Storage和Sun ZFS存储设备(ZFSSA)存储与Oracle数据库企业版11.2.0.3及以上

* Oracle提供了使用一个名为Oracle Direct NFS (dNFS)的特性来管理NFS的能力。Oracle Direct NFS在Oracle数据库内核本身中实现了NFS V3协议。Oracle Direct NFS客户端通过简单的配置、比传统NFS客户端更好的性能克服了许多与在Oracle数据库中使用NFS相关的挑战，并提供了跨平台的一致配置。