1Z0-997-26 Databases Practice Test 2 — 15 Questions

Question 1

An architect is deploying Oracle Exadata Database Service on Dedicated Infrastructure and must enable Transparent Data Encryption (TDE) using a customer-managed key stored in OCI Vault. The deployment spans two regions for disaster recovery. Which two statements are correct about key management for this configuration? (Choose two.)

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The master encryption key must exist in an OCI Vault in the same region as the Exadata infrastructure, and the standby region requires its own vault and key.. OCI Vault is regional, so each region hosting an Exadata system needs its own vault and master encryption key, and the primary and standby databases each reference a key in their own region. OCI Vault supports key rotation, and rotating the vault key re-wraps the TDE master key without re-encrypting existing data, so the database keeps decrypting older data with prior key versions while new writes use the rotated key.

Answer

A single OCI Vault master encryption key can be shared across both regions because OCI Vault keys are globally replicated by default.

Answer

Deleting the OCI Vault key immediately renders the Exadata database unrecoverable, because TDE master keys cannot be restored from vault backups.

Answer

The customer-managed key in OCI Vault replaces the need for a TDE wallet on the Exadata database, so no wallet files are created or managed.

Question 2

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. RPO of zero requires synchronous redo transport so no committed transaction can be lost, and RTO under 30 seconds requires a standby that is already mounted, open read-only, and ready for immediate failover. Maximum Protection mode with Active Data Guard satisfies both: SYNC transport guarantees zero data loss, and Active Data Guard keeps the standby continuously applying redo so failover is near-instant. This is the only option that meets both objectives simultaneously.

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 3

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 is purpose-built for fleet-level lifecycle operations on Base Database and Exadata systems: it provides patching, backup management, performance monitoring, and compliance reporting across compartments from a single console. It integrates with OCI IAM for compartment-scoped access and supports both autonomous and non-autonomous databases. This is the only option that directly addresses patching and backup automation for a fleet of Base Database systems.

Answer

OCI Compute Instance Scheduler

Answer

Oracle Cloud Infrastructure GoldenGate deployment console

Answer

OCI Identity and Access Management (IAM) policies

Question 4

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. To deploy an Autonomous Database on Dedicated Infrastructure, the foundational resource is the Autonomous Exadata Infrastructure (AEI). This is a dedicated Exadata system in OCI that provides the hardware and infrastructure for hosting Autonomous Container Databases (ACDs). The AEI must be provisioned first because it supplies the compute, storage, and network resources that the ACDs and subsequent Autonomous Databases will use. Without an AEI, you cannot create an ACD or any dedicated autonomous databases.

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 5

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. For mTLS connections to Autonomous Database Serverless, the client must download the connection wallet zip from the OCI Console or CLI (or via the ADB API) and extract it on the client host. The wallet contains the client credentials (e.g., cwallet.sso, tnsnames.ora, sqlnet.ora) required to authenticate the client to the database over TLS. Without the wallet, mTLS cannot be established.

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 6

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 is a specialized ADB workload type whose storage and indexing are optimized for JSON collections, and it restricts the use of non-JSON relational tables. This distinguishes it from general-purpose Autonomous Transaction Processing, which supports full relational schemas alongside JSON. The optimization targets document-style access patterns and JSON-native indexing.

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 7

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 the Exadata hardware inside an OCI data center fully managed by Oracle, so the customer does not own or operate the physical infrastructure. This is the primary architectural advantage over Cloud@Customer, where the Exadata rack sits in the customer's own data center and the customer is responsible for power, cooling, and physical security.

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 8

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. Zero Downtime Migration (ZDM) orchestrates Oracle Recovery Manager (RMAN) for the initial physical backup and restore, and Oracle Data Guard for ongoing replication to minimize downtime during the migration to OCI. For large databases requiring physical migration, ZDM leverages these native Oracle technologies to ensure data consistency and near-zero downtime. RMAN handles the bulk data movement, while Data Guard keeps the target in sync until the cutover.

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 9

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 I/O Resource Management (IORM) is the Exadata storage-layer feature that lets you define resource plans allocating I/O shares, limits, and flash cache quotas per database, consumer group, or category. Configuring a database-level IORM plan lets you cap the batch reporting job's I/O so the OLTP workload's critical I/O is guaranteed. This is the purpose-built Exadata mechanism for noisy-neighbor isolation.

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 10

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 the Autonomous Database workload type specifically tuned for analytical workloads: it uses columnar compression, automatic indexing for analytics, materialized view refresh, and parallel execution optimized for complex queries, machine learning, and data warehousing. ATP is tuned for high-concurrency transactional workloads, and AJD is optimized for JSON document workloads.

Answer

Autonomous JSON Database (AJD)

Answer

Autonomous Transaction Processing (ATP)

Answer

Autonomous Apex Application Development (APEX)

Question 11

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. A Service Gateway in the VCN provides a private path from the VCN to OCI Object Storage (and other Oracle services) without traversing the internet or requiring a NAT or internet gateway. Traffic to Object Storage stays on the Oracle backbone network, so backups from Exadata Database Service on Dedicated Infrastructure are transmitted with zero public internet exposure, satisfying the security requirement.

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 12

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. Autonomous Database supports Access Control Lists (ACLs) that specify allowed IP CIDR blocks for database service endpoints. This is the native, supported mechanism to restrict incoming traffic to specific corporate subnets without deploying additional network appliances.

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 13

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 is Oracle's native disaster-recovery and HA solution that maintains a synchronized standby database in a different Availability Domain. With Data Guard in Maximum Availability or Maximum Performance mode using asynchronous or synchronous redo transport, failover can be automated via Fast-Start Failover (FSFO) with the Data Guard broker, achieving minimal data loss (zero with SYNC, near-zero with ASYNC) and automatic role transition. This is the standard multi-AD HA pattern for Oracle Base Database on OCI.

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

Question 14

An organization running an Oracle Exadata Database Service requires compliance auditing where all database administrative actions and sensitive data queries must be logged, tamper-proof, and retained in an isolated repository. Which combination of OCI and Oracle Database features provides this capability?

Accepted Answer

Oracle Data Safe combined with Database Unified Audit policies. Oracle Data Safe combined with Database Unified Audit policies provides centralized, tamper-proof auditing for administrative actions and sensitive data queries. Data Safe collects audit trails into a secure repository, applies masking and security assessments, and Unified Auditing captures the required events at the database level.

Answer

OCI Object Storage unversioned buckets with public read permissions

Answer

Oracle Data Pump export logs stored in local temporary directories

Answer

Standard Linux syslog daemon writing to local disk partitions

Question 15

What is the primary benefit of using OCI Autonomous Database Serverless compared to Provisioned (Dedicated) infrastructure regarding database administration?

Accepted Answer

Oracle fully automates all patching, tuning, scaling, and provisioning with zero infrastructure management required. Autonomous Database Serverless is fully managed by Oracle: provisioning, patching, upgrades, tuning, scaling, and backups are automated with no customer access to the underlying Exadata infrastructure. This contrasts with Provisioned/Dedicated, where the customer still controls Exadata infrastructure lifecycle tasks even though the database itself is autonomous. The primary administrative benefit is therefore the elimination of infrastructure management overhead.

Answer

Customers must manually configure Exadata cell software versions

Answer

Serverless databases do not support automated backups

Answer

Customers are required to manually apply quarterly database security patches