Free Download 1z0-060 Examp Dump: Oracle.1z0-060.ExamsKey.2019-08-29.116q.tqb

File Info

Exam	Upgrade to Oracle Database 12c
Number	1z0-060
File Name	Oracle.1z0-060.ExamsKey.2019-08-29.116q.tqb
Size	2 MB
Posted	Aug 29, 2019
Download	Oracle.1z0-060.ExamsKey.2019-08-29.116q.tqb

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%

Demo Questions

Question 1

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables

Correct answer: ABC

Explanation:

The large pool can provide large memory allocations for the following:/ (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves Note:* large pool Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA. * Oracle XA An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database. * UGA User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool. * Configuring the Large Pool Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:* Shared server In a shared server architecture, the session memory for each client process is included in the shared pool. * Parallel query Parallel query uses shared pool memory to cache parallel execution message buffers. * Recovery Manager Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.

The large pool can provide large memory allocations for the following:

/ (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)

/Message buffers used in the parallel execution of statements

/ (A) Buffers for Recovery Manager (RMAN) I/O slaves

Note:

* large pool

Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.

* Oracle XA

An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.

* UGA

User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.

* Configuring the Large Pool

Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:

* Shared server

In a shared server architecture, the session memory for each client process is included in the shared pool.

* Parallel query

Parallel query uses shared pool memory to cache parallel execution message buffers.

* Recovery Manager

Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.

Question 2

What are three purposes of the RMAN “FROM” clause?

to support PUSH-based active database duplication
to support synchronization of a standby database with the primary database in a Data environment
to support PULL-based active database duplication
to support file restores over the network in a Data Guard environment
to support file recovery over the network in a Data Guard environment

Correct answer: BDE

Explanation:

* With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible. * RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.

* With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.

* RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.

Question 3

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.)

ASM disk groups with ASM disks consisting of Exadata Grid Disks.
ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
Database files stored in ZFS and accessed using conventional NFS mounts.
Database files stored in ZFS and accessed using the Oracle Direct NFS feature
Database files stored in any file system and accessed using the Oracle Direct NFS feature
ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Correct answer: AEG

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.

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.