I85PREP
⌘ K
OCI Database Services Professional study materials
OCI Database Services Professional study resources

OCI Database Services Professional practice questions

One question at a time. Build your OCI Database Services Professional understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Oracle Cloud Infrastructure Database Services

Which OCI Database Services offering is a fully managed, autonomous Oracle Database that automatically patches, tunes, and scales without downtime?

  1. Exadata Database Service on Dedicated Infrastructure
  2. Database Cloud Service on bare metal
  3. Autonomous Database Correct answer.
  4. Base Database Service on a VM cluster

Explanation

Autonomous Database is the self-driving, self-securing, self-repairing managed service that applies patches and performs tuning automatically. The other offerings require the customer to schedule patching and much of the tuning work.

Question 2Oracle Cloud Infrastructure Database Services

A team wants the lowest-cost way to run a small Oracle Database workload in OCI with no OS access. Which service best fits?

  1. Exadata Database Service on Dedicated Infrastructure
  2. Oracle Database@Azure
  3. Autonomous Database on a shared Exadata infrastructure Correct answer.
  4. Database Cloud Service on bare metal

Explanation

Autonomous Database runs on shared Exadata infrastructure with consumption-based ECPU or OCPU billing, which suits small workloads and removes OS administration. Dedicated Exadata and bare metal options carry minimum capacity commitments and host management overhead.

Question 3Oracle Cloud Infrastructure Database Services

Which OCI Database service provides a fully managed Oracle Database that runs on dedicated Exadata hardware while OCI handles infrastructure patching?

  1. Exadata Database Service on Dedicated Infrastructure Correct answer.
  2. Autonomous Database on shared infrastructure
  3. Database Cloud Service on a single VM
  4. Base Database Service

Explanation

Exadata Database Service on Dedicated Infrastructure delivers Exadata hardware dedicated to a single tenancy, with OCI managing the physical infrastructure layer. Customers still control database-level patching and tuning, unlike Autonomous Database.

Question 4Oracle Cloud Infrastructure Database Services

Which OCI Database service lets a customer run Oracle Database on a virtual machine with full SYSDBA control while OCI manages the underlying host?

  1. Base Database Service Correct answer.
  2. Exadata Database Service on Cloud@Customer
  3. Autonomous Database
  4. OCI Full Stack Disaster Recovery

Explanation

Base Database Service provisions an Oracle Database on a VM or bare metal shape and gives the customer administrative control of the database while OCI maintains the host. Autonomous Database removes that control, and Cloud@Customer runs in the customer's data center.

Question 5Oracle Cloud Infrastructure Database Services

Which Oracle Database@Azure architecture underlies the service?

  1. Oracle Database running in a customer-managed Azure Kubernetes cluster
  2. Exadata infrastructure co-located in Azure data centers and managed by OCI Correct answer.
  3. Oracle Database on Azure SQL Managed Instance
  4. Autonomous Database running on Azure virtual machines

Explanation

Oracle Database@Azure runs OCI-managed Exadata infrastructure inside Azure data centers, giving low latency to Azure applications. It is not a repackaged Autonomous Database on Azure VMs nor an Azure SQL product.

Question 6Oracle Cloud Infrastructure Database Services

An organization must keep Oracle Database data in its own data center but wants Exadata automation and OCI management. Which service meets this requirement?

  1. Base Database Service
  2. Exadata Database Service on Dedicated Infrastructure
  3. Exadata Database Service on Cloud@Customer Correct answer.
  4. Autonomous Database on shared infrastructure

Explanation

Cloud@Customer places Exadata hardware in the customer's data center while OCI manages the control plane, satisfying data residency requirements. The other options run in OCI regions and would move data off premises.

Question 7Oracle Cloud Infrastructure Database Services

Which feature of Autonomous Database automatically creates and manages indexes and statistics based on workload analysis?

  1. Automatic Data Optimization
  2. Automatic indexing Correct answer.
  3. Automatic Workload Repository
  4. Automatic Storage Management

