1Z0-997-26 Databases — 25 Questions

Question 1

Which TWO workload types are natively supported when provisioning an Oracle Autonomous Database in OCI? (Choose two.)

Accepted Answer

Autonomous Transaction Processing (ATP). Autonomous Database offers multiple workload types including Autonomous Transaction Processing and Autonomous Data Warehouse.

Answer

Autonomous Spark Analytics Engine (ASAE)

Answer

Autonomous Hadoop Distributed File System (AHDFS)

Question 2

Which TWO factors should an architect consider when sizing an Exadata Database Service on Dedicated Infrastructure? (Choose three/two - Choose two.)

Accepted Answer

Total OCPU count required across database VM clusters. Sizing Exadata Dedicated infrastructure requires evaluating current and future OCPU needs as well as storage requirements for database files and backups.

Answer

The number of local user SSH keys required for root password resets

Answer

OCI Identity and Access Management policy statement limits

Answer

The public IP bandwidth quotas allocated to OCI API endpoints

Question 3

You are migrating an on-premises Oracle Database (version 19c) to Oracle Autonomous Database (Serverless) using Oracle Data Pump. Which action is mandatory to ensure compatibility before generating the Data Pump export dump file?

Accepted Answer

Run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS PL/SQL package on the source database. When migrating to Autonomous Database using Data Pump, you must run the DBMS_CLOUD.PREPARE_FOR_AUTONOMOUS procedure or use the Autonomous Database Migration tool to check and convert incompatible tablespaces, segments, and objects.

Answer

Disable Automatic Workload Repository (AWR) collection on the source database

Answer

Convert the source database into an Oracle Multitenant Container Database with a single pluggable database

Answer

Manually drop all custom triggers and indexes to prevent import failures

Question 4

An organization is designing a disaster recovery strategy using Exadata Database Service on Dedicated Infrastructure. They require an Recovery Time Objective (RTO) of less than 30 seconds and a Recovery Point Objective (RPO) of zero for an enterprise database handling mission-critical workloads. Which Data Guard configuration should be implemented?

Accepted Answer

Oracle Active Data Guard configured in Maximum Protection mode with synchronous transport. To achieve an RPO of zero and ultra-low RTO for mission-critical Exadata workloads, Oracle Data Guard should be configured in Maximum Protection mode with synchronousredo transport across Availability Domains or regions.

Answer

Manual RMAN backup replication via OCI Object Storage every 15 minutes

Answer

Oracle Data Guard configured in Maximum Performance mode with asynchronous transport

Answer

Oracle GoldenGate real-time replication with asynchronous extract configurations

Question 5

You need to migrate a 50 TB Oracle Database from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime. The source database is operating on AIX and uses big-endian architecture, while OCI Exadata runs on little-endian Linux. Which migration method handles cross-platform endian conversion most efficiently?

Accepted Answer

RMAN Transportable Tablespaces with cross-platform data file conversion. Transportable Tablespaces with RMAN CONVERT DATAFILE provide the most efficient method for cross-platform migrations when endianness differs between source and target architectures.

Answer

Direct database clone via SQL*Developer migration wizard

Answer

Oracle GoldenGate initial load using SQL direct paths

Answer

Standard Oracle Data Pump export and import over direct database links

Question 6

Which OCI tool should a cloud architect recommend for automating the lifecycle management, patching, and backing up of a fleet of Oracle Base Database systems across multiple compartments?

Accepted Answer

OCI Database Management service. OCI Database Management service provides comprehensive monitoring, fleet management, and operational insights for Oracle databases across OCI.

Answer

OCI Compute Instance Scheduler

Answer

Oracle Cloud Infrastructure GoldenGate deployment console

Answer

OCI Identity and Access Management (IAM) policies

Question 7

An enterprise requires deploying an Oracle Autonomous Database on Dedicated Infrastructure to meet stringent data isolation and security mandates. Which foundational resource must be provisioned first before creating the Autonomous Container Database?

Accepted Answer

An Autonomous Exadata Infrastructure resource. Before you can provision an Autonomous Container Database (ACD) on Dedicated Infrastructure, you must provision an Autonomous Exadata Infrastructure resource which allocates the underlying physical Exadata compute and storage resources.

Answer

An Autonomous Database on Shared Infrastructure instance

Answer

A standard Oracle Base Database system

Answer

