Flashcards: Oracle Database Fundamentals — 22 cards

Oracle Database Architecture — components?

Memory structures and background processes.

Database Instance — definition?

Set of processes and memory managing the database.

Database Schema — role?

Defines logical structure and objects owned by a user.

Relational Model — introduced by?

Dr. Edgar Codd.

Table — function?

Stores data in rows and columns.

Primary Key — purpose?

Uniquely identifies each record.

Foreign Key — role?

Establishes relationships between tables.

Tablespace — what?

Logical container grouping related objects.

Segment — composed of?

Multiple extents allocated for an object.

Extent — definition?

Continuous storage block for a segment.

Data Block — smallest unit?

Physical unit of data storage.

Multitenancy — introduced in?

Oracle 12c.

Container Database — contains?

Root and pluggable databases (PDBs).

PDB — stands for?

Pluggable Database.

User Process — role?

Client-side process executing SQL commands.

Server Process — function?

Handles requests and performs database operations.

Dedicated Server — serves?

One user process exclusively.

Shared Server — serves?

Multiple user processes with fewer server processes.

SGA — what?

Shared memory area for database data and control info.

Library Cache — stores?

Parsed SQL and PL/SQL code.

Control Files — record?

Database structure and metadata.

Redo Log Files — record?

All changes made to the database.