Explanation

Automatic indexing in Autonomous Database detects missing indexes and validates them against the real workload before making them usable. ADO handles data tiering, ASM handles storage, and AWR stores performance snapshots.

Question 8Oracle Cloud Infrastructure Database Services

A workload on Autonomous Database experiences intermittent spikes and the team wants the database to add compute resources automatically. Which setting should they enable?

  1. Automatic Data Optimization
  2. Automatic backup
  3. Auto scaling Correct answer.
  4. Real Application Testing

Explanation

Auto scaling lets Autonomous Database temporarily use up to three times the base ECPU or OCPU count during demand spikes and reverts when demand falls. Backups, ADO, and Real Application Testing do not adjust compute capacity.

Question 9Oracle Cloud Infrastructure Database Services

Which Autonomous Database workload type is optimized for transactional, mixed, and reporting workloads on row-store tables?

  1. Transaction Processing Correct answer.
  2. JSON Database
  3. Data Warehouse
  4. APEX Application Development

Explanation

The Transaction Processing workload type is tuned for OLTP and mixed workloads using row format and automatic indexing. Data Warehouse uses columnar storage, while JSON and APEX options target specialized use cases.

Question 10Oracle Cloud Infrastructure Database Services

Which OCI Database service is best suited for running a large data warehouse with automatic columnar caching and no manual index tuning?

  1. Autonomous Data Warehouse Correct answer.
  2. Exadata Database Service on Dedicated Infrastructure
  3. Base Database Service
  4. Oracle Database@Google Cloud

Explanation

Autonomous Data Warehouse uses columnar storage, automatic partitioning, and automatic statistics suited to analytics. The other services can run a warehouse but require manual tuning and design.

Question 11Oracle Cloud Infrastructure Database Services

Which Oracle Database@Google Cloud deployment model is offered by the service?

  1. Oracle Database on Cloud SQL
  2. Oracle Database on Google Kubernetes Engine
  3. Exadata Database Service and Autonomous Database running on OCI-managed infrastructure in Google Cloud regions Correct answer.
  4. Oracle Database on Google Compute Engine VMs

Explanation

Oracle Database@Google Cloud runs OCI-managed Exadata and Autonomous Database inside Google Cloud regions, giving low latency to Google Cloud applications. It is not a self-managed deployment on Google VMs, GKE, or Cloud SQL.

Question 12Oracle Cloud Infrastructure Database Services

A customer needs to run Oracle Real Application Clusters (RAC) in OCI. Which service supports RAC?

  1. Oracle Database@Azure with Autonomous Database
  2. Base Database Service on a single VM
  3. Exadata Database Service on Dedicated Infrastructure Correct answer.
  4. Autonomous Database on shared infrastructure

Explanation

Exadata Database Service on Dedicated Infrastructure supports RAC across database nodes on the Exadata platform. Shared Autonomous Database and single-VM Base Database Service do not expose RAC configuration.

Question 13Oracle Cloud Infrastructure Database Services

Which OCI Database Service feature provides a read-only, point-in-time copy of a database for reporting without impacting production?

  1. Automatic Data Optimization
  2. Transparent Data Encryption
  3. Active Data Guard Correct answer.
  4. Database Vault

Explanation

Active Data Guard maintains a synchronized standby that can be opened read-only for reporting, offloading queries from the primary. ADO handles storage tiering, Database Vault restricts privileged access, and TDE encrypts data at rest.

Question 14Oracle Cloud Infrastructure Database Services

Which tool is used to move an on-premises Oracle Database into OCI Database Services with minimal downtime?

  1. Zero Downtime Migration (ZDM) Correct answer.
  2. Oracle Enterprise Manager Cloud Control
  3. Oracle Data Pump only
  4. SQL Developer

Explanation

ZDM orchestrates migration to OCI Database Services using Data Guard, GoldenGate, or Data Pump with automated workflows and rollback. Enterprise Manager, SQL Developer, and Data Pump alone do not provide the end-to-end migration orchestration.

