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

Question 1

An enterprise application uses an Oracle Autonomous Transaction Processing database and encounters intermittent application-level timeouts during peak concurrency spikes. Upon investigating, you notice that queued statements are waiting due to resource limits. Which Autonomous Database feature should you adjust to manage concurrency and statement queuing behavior?

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

Accepted Answer

Consumer groups and resource management rules via DBMS_RESOURCE_MANAGER or resource profile settings. Autonomous Database uses Database Resource Manager (DBRM) consumer groups and resource plans to control how sessions share CPU, parallelism, and queued statements. When concurrency spikes cause statements to queue, the fix is to define or adjust consumer groups and resource management rules (via DBMS_RESOURCE_MANAGER or the built-in resource profiles) so that critical workloads get priority and queuing thresholds are tuned. This is the only option that directly addresses database-level concurrency and statement queuing.

Answer

The physical memory size of the OCI Compute host instance running the application

Answer

Linux kernel swappiness parameters on the database host

Answer

OCI Virtual Cloud Network security list packet drop thresholds

Question 2

When creating an Oracle Base Database system, which database edition options are available for licensing on OCI?

Accepted Answer

Standard Edition 2, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance. Oracle Base Database Service on OCI offers the same commercial editions as on-premises Oracle Database: Standard Edition 2, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance. These are the licensing options available when provisioning a Base Database system.

Answer

Oracle Database Express Edition (XE) exclusively

Answer

Microsoft SQL Server Enterprise Edition

Answer

MySQL Enterprise Edition and PostgreSQL Community Edition only

Question 3

You need to migrate an on-premises Oracle Database to OCI Exadata Database Service using Oracle GoldenGate for zero-downtime migration with bi-directional replication. Which critical design consideration must be addressed regarding table design on both databases?

Accepted Answer

Tables must have primary keys or unique identifiers, and Conflict Detection and Resolution (CDR) must be configured. For bi-directional replication with Oracle GoldenGate, tables must have primary keys or unique identifiers to ensure that each row can be uniquely identified for conflict detection and resolution. Conflict Detection and Resolution (CDR) must be configured to handle conflicts that arise when the same row is modified on both databases. This is critical for zero-downtime migration with bi-directional replication.

Answer

Primary keys must be omitted to allow duplicate row insertion across databases

Answer

Tables must not contain any indexes, triggers, or constraints

Answer

All tables must be converted to temporary unlogged tables

Question 4

You are configuring transparent data encryption (TDE) for an Oracle Database on Exadata Database Service using OCI Vault for master encryption key management. What happens if the database loses connectivity to the OCI Vault key management service?

Accepted Answer

The database continues to run using keys cached in memory for a period, but cannot be restarted until connectivity to OCI Vault is restored. When TDE uses OCI Vault as the external key management service, the database caches the master encryption key in memory after first retrieval. If connectivity to OCI Vault is lost, running instances continue to operate using the cached key, but any restart or new instance mount fails because the key cannot be fetched to open the TDE wallet. This is the documented behavior for external key management with TDE.

Answer

The database instantly crashes and forces an immediate failover to the standby database

Answer

The database automatically falls back to self-managed wallet storage without alerting administrators

Answer

All encrypted data files are automatically wiped to prevent security breaches

Question 5

Which OCI database service provides fully managed Oracle Database instances running on dedicated virtual machines with root access and granular control over operating system parameters?

Accepted Answer

Oracle Base Database service. Oracle Base Database service (formerly Bare Metal and VM DB systems) provisions fully managed Oracle Database instances on dedicated VMs or bare metal where you get SSH root access and can tune OS kernel parameters, huge pages, and network settings. It is the OCI offering that sits between fully autonomous (no OS access) and self-managed (you run everything). This matches the requirement for root access and granular OS control.

Answer

Oracle Exadata Database Service on Dedicated Infrastructure

Answer

OCI NoSQL Database service

Answer

Oracle Autonomous Database Serverless

Question 6

An enterprise is implementing a multi-database architecture utilizing Oracle GoldenGate microservices on OCI Compute instances to replicate data between an operational Exadata database and an analytical Autonomous Data Warehouse. Which network security construct must be configured to allow communication between the GoldenGate deployment and the Autonomous Database instance?

Accepted Answer

Configure VCN security lists or Network Security Groups (NSGs) allowing outbound TCP port 1522 and inbound mTLS traffic, and supply the ADB wallet. GoldenGate microservices on OCI Compute connect to Autonomous Database using the ADB wallet for mTLS authentication and the ADB's TCPS listener on port 1522. The VCN security lists or NSGs must allow outbound TCP 1522 from the GoldenGate host and inbound mTLS traffic to the ADB, and the wallet must be supplied to GoldenGate for the connection to succeed. This is the standard secure connectivity pattern for ADB.

Answer

Expose an API Gateway with public IP routing directly to the database undo tablespace

