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?

• 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

Comment: *

Name: *

Email: *

Verification: *

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

• A.It fails with the ORA-665610 Invalid DDL statement on history-tracked message
• B.The rows in the table are truncated without being archived.
• C.The rows in the table are archived, and then truncated.
• D.The rows in both the table and the archive are truncated.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Oracle Direct Network File System (NFS)?

• A.The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS.
• B.It utilizes the operating system file system cache.
• C.Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.
• D.Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.
• E.Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.

Comment: *

Name: *

Email: *

Verification: *

Identify three benefits of Unified Auditing.

• A.Decreased use of storage to store audit trail rows in the database.
• B.It improves overall auditing performance.
• C.It guarantees zero-loss auditing.
• D.The audit trail cannot be easily modified because it is read-only.
• E.It automatically audits Recovery Manager (RMAN) events.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the RMAN validate database command?

• A.It checks the database for intrablock corruptions.
• B.It can detect corruptpfiles.
• C.It can detect corruptspfiles.
• D.It checks the database for interblock corruptions.
• E.It can detect corrupt block change tracking files.

Comment: *

Name: *

Email: *

Verification: *