Question 15Oracle Cloud Infrastructure Database Services

Which OCI Database service is the primary target for migrating a legacy Oracle Database with minimal application changes?

  1. Autonomous Database with a JSON workload
  2. OCI Functions with an embedded database
  3. Oracle Database@Azure with Autonomous Database
  4. Base Database Service Correct answer.

Explanation

Base Database Service provides a familiar Oracle Database environment with full administrative control, so legacy applications migrate with minimal change. Autonomous Database may require application compatibility review, and the other options are not general-purpose database targets.

Question 16Oracle Cloud Infrastructure Database Services

Which OCI feature automates failover of an Oracle Database to a standby region during a regional outage?

  1. Oracle Connection Manager
  2. Automatic Data Optimization
  3. Automatic Workload Repository
  4. Data Guard with Fast-Start Failover Correct answer.

Explanation

Data Guard with Fast-Start Failover uses an observer to detect failure and automatically promotes the standby. ADO, AWR, and Connection Manager do not perform failover automation.

Question 17Oracle Cloud Infrastructure Database Services

A team wants Autonomous Database backups retained for 60 days. Which action is required?

  1. Configure a backup retention policy on the Autonomous Database Correct answer.
  2. Enable auto scaling
  3. Enable Automatic Data Optimization
  4. Create a manual backup every day

Explanation

Autonomous Database supports configuring a backup retention period, and backups are managed automatically within that window. Auto scaling and ADO are unrelated, and manual backups are unnecessary for retention.

Question 18Oracle Cloud Infrastructure Database Services

Which OCI Database Service capability provides a full backup of an Autonomous Database to Object Storage automatically?

  1. Database Vault
  2. Oracle Data Guard
  3. Real Application Testing
  4. Automatic backups managed by the service Correct answer.

Explanation

Autonomous Database automatically takes backups and stores them in OCI Object Storage according to the retention policy. Real Application Testing, Data Guard, and Database Vault serve different purposes.

Question 19Oracle Cloud Infrastructure Database Services

Which OCI Database Service option is designed to isolate a customer's database on dedicated Exadata hardware inside an OCI region?

  1. Base Database Service on a VM
  2. Autonomous Database on shared infrastructure
  3. Oracle Database@Azure with Autonomous Database
  4. Exadata Database Service on Dedicated Infrastructure Correct answer.

Explanation

Dedicated Infrastructure assigns Exadata hardware to a single tenancy within an OCI region. Shared Autonomous Database, Base Database Service, and Autonomous Database on Azure do not provide dedicated Exadata hardware in an OCI region.

Question 20Oracle Cloud Infrastructure Database Services

Which OCI Database Service feature lets a customer clone a running Autonomous Database for testing without copying data physically?

  1. Fast clone Correct answer.
  2. Full clone
  3. Remote clone
  4. Data Pump export

Explanation

Fast clone creates a copy that shares storage with the source until changes occur, making it quick and space-efficient. Full clone copies data, Data Pump exports to files, and remote clone copies across databases.

Question 21Oracle Cloud Infrastructure Database Services

Which OCI Database Service supports a customer-managed key stored in OCI Vault for Transparent Data Encryption?

  1. Base Database Service only
  2. Exadata Database Service on Dedicated Infrastructure Correct answer.
  3. Oracle Database@Azure with Autonomous Database
  4. Autonomous Database on shared infrastructure

Explanation

Exadata Database Service on Dedicated Infrastructure supports customer-managed TDE keys held in OCI Vault. Shared Autonomous Database manages keys internally, and the other options do not expose the same key management control.

Question 22Oracle Cloud Infrastructure Database Services

Which OCI Database Service option is appropriate when an application requires low-latency access from Azure while keeping the database managed by OCI?

  1. Oracle Database@Azure Correct answer.
  2. Base Database Service in an OCI region
  3. Autonomous Database in an OCI region
  4. Exadata Database Service on Cloud@Customer

