Oracle Database Instance Overview

Automatically resolves failures involving distributed transactions

RECO

Which type of process represents the code or application that queries a database in Oracle Database 12c?

User process

Copies redo log files to a designated storage device after a log switch has occurred

ARC n

Which statements describe the DBW and LGWR processes in Oracle Database 12c?

LGWR processes may write redo log entries to disk before transactions are committed DBW processes write modified data in buffers to disk

Registers information about a database instance to the Oracle Net Listener

LREG

What are features of the new multitenant container database in Oracle Database 12c?

Even if it contains multiple PDBs, it includes only a single set of background processes and one SGA In a container database, each PDB maintains its own SYSTEM tablespace Patching and upgrades done at container level are applied to all applications at the same time

What are the functions of the shared pool in Oracle Database 12c?

To save memory when multiple users run the same SQL statement To store dictionary data about a database and its structure and uses To improve query performance by caching results for frequently run queries

Oracle Database 12c uses both physical and logical database storage structures.

Data block Extent Segment Tablespace

Which statements describe the database buffer cache and the redo log buffer in Oracle Database 12c?

Entries in the redo log buffer can be used to recover changes to a database The database buffer cache stores query results to reduce the need for disk access

What are features of ASM in Oracle Database 12c?

It automatically distributes I/O load across resources It's a file system and volume manager that supports Oracle RAC configurations

Which statements describe the In-Memory column store in Oracle Database 12c?

It enables the storage of specified data in a new, columnar format, in memory only It results in faster queries and reporting

What are some of the benefits of cloud computing in Oracle Database 12c?

Simplified administration, with support for automated deployment of database configurations Consolidation of databases on fewer servers, resulting in lower hardware costs

Which process in Oracle Database 12c recovers terminated transactions if necessary when an instance starts up?

System monitor process, or SMON

Which statements about the physical and logical storage structures used in Oracle Database 12c are accurate?

Tablespaces, which are logical structures, each consist of one or more data files, which provide physical storage The default SYSTEM tablespace stores data dictionary tables and other tables that support a database's core functionality

Which key memory structure in Oracle Database 12c consists of memory components shared by all server and background processes for a particular database instance?

The SGA

In Oracle Database 12c, which SGA component frees the shared pool by handling memory requests for Oracle Recovery Manager, Oracle Shared Server, parallel processing, and I/O-related server processes?

The large pool