A Virtual Cloud Network with a default database subnet only

Question 8

Your development team wants to connect securely to an Autonomous Database (Serverless) instance using mutual TLS (mTLS) authentication. Where must the client application obtain the required credentials to establish this secure connection?

Accepted Answer

Download the database connection wallet zip file from the OCI Console or CLI and extract it on the client host. Clients connecting via mTLS to an Autonomous Database must download the wallet file (credentials zip) generated from the OCI Console or CLI.

Answer

Generate a Kerberos ticket granting service token via the IAM security console

Answer

Retrieve the master encryption key directly from OCI Vault using an API key

Answer

Configure a public SSL certificate issued by Let's Encrypt in the database parameter settings

Question 9

An architect is designing an Oracle Autonomous JSON Database instance to store flexible document workloads. Which feature is automatically enabled on Autonomous JSON Database that distinguishes it from general-purpose Autonomous Transaction Processing instances regarding storage management?

Accepted Answer

Storage and indexing are specifically optimized for JSON collections with restrictions on non-JSON relational tables. Autonomous JSON Database provides optimized storage and indexing specifically for JSON collections, allowing schema-less storage while maintaining relational capabilities, but restricts the creation of non-JSON relational tables.

Answer

Automatic conversion of all JSON documents into relational third-normal-form tables upon ingestion

Answer

Mandatory requirement to define fixed database schemas via JSON Schema validators before inserting data

Answer

Exclusion of automated backups to reduce operational overhead

Question 10

You are configuring scaling parameters for an Autonomous Database on Dedicated Infrastructure. You need to enable automatic scaling of CPU cores to handle unpredictable traffic bursts while maintaining strict cost controls. What is the maximum CPU core auto-scaling limit for an Autonomous Container Database on Dedicated Infrastructure?

Accepted Answer

Up to the total number of unallocated CPU cores available in the underlying Exadata Infrastructure instance. On Dedicated Infrastructure, auto-scaling for Autonomous Databases can scale up to the total number of unallocated CPU cores available in the underlying Exadata Autonomous Exadata Infrastructure instance.

Answer

Exactly three times the base OCPU count provisioned for the database instance

Answer

An unlimited amount limited only by OCI regional capacity limits

Answer

Fixed at a maximum of 128 OCPUs regardless of hardware size

Question 11

What is the primary architectural advantage of using Exadata Database Service on Dedicated Infrastructure compared to Exadata Database Service on Cloud@Customer?

Accepted Answer

The physical Exadata hardware resides and operates entirely within an OCI data center managed by Oracle. Exadata Database Service on Dedicated Infrastructure runs entirely within OCI datacenters, whereas Cloud@Customer runs physically inside the customer's on-premises datacenter.

Answer

It requires the customer to manage physical rack power, cooling, and hardware replacement

Answer

It exclusively supports non-relational database formats unlike Cloud@Customer

Answer

It eliminates the need for Virtual Cloud Networks (VCNs)

Question 12

You are designing a multi-database architecture where applications require read-scaling across different geographic regions with minimal replication lag. You decide to deploy Autonomous Data Warehouse (ADW) instances across three regions connected via GoldenGate. Which feature of Autonomous Database can be leveraged alongside GoldenGate to prevent sequence cache duplication conflicts across regions?

Accepted Answer

Configuring autonomous database global sequences with specific increment and offset parameters. When deploying multi-region distributed writes or replication architectures, utilizing Oracle Database features such as sequence caching with ORDER and NOORDER or scaling ranges prevents primary key collisions across nodes.

Answer

Setting the database character set to AL32UTF8 to handle multi-region strings

Answer

Using Oracle Autonomous Health Framework to automatically resolve distributed deadlocks

Answer

Enabling Autonomous Data Guard in Snapshot Standby mode in all regions simultaneously

Question 13

You are planning to migrate an Oracle Database to OCI using Zero Downtime Migration (ZDM). Which underlying Oracle migration technology does ZDM orchestrate behind the scenes for large databases requiring physical migration?

Accepted Answer

Oracle RMAN and Oracle Data Guard. OCI Zero Downtime Migration (ZDM) orchestrates native Oracle migration tools such as RMAN, Data Guard, and Data Pump depending on the workflow chosen (physical vs logical).

Answer

OCI Object Storage lifecycle policies exclusively

Answer

Third-party ETL pipelines and CSV flat file generation