Explanation

Oracle Database@Azure places OCI-managed Exadata in Azure data centers, minimizing latency to Azure applications. The other options host the database in OCI regions or on-premises.

Question 23Oracle Cloud Infrastructure Database Services

Which OCI Database Service feature provides automatic partition creation and maintenance for analytics tables?

  1. Automatic Workload Repository
  2. Automatic partitioning in Autonomous Data Warehouse Correct answer.
  3. Automatic Storage Management
  4. Automatic Data Optimization

Explanation

Autonomous Data Warehouse automatically partitions tables and maintains partitions as data grows. ADO handles storage tiering, AWR collects statistics, and ASM manages disk groups.

Question 24Oracle Cloud Infrastructure Database Services

Which OCI Database Service offers a managed Oracle Database with a choice of Oracle Database versions and patch levels?

  1. Autonomous Data Warehouse
  2. Base Database Service Correct answer.
  3. Oracle Database@Azure with Autonomous Database
  4. Autonomous Database on shared infrastructure

Explanation

Base Database Service lets customers choose the database version and apply patches on their own schedule. Autonomous Database options standardize on managed versions and patch automatically.

Question 25Oracle Cloud Infrastructure Database Services

Which OCI Database Service capability helps meet data residency requirements by keeping the database in a specific country while still being OCI-managed?

  1. Base Database Service in any OCI region
  2. Exadata Database Service on Cloud@Customer Correct answer.
  3. Oracle Database@Azure with Autonomous Database
  4. Autonomous Database on shared infrastructure

Explanation

Cloud@Customer runs Exadata hardware in the customer's own data center, which keeps data within the required jurisdiction. Shared and region-based services host data in OCI regions, and Oracle Database@Azure hosts in Azure.

Question 26Oracle Cloud Infrastructure Database Services

Which OCI Database service offers a fully managed Oracle Database with a choice of Autonomous Database workload types, automatic scaling, and no operating system access for the customer?

  1. Autonomous Database Correct answer.
  2. Oracle Database@Azure
  3. Exadata Database Service on Dedicated Infrastructure
  4. Base Database Service

Explanation

Autonomous Database is the fully managed offering where OCI handles provisioning, patching, tuning, and scaling, and the customer has no OS or root access. Workload types such as Transaction Processing and Data Warehouse are selected at creation time.

Question 27Oracle Cloud Infrastructure Database Services

A database administrator wants to connect to an Autonomous Database using a client tool rather than a web interface. Which credential or file is required for a direct SQL*Net connection?

  1. An SSH private key registered with the database node
  2. A Kerberos keytab issued by the OCI identity domain
  3. A TLS client certificate issued by the customer's own CA
  4. A wallet file plus the database connection string Correct answer.

Explanation

Autonomous Database accepts only secure SQL*Net connections, so the client needs the downloaded wallet (containing the trusted certificates and connection descriptors) and a connection string from that wallet. Mutual TLS with the service-managed wallet is the standard path.

Question 28Oracle Cloud Infrastructure Database Services

Which OCI Database service is the managed Exadata offering where the customer's databases run in a dedicated Exadata infrastructure within a compartment they control?

  1. Autonomous Database on Shared Infrastructure
  2. Exadata Database Service on Dedicated Infrastructure Correct answer.
  3. HeatWave MySQL
  4. Base Database Service

Explanation

Exadata Database Service on Dedicated Infrastructure gives the customer a dedicated Exadata cloud infrastructure, with control over the Exadata system, VM clusters, and databases. It is the choice when full Exadata capability plus administrative control is needed.

Question 29Oracle Cloud Infrastructure Database Services

Which OCI Database service is designed for a single-node or two-node Oracle Database deployment on a VM or bare metal shape without Exadata infrastructure?

  1. Autonomous Database
  2. Oracle Database@Azure
  3. Base Database Service Correct answer.
  4. Exadata Database Service on Dedicated Infrastructure

