READ Free Dumps For Oracle- 1z0-060
Question ID 20762 | Which three are true about the large pool for an Oracle database instance that supports shared server connections?
|
Option A | Allocates memory for RMAN backup and restore operations
|
Option B | Allocates memory for shared and private SQL areas
|
Option C | Contains a cursor area for storing runtime information about cursors
|
Option D | Contains stack space
|
Option E | Contains a hash area performing hash joins of tables
|
Correct Answer | A,B,C |
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: Real 9 Oracle 1z0-060 Exam * 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 ID 20763 | What are three purposes of the RMAN "FROM" clause?
|
Option A | to support PUSH-based active database duplication
|
Option B | to support synchronization of a standby database with the primary database in a Data environment
|
Option C | To support PULL-based active database duplication
|
Option D | To support file restores over the network in a Data Guard environment
|
Option E | To support file recovery over the network in a Data Guard environment Real 10
Oracle 1z0-060 Exam
|
Correct Answer | B,D,E |
Explanation DE: * 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.