Answer

MySQL Enterprise Backup and InnoDB replication

Question 14

An enterprise application running on Exadata Database Service on Dedicated Infrastructure experiences severe I/O contention due to a noisy neighbor batch reporting job. Which Exadata storage feature should you configure to isolate and guarantee I/O resources for critical online transaction processing (OLTP) workloads?

Accepted Answer

Exadata I/O Resource Management (IORM) with database-level resource plans. Exadata Storage Server Resource Management (IORM) allows administrators to allocate I/O resource shares and limit bandwidth consumption for specific database workloads or consumer groups.

Answer

OCI Block Volume performance tiers (Higher VPU settings)

Answer

Autonomous Database concurrency limits in the OCI console

Answer

OCI Compute Auto-scaling configurations on the domU guest VMs

Question 15

Which Autonomous Database workload type is specifically optimized for running complex analytical queries, machine learning, and data warehousing workloads?

Accepted Answer

Autonomous Data Warehouse (ADW). Autonomous Data Warehouse (ADW) is optimized for analytical queries, reporting, and data warehousing.

Answer

Autonomous JSON Database (AJD)

Answer

Autonomous Transaction Processing (ATP)

Answer

Autonomous Apex Application Development (APEX)

Question 16

You are migrating an Oracle Database to an Exadata Database Service on Dedicated Infrastructure. You need to ensure that database backups are stored securely with zero public internet exposure. What is the recommended networking architecture for backup transmission?

Accepted Answer

Configure a Service Gateway in your VCN to access OCI Object Storage privately. OCI services like Database backups communicate via Service Gateways or Private Endpoints to prevent traversing the public internet.

Answer

Deploy an internet gateway with IPSec VPN tunnels terminating at the backup bucket

Answer

Expose a NAT Gateway with strict IP whitelisting

Answer

Attach a secondary public IP address to the database VM guest nodes

Question 17

An architect is configuring disaster recovery for an Autonomous Database (Serverless) instance using Autonomous Data Guard. The primary database resides in the US East (Ashburn) region, and the standby is in US West (Phoenix). What is the behavior of the standby database regarding read operations?

Accepted Answer

The standby database can be accessed in read-only mode for reporting and queries. Autonomous Data Guard standby databases can be opened in read-only mode to offload reporting queries from the primary database.

Answer

The standby database automatically accepts write operations and replicates them back to the primary

Answer

The standby database accepts read-write transactions concurrently with the primary database

Answer

The standby database is completely inaccessible until a manual switchover or failover occurs

Question 18

When provisioning an Oracle Base Database system on OCI, which storage management architecture is utilized by default for storing database files (datafiles, redo logs, control files)?

Accepted Answer

Oracle Automatic Storage Management (ASM) configured across OCI Block Volumes. OCI Base Database systems use Oracle ASM (Automatic Storage Management) across OCI Block Volumes to manage database storage.

Answer

Network File System (NFS) shared mounts from a third-party NAS filer

Answer

Raw Device Mapping (RDM) shared via Fibre Channel SAN

Answer

Local NVMe drives directly attached to the hypervisor without redundancy

Question 19

You are configuring an Autonomous Database instance and need to restrict incoming database traffic so that only specific corporate subnet CIDR blocks can access the database service endpoints. Which feature should you configure?

Accepted Answer

Autonomous Database Access Control Lists (ACLs) specifying allowed IP CIDR blocks. Access Control Lists (ACLs) on Autonomous Database allow administrators to restrict network access using IP addresses or VCN OCIDs.

Answer

OCI Web Application Firewall (WAF) attached directly to the database listener port

Answer

OCI Identity and Access Management dynamic groups

Answer

Database Vault realm restrictions

Question 20

You are designing a high-availability architecture for an Oracle Base Database system across two Availability Domains (ADs) within a single OCI region. Which multi-database HA pattern ensures automatic failover with minimal data loss?

Accepted Answer

Oracle Data Guard configured between primary and standby database instances across ADs. Oracle Data Guard configured between two VMs across different Availability Domains provides high availability and automatic failover.

Answer

Periodic RMAN duplication scripts executed via cron jobs every hour

Answer

Active-Active Oracle RAC cluster spanning multiple Availability Domains over long-distance synchronous interconnects

Answer

Shared OCI Block Volumes mounted simultaneously by database nodes in different ADs