Explanation

Base Database Service provisions Oracle Database on VM or bare metal compute shapes and supports single-instance and two-node RAC configurations. It is the general-purpose IaaS-style managed database option.

Question 30Oracle Cloud Infrastructure Database Services

Which OCI Database service is the managed offering for MySQL-compatible applications that need analytics acceleration without a separate analytical store?

  1. HeatWave MySQL Correct answer.
  2. Exadata Database Service
  3. Base Database Service
  4. Autonomous Database

Explanation

HeatWave MySQL is the managed MySQL Database service with an integrated in-memory analytics engine, so OLTP and analytics can run against the same data. It is MySQL-compatible rather than Oracle Database-compatible.

Question 31Oracle Cloud Infrastructure Database Services

Which OCI Database service provides a fully managed, serverless Oracle Database with automatic indexing, automatic statistics gathering, and no infrastructure sizing by the customer?

  1. Base Database Service
  2. Oracle Database@Google Cloud
  3. Autonomous Database Correct answer.
  4. Exadata Database Service on Dedicated Infrastructure

Explanation

Autonomous Database is serverless and applies automated tuning features such as automatic indexing and statistics gathering without customer sizing of compute or storage. The customer selects a workload type and base compute rather than provisioning hosts.

Question 32Oracle Cloud Infrastructure Database Services

What is the primary purpose of the OCI Database Migration service?

  1. To archive cold database backups to Object Storage
  2. To convert non-Oracle schemas into Autonomous Database automatically
  3. To replicate block volumes between availability domains
  4. To migrate Oracle and other supported databases into OCI Database services with minimal downtime Correct answer.

Explanation

Database Migration orchestrates the movement of on-premises or cloud databases into OCI targets, using techniques such as Data Pump and continuous replication to reduce cutover downtime. It supports Oracle sources and several non-Oracle sources into supported targets.

Question 33Oracle Cloud Infrastructure Database Services

Which OCI Database service capability lets a customer create a point-in-time copy of a database for development or testing without impacting the source database?

  1. Database patching
  2. Database scaling
  3. Database migration
  4. Database cloning Correct answer.

Explanation

Cloning creates a copy of a database at a chosen point in time, which can be used for development, testing, or reporting without affecting the production source. It is available across the OCI Database services.

Question 34Oracle Cloud Infrastructure Database Services

An application team needs a read-only copy of a production Autonomous Database that reflects changes continuously and does not consume the production database's compute. Which capability should they use?

  1. A refreshable clone of the production database Correct answer.
  2. A full export to Object Storage
  3. A Data Guard standby in the same region
  4. A manual backup restored to a new database

Explanation

A refreshable clone is a read-only copy that periodically refreshes from the source, so reporting reads do not consume production compute. The refresh interval is configurable and the clone can be detached if needed.

Question 35Oracle Cloud Infrastructure Database Services

A customer needs to isolate an Autonomous Database on dedicated Exadata infrastructure inside a virtual cloud network they control. Which deployment option meets this requirement?

  1. Autonomous Database on Dedicated Infrastructure Correct answer.
  2. HeatWave MySQL
  3. Base Database Service
  4. Autonomous Database on Shared Infrastructure

Explanation

Autonomous Database on Dedicated Infrastructure places the database on Exadata infrastructure dedicated to the customer and inside a customer VCN, giving network isolation and dedicated resources. Shared Infrastructure is multi-tenant and does not provide that isolation.

Question 36Oracle Cloud Infrastructure Database Services

A team needs an Autonomous Database backup retained for 90 days, beyond the default retention. Which action is required?

  1. Create a long-term backup with a specified retention period Correct answer.
  2. Increase the automatic backup interval
  3. Enable cross-region backup copy
  4. Enable a refreshable clone

Explanation

Autonomous Database supports long-term backups that the customer creates with an explicit retention period, separate from the automatic backup retention window. Extending retention beyond the default requires that explicit long-term backup.

