Oracle Database 12c Exam Study Guide

These flashcards cover essential vocabulary and concepts related to Oracle Database 12c, aiding in preparation for the certification exam.

Oracle tools

Various applications used to connect to and manage an Oracle database.

Multitenancy database

A database that includes one or more pluggable databases, known as a container database.

DBWn

Database Writer process that writes modified data blocks from the database buffer cache to the data files.

ARCn

Archiver process that takes a copy of the online redo log files to a specified archive location.

Control files

Files that store metadata about the database, including the database structure and status.

SPA (Shared Pool Area)

Memory structure within SGA that caches SQL statements and execution plans.

Memory Management

Automatic Memory Management (AMM) allows DBA to control memory allocation without tuning individual components.

SQL Tuning Advisor

Oracle tool that analyzes SQL statements and recommends optimizations.

SQL Access Advisor

An Oracle tool providing advice on indexes, materialized views, and other objects to improve SQL performance.

Redo log files

Files that record all changes made to the database, ensuring data recovery.

AWR (Automatic Workload Repository)

A repository for database performance statistics and workload monitoring.

Data Pump

An Oracle utility for high-speed data and metadata transfer between databases.

External tables

Tables that allow access to data stored in external files without loading it into the database.

Automatic Memory Management (AMM)

A parameter controlling total instance memory allocation, including PGAs and SGAs.

Database Configuration Assistant (DBCA)

A tool for creating, configuring, and managing Oracle databases.

Instance Recovery

The process of restoring a database to a consistent state after an instance failure.

Manageability Monitor (MMON)

Background process responsible for gathering performance statistics for AWR.

Parameter Files

Files that initialize and configure the Oracle database's operational environment.

Unified Auditing

A simplified auditing model that consolidates auditing actions into unified records.

Control File

A crucial file that contains information about the database structure, including data file locations and checkpoints.

PGA

Program Global Area, a memory region that contains data and control information for a single Oracle process.

instance

The Oracle software running on a server, consisting of the memory structures and processes.

Database

The set of physical files or data organized in a specific manner to store information.

Flashback Database

A feature that allows restoring a database to a past state without needing to restore from backups.

Rollback segment

Used for maintaining data consistency by reversing transactions.

RAC (Real Application Cluster)

Oracle technology that allows multiple databases to operate as if they are a single database.

Listeners

Processes running on the Oracle server that handle incoming client connection requests.

Temporary Tablespace

Dedicated tablespace used for storing temporary data.

TNS (Transparent Network Substrate)

Networking protocol for Oracle databases to allow communication between database clients and servers.

ASM (Automatic Storage Management)

An Oracle database feature to simplify database storage management.

RMAN (Recovery Manager)

Oracle's data backup and recovery management tool.

Checkpoint

A database mechanism that ensures data consistency by writing all modified data to disk.

Transportable Tablespaces

Method to move tablespaces between different Oracle databases quickly.

Oracle Universal Installer (OUI)

Tool used to install Oracle products on a server.

Database Directory Objects

Objects that define a path for Data Pump operations.

SQL*Loader

A bulk data loading utility for loading data from external files into Oracle database tables.