OCI Database Services Professional flashcards

32 cards. Read the term and the definition here. The deck at the top of this page is optional.

Autonomous Database workload types

ATP for transactions, ADW for analytics, JSON for document workloads, and APEX for low-code apps. Workload type is chosen at provisioning and cannot be changed in place.

ADB auto-scaling

Compute can scale up to three times the base OCPU or ECPU count when utilization is high, while billing remains based on the base value.

ADB Dedicated

Autonomous Database running on customer-owned Exadata infrastructure with isolation, custom maintenance schedules, and Autonomous Container Database placement control.

Base Database Service

OCI-managed database service offering Single Instance and RAC on VM, Bare Metal, and Exadata shapes, with OS access and selectable database versions.

Exadata Database Service

Engineered system combining database and storage servers with smart scan, flash cache, and storage indexes, available on dedicated infrastructure or Cloud@Customer.

Data Guard protection modes

Maximum Performance uses asynchronous redo transport, Maximum Availability uses synchronous transport, and Maximum Protection halts the primary if no standby acknowledges redo.

Transparent Data Encryption

Encrypts data at rest at the tablespace or column level. Mandatory for Autonomous Database and optional for Base Database Service, with keys managed by Oracle or OCI Vault.

ADB wallet connection

Download the client credentials zip, set TNS_ADMIN to the unzipped directory, and connect using a service name from tnsnames.ora for mutual TLS authentication.

ADB private endpoint

Associates an Autonomous Database with a subnet so clients connect over a private IP. The subnet needs a NAT or service gateway for outbound traffic.

Autonomous Data Guard

Creates a standby Autonomous Database in another region or availability domain, enabling switchover and failover for disaster recovery without manual redo apply.

Refreshable clone

A read-only Autonomous Database clone that periodically refreshes from its source, useful for reporting and test environments that need current data.

Point-in-time clone

Creates an Autonomous Database clone from a timestamp or SCN within the backup retention window, enabling recovery from logical errors without affecting the source.

Consumer groups

ADB service levels such as TPURGENT, TP, HIGH, MEDIUM, and LOW that control connection priority and parallelism for different workloads.

ECPU versus OCPU

ECPU is the current Autonomous Database compute unit; one OCPU equals two ECPU when comparing older and newer shapes.

Storage autoscaling

Automatically expands allocated storage when free space falls below a threshold. Storage grows but never shrinks automatically.

DB system lifecycle states

States include PROVISIONING, AVAILABLE, UPDATING, BACKUP_IN_PROGRESS, STOPPED, and TERMINATED. Scaling and patching require the AVAILABLE state.

Switchover versus failover

Switchover is a planned, reversible role reversal between primary and standby. Failover is unplanned and may require reinstating the old primary.

Fast-start failover

Automated Data Guard failover that requires an observer process and Maximum Availability mode, triggering when the primary becomes unreachable.

RMAN backups

Oracle Recovery Manager backups used by Base Database Service, written to Object Storage or a recovery area, with retention and recovery window settings.

OCI Database Migration

A service for homogeneous and heterogeneous migrations, using GoldenGate-based replication to keep the target in sync for minimal-downtime cutover.

Database Management service

OCI service providing fleet health, performance hub with ASH and AWR, SQL tuning, and tablespace monitoring for Base Database Service and Exadata.

Service gateway

A VCN gateway that routes traffic to OCI services such as Object Storage without traversing the internet, commonly used for database backup traffic.

NAT gateway

A VCN gateway that allows instances in a private subnet to initiate outbound internet traffic for patching while blocking inbound connections.

Network security groups

Virtual firewalls applied to individual VNICs, enabling fine-grained rules per database system rather than subnet-wide security list rules.

IAM database passwords

Credentials for Autonomous Database users managed through OCI IAM, separate from console credentials, used for application and tool connections.

Termination protection

A setting that prevents accidental deletion of a database system or Autonomous Database instance until it is explicitly disabled.

BYOL

Bring-your-own-license reduces compute cost when you already own Oracle database licenses, compared with license-included shapes that bundle the license.

Release Update

Quarterly patch bundle for Oracle Database. Release Update Revisions are lower-risk alternatives, and Monthly Recommended Patches bundle additional fixes.

CDB and PDB

Multitenant architecture with a container database hosting pluggable databases. Default in 19c and later; ADB manages the container for you.

Smart scan

Exadata feature that pushes column filtering and joins to storage servers, reducing data transfer. It requires direct-path reads and is bypassed by some operations.

Storage index

Exadata structure created automatically per storage cell to track predicate values and skip irrelevant I/O for smart scan queries.

Cloud@Customer

Exadata Database Service deployed in the customer data center, managed by the OCI control plane, satisfying data residency requirements.