Question 37Oracle Cloud Infrastructure Database Services

A customer wants automatic failover of an Autonomous Database to a standby in another region during a regional outage. Which capability should they enable?

  1. A long-term backup
  2. A cross-region backup copy
  3. Autonomous Data Guard Correct answer.
  4. A refreshable clone

Explanation

Autonomous Data Guard maintains a standby Autonomous Database in another region and performs automatic failover if the primary region becomes unavailable. It is the disaster-recovery mechanism for regional outages.

Question 38Oracle Cloud Infrastructure Database Services

An application running in a non-OCI cloud needs low-latency access to Oracle Database while the database remains managed by OCI. Which OCI Database service option is designed for this scenario?

  1. Exadata Database Service on Dedicated Infrastructure in a remote region
  2. Autonomous Database on Shared Infrastructure in the home region
  3. Oracle Database@Azure or Oracle Database@Google Cloud Correct answer.
  4. Base Database Service with a public endpoint

Explanation

Oracle Database@Azure and Oracle Database@Google Cloud place Oracle Database infrastructure inside those clouds' regions, reducing latency for applications hosted there while OCI manages the service. This is the multi-cloud placement option.

Question 39Oracle Cloud Infrastructure Database Services

A customer must keep Oracle Database data in a specific country for regulatory reasons while using OCI Database services. Which OCI capability directly addresses this?

  1. Enabling Autonomous Data Guard
  2. Enabling a cross-region backup copy
  3. Using a refreshable clone in another region
  4. Choosing an OCI region in that country for the database Correct answer.

Explanation

Data residency is met by placing the database in an OCI region located in the required country, so data at rest and in processing stays within that jurisdiction. Backup and standby features must also be confined to compliant regions.

Question 40Oracle Cloud Infrastructure Database Services

A customer wants Transparent Data Encryption keys for an OCI Database to be stored in OCI Vault and rotated under their control. Which capability is required?

  1. Service-managed keys only
  2. Customer-managed keys in OCI Vault Correct answer.
  3. A wallet file stored on the client
  4. A long-term backup

Explanation

Customer-managed keys let the customer store and rotate the TDE master key in OCI Vault rather than relying on service-managed keys. This gives control over key lifecycle and separation of duties.

Question 41Oracle Cloud Infrastructure Database Services

A team wants to run Oracle Real Application Clusters in OCI with dedicated Exadata infrastructure. Which service supports this?

  1. Autonomous Database on Shared Infrastructure
  2. HeatWave MySQL
  3. Base Database Service on a single VM shape
  4. Exadata Database Service on Dedicated Infrastructure Correct answer.

Explanation

Exadata Database Service on Dedicated Infrastructure supports RAC on Exadata VM clusters, providing the shared storage and clusterware needed for RAC. Autonomous Database on Shared Infrastructure does not expose RAC to the customer.

Question 42Oracle Cloud Infrastructure Database Services

A customer wants Exadata automation and OCI management while keeping the Exadata infrastructure in their own data center. Which offering should they choose?

  1. Exadata Database Service on Dedicated Infrastructure
  2. Autonomous Database on Dedicated Infrastructure
  3. Exadata Cloud@Customer Correct answer.
  4. Base Database Service

Explanation

Exadata Cloud@Customer places Exadata infrastructure in the customer's data center while OCI provides the control plane and automation. It is the option for on-premises data placement with cloud-style management.

Question 43Oracle Cloud Infrastructure Database Services

A team needs to patch an Exadata Database Service on Dedicated Infrastructure deployment. Which sequence is correct for applying a grid infrastructure and database patch?

  1. Patch the databases and infrastructure in parallel, then the VM cluster
  2. Patch the Exadata infrastructure, then patch the VM cluster, then patch the databases Correct answer.
  3. Patch each database, then the VM cluster, then the infrastructure
  4. Patch the VM cluster, then the infrastructure, then the databases

Explanation

Patching follows an outside-in order: infrastructure first, then the VM cluster grid infrastructure, then the databases. This keeps the components compatible at each step and avoids patching a database against an unpatched grid.

Question 44Oracle Cloud Infrastructure Database Services

A customer is choosing between Autonomous Database on Dedicated Infrastructure and Exadata Database Service on Dedicated Infrastructure. Which requirement points to the Autonomous option?

  1. The team wants fully automated patching and tuning with no database administration Correct answer.
  2. The team needs OS-level access to the database hosts
  3. The team needs to manage the grid infrastructure directly
  4. The team needs custom database initialization parameters at the OS level

Explanation

Autonomous Database on Dedicated Infrastructure keeps the self-driving automation of Autonomous Database while providing dedicated Exadata isolation. Requirements for OS or grid administration point to Exadata Database Service instead.

Question 45Oracle Cloud Infrastructure Database Services

A customer needs to move a large on-premises Oracle Database to OCI with minimal downtime. Which approach best meets the requirement?

  1. Use OCI Database Migration with continuous replication and a short cutover Correct answer.
  2. Copy the data files with rsync and start the database
  3. Use a refreshable clone and switch over immediately
  4. Take a full Data Pump export and import during a maintenance window

Explanation

Database Migration can perform an initial load followed by continuous replication, so the final cutover window is short. A one-time export or file copy requires a long outage proportional to the data size.

Question 46Oracle Cloud Infrastructure Database Services

A workload on Autonomous Database has predictable daily peaks. The team wants compute to scale automatically within a defined range. Which configuration meets this?

  1. Increase the long-term backup retention
  2. Set the base compute size to the peak value permanently
  3. Create a refreshable clone for peak hours
  4. Enable auto scaling on the database with a base compute size Correct answer.

Explanation

Auto scaling lets Autonomous Database add compute up to three times the base OCPU count during demand and return to base afterward, within the configured base size. Setting base compute to the peak wastes resources outside peak hours.

Question 47Oracle Cloud Infrastructure Database Services

A customer wants a managed Oracle Database with control over the database version and patch level, plus the ability to run custom initialization parameters. Which service fits?

  1. Autonomous Database on Dedicated Infrastructure
  2. HeatWave MySQL
  3. Base Database Service Correct answer.
  4. Autonomous Database on Shared Infrastructure

Explanation

Base Database Service lets the customer choose the Oracle Database version and patch level and manage parameters at the database and OS level. Autonomous Database automates patching and restricts such control.

Question 48Oracle Cloud Infrastructure Database Services

Which OCI Database service feature provides automatic partition creation and maintenance for analytics tables in Autonomous Database?

  1. Automatic scaling
  2. Automatic partitioning Correct answer.
  3. Automatic indexing
  4. Automatic statistics gathering

Explanation

Automatic partitioning creates and maintains partitions for tables based on workload and data patterns, improving analytics performance without manual partition design. Automatic indexing and statistics are separate tuning features.

Question 49Oracle Cloud Infrastructure Database Services

A customer needs a managed Oracle Database that runs in Google Cloud data centers while OCI provides the service management. Which offering is this?

  1. Exadata Cloud@Customer
  2. Autonomous Database on Shared Infrastructure
  3. Base Database Service
  4. Oracle Database@Google Cloud Correct answer.

Explanation

Oracle Database@Google Cloud places Oracle Exadata infrastructure in Google Cloud regions while OCI provides the management plane. It is the multi-cloud option for workloads that must stay close to Google Cloud applications.

Question 50Oracle Cloud Infrastructure Database Services

A database administrator wants to confirm that an Autonomous Database is protected against a regional outage. Which configuration should they verify?

  1. A refreshable clone exists in the same region
  2. Auto scaling is enabled
  3. Autonomous Data Guard is enabled with a standby in another region Correct answer.
  4. Long-term backups are enabled

Explanation

Regional outage protection for Autonomous Database requires Autonomous Data Guard with a standby in a different region. Backups and clones in the same region do not survive a regional failure.