Answer

Configure a Local Peering Gateway with remote VCN route tables pointing to port 22

Answer

Attach an Internet Gateway directly to the Autonomous Database private IP address

Question 7

What is the primary purpose of OCI Database Actions (SQL Developer Web) when working with an Oracle Autonomous Database?

Accepted Answer

To provide a web-based development and management interface for executing SQL, querying data, and managing database users. OCI Database Actions (SQL Developer Web) is a web-based tool that provides a development and management interface for Autonomous Database, allowing users to execute SQL, query data, manage database users, and perform other administrative tasks. It is the primary browser-based interface for interacting with Autonomous Database.

Answer

To configure physical Exadata storage cell disks and flash cache parameters

Answer

To monitor physical VCN packet drops and firewall logs

Answer

To manage OCI IAM user groups and federation settings across enterprise identity providers

Question 8

You are configuring disaster recovery for an Oracle Base Database system using Oracle Data Guard with Data Guard Broker. You need to perform a role transition where the primary database becomes the standby and the standby becomes the primary with zero data loss. Which Data Guard Broker command should you execute?

Accepted Answer

SWITCHOVER TO ;. In Data Guard Broker, a switchover is a planned role transition where the primary becomes the standby and the standby becomes the primary with zero data loss. The command to perform a switchover is 'SWITCHOVER TO ;' executed via DGMGRL. This ensures no data loss because the primary is synchronized with the standby before the transition.

Answer

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Answer

CONVERT DATABASE TO PHYSICAL STANDBY;

Answer

FAILOVER TO <standby_database_name>;

Question 9

You are designing an automated backup strategy for an Exadata Database Service on Dedicated Infrastructure. You want to ensure that incremental backups are taken daily and full backups weekly, with long-term retention stored in OCI Object Storage. Where are these backup schedules configured?

Accepted Answer

In the OCI Console under the database system backup configuration settings or via API/CLI. Backup schedules for Exadata Database Service on Dedicated Infrastructure are configured through the OCI Console under the database system's backup configuration, or via the OCI API/CLI. These settings define the retention period, backup window, and whether backups are stored in OCI Object Storage, and they control the automated incremental and full backup cadence.

Answer

By modifying the crontab configuration file as root on the dom0 hypervisor node

Answer

By editing the initialization parameter file (spfile) using SQL*Plus

Answer

Via Oracle Enterprise Manager Cloud Control deployed exclusively on-premises

Question 10

An architect is designing an Oracle Exadata Database Service on Dedicated Infrastructure deployment with multiple VM clusters on a single Exadata rack. Which architectural feature allows secure isolation of CPU, memory, and database workloads between these distinct VM clusters?

Accepted Answer

Hard partitioning using Oracle VM (dom0/domU) hypervisor virtualization on the database servers. Exadata Database Service on Dedicated Infrastructure uses Oracle VM (OVM) with dom0/domU architecture to provide hard partitioning between VM clusters. Each VM cluster runs in its own set of domU guests on the database servers, with CPU, memory, and I/O isolated by the hypervisor. This hard partitioning is what allows multiple VM clusters to coexist securely on a single Exadata rack.

Answer

OCI Block Volume volume group replicas synchronized via block replication

Answer

Software-defined VLAN tagging enforced by the OCI Virtual Cloud Network (VCN) hypervisor only

Answer

Autonomous Database container database resource pools sharing a single OS kernel

Question 11

Which THREE features are unique or heavily enhanced capabilities of Oracle Exadata Database Service on Dedicated Infrastructure compared to standard OCI Base Database systems? (Choose three.)

Accepted Answer

Exadata Storage Server Resource Management (IORM) for fine-grained I/O prioritization. Option C is correct because Exadata Database Service on Dedicated Infrastructure includes Exadata's I/O Resource Management (IORM), which lets you define and enforce fine-grained I/O prioritization and limits across databases, consumer groups, and interconnects—capabilities not available in standard OCI Base Database systems. Option D is correct because Exadata systems uniquely combine Exadata Smart Flash Cache with Persistent Memory (PMEM) to accelerate I/O and reduce latency for critical database workloads, a hardware-level optimization absent from Base Database. Option E is correct because Exadata Smart Scan offloads query processing (filtering, column projection, and some aggregation) to the Exadata Storage Servers, dramatically reducing data transferred to the database nodes—this storage-offload architecture is a defining Exadata feature not present in Base Database. Option A is incorrect because Exadata does not natively attach Azure Blob Storage containers as ASM disk groups; ASM disks are provided by Exadata storage cells or local/attached block storage, not Azure Blob. Option B is incorrect because automatic index creation is not performed by a Linux kernel swap daemon; index management is handled by the database (e.g., Automatic Indexing in Oracle Database), and the swap daemon has no role in index creation.

Answer

Native support for attaching external Microsoft Azure Blob Storage containers as ASM disk groups

Answer

Automatic index creation managed entirely by the local Linux kernel swap daemon

Question 12

Which TWO editions of Oracle Database are available when deploying an Oracle Base Database system on OCI? (Choose two.)

Accepted Answer

Oracle Database Enterprise Edition (EE). Oracle Base Database Service on OCI supports Oracle Database Enterprise Edition (EE), option B, which provides the full feature set including options like RAC, Data Guard, partitioning, and advanced security for mission-critical workloads. It also supports Oracle Database Standard Edition 2 (SE2), option D, a lower-cost edition suited for smaller deployments with up to two sockets per node. Options A, C, and E are not valid Oracle Database editions offered on OCI: Oracle Database Micro Edition (ME) and Web Edition (WE) are not real Oracle Database editions, and Personal Edition (PE) is a desktop-only edition not available for cloud deployment.

Answer

Oracle Database Micro Edition (ME)

Answer

Oracle Database Web Edition (WE)

Answer

Oracle Database Personal Edition (PE)

Question 13

When designing a high-availability and disaster recovery architecture for an enterprise Oracle Database on OCI, which THREE components or patterns are crucial for achieving optimal recovery and uptime? (Choose three.)

Accepted Answer

Automated and policy-driven backups to OCI Object Storage with cross-region replication. Option A is correct because automated, policy-driven backups written to OCI Object Storage and replicated across regions provide durable, off-site recovery points that survive regional failures and satisfy RPO/RTO objectives. Option C is correct because Oracle Data Guard maintains a synchronized standby database in a remote region, enabling fast failover and near-zero data loss for regional disaster recovery. Option E is correct because Oracle RAC spread across fault domains or availability domains provides local high availability by eliminating single points of failure and enabling instance-level failover within a region. Option B is incorrect because local ephemeral NVMe snapshots are tied to the compute instance and are lost if the host or region fails, so they cannot serve as a disaster recovery mechanism. Option D is incorrect because a single-node database VM cannot be stretched across regions, and unencrypted NFS mounts introduce security and latency problems that undermine both availability and compliance.

Answer

Relying solely on local ephemeral NVMe drive snapshots for disaster recovery

Answer

Stretching a single-node database VM across distinct cloud regions using unencrypted NFS mounts

Question 14

Which THREE strategies are recommended when planning a large-scale database migration (exceeding 100 TB) from on-premises to Exadata Database Service on Dedicated Infrastructure with minimal downtime? (Choose three.)

Accepted Answer

Leveraging Transportable Tablespaces (TTS) combined with RMAN cross-platform conversion. Option A is correct because Transportable Tablespaces (TTS) with RMAN cross-platform conversion moves datafiles at the physical level, avoiding the slow row-by-row logical extraction that would be impractical for 100 TB, and RMAN's CONVERT DATAFILE handles endianness/platform differences efficiently. Option B is correct because Oracle Zero Downtime Migration (ZDM) physical migration workflows are purpose-built for large on-premises-to-Exadata/ODA moves, orchestrating Data Guard-based synchronization and automated cutover to keep downtime minimal. Option E is correct because configuring Oracle Data Guard or Oracle GoldenGate for ongoing delta synchronization lets the bulk copy happen while changes continue to be applied, so only a brief final switchover is needed at cutover. Option C is not recommended because unencrypted FTP over the public internet is insecure and unreliable for 100 TB of database files. Option D is not recommended because exporting 100 TB into a single plaintext SQL script via SQL Developer is a logical, serialized, and insecure approach that would take far too long and cannot meet minimal-downtime requirements.

Answer

Copying database files across the public internet using standard FTP without encryption

Answer

Exporting the entire 100 TB database into a single plaintext SQL script using SQL*Developer

Question 15

Which TWO tools or interfaces can administrators use to manage Oracle Autonomous Database instances in OCI? (Choose two.)

Accepted Answer

OCI Command Line Interface (CLI) and REST APIs. Option D is correct because Oracle Autonomous Database is a fully managed OCI service whose lifecycle and management operations (such as scaling, starting/stopping, cloning, and viewing details) are exposed through the OCI Command Line Interface and the OCI REST APIs, which administrators can script and automate. Option E is correct because the OCI Console provides the web-based graphical interface where administrators can create, monitor, and manage Autonomous Database instances without writing code. The other options do not belong: A (floppy disk image uploads) is an obsolete local media method with no role in OCI cloud management, B (RDP to the Autonomous database hypervisor) is impossible because Oracle manages the infrastructure and customers have no hypervisor access, and C (physical serial console cable to Exadata rack blades) is not a customer-accessible management path in a managed cloud service.

Answer

Local floppy disk drive image uploads

Answer

Windows Remote Desktop Connection (RDP) to the Autonomous database hypervisor

Answer

Direct physical serial console cable attached to Exadata rack blades