Done. Oracle Database 12c Components and Architecture

These flashcards cover essential vocabulary and concepts related to Oracle Database 12c architecture and components, providing key terms and their definitions to help students prepare for their exam.

Oracle Database 12c

A powerful database that meets performance, availability, recoverability, multitenancy, cloud-enabled, application-testing, and security requirements.

OCA Exam Objectives

A set of guidelines and topics designed to help in preparation for the Oracle Database 12c Installation and Administration certification exam.

DBMS (Database Management System)

Software that facilitates the storage, modification, and retrieval of data.

Relational Database Management System (RDBMS)

A type of database management system that is based on the relational model and allows data independence.

Primary Key

A column or set of columns that uniquely identifies a row in a table.

Foreign Key

A column in one table that provides a link to another table by referencing its primary key.

Tablespace

A logical storage structure within a database that consists of one or more data files.

Pluggable Database (PDB)

A database within a Container Database that shares the container's resources and can be managed independently.

Memory Structures

Components of the Oracle instance that allocate memory for database processes and user interactions.

Process Structures

Background processes in Oracle that manage tasks like writing to databases and maintaining user connections.

Instance

The combination of Oracle's memory structures and background processes that manage database operations.

Control File

A crucial database file that contains metadata about the database, data files, and redo logs.

Redo Log File

Files that record all changes made to the database, allowing recovery in case of failure.

Shared Pool

An area of the SGA that caches SQL statements, PL/SQL procedures, and data dictionary information.

Database Writer (DBWn)

A background process that writes modified data from the database buffer cache to data files.

Log Writer (LGWR)

A background process that writes the redo log buffer to the online redo log files on disk.

Checkpoint (CKPT)

A process that updates data file headers and synchronize various database files for recovery.

Server Process

A process that handles the user's request and interacts with the database.

User Process

A process initiated by a user that connects to the Oracle database instance.

System Global Area (SGA)

A shared memory area in an Oracle instance that contains data and control information for the database.

Program Global Area (PGA)

Memory dedicated to a single server process, holding session-specific data for that process.

Automatic Memory Management (AMM)

Feature that allows Oracle to manage memory dynamically across SGA and PGA components.

Archiving

The process of copying redo log entries to a secondary location to prevent data loss.

Database Links

A method of connecting and sharing data between different Oracle databases.

Oracle Enterprise Manager

A GUI-based tool used for database administration and performance management.