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

Question 1

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?

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

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 2

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 3

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 4

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 5

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

Question 6

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 Audit Vault and Database Firewall (AVDF) or OCI Audit combined with Oracle Data Safe and Database Unified Audit provides robust, tamper-proof auditing and compliance reporting.

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 7

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 fully automates infrastructure provisioning, tuning, patching, and scaling without requiring manual management of VMs or Exadata hardware.

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

Question 8

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?

Accepted Answer

Consumer groups and resource management rules via DBMS_RESOURCE_MANAGER or resource profile settings. Autonomous Database allows managing resource management rules and consumer groups, including setting parameters via DBMS_RESOURCE_MANAGER or adjusting CPU/concurrency profiles.

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 9

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 systems support Standard Edition 2, Enterprise Edition, Enterprise Edition High Performance, and Enterprise Edition Extreme Performance.

Answer

Oracle Database Express Edition (XE) exclusively

Answer

Microsoft SQL Server Enterprise Edition

Answer

MySQL Enterprise Edition and PostgreSQL Community Edition only

Question 10

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. In bi-directional GoldenGate replication, tables must have a primary key or unique identifier, and conflict detection and resolution (CDR) strategies must be implemented to handle concurrent updates.

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 11

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. If TDE master keys are stored in OCI Vault (external key management), the database can continue operating temporarily using cached keys in memory, but cannot restart or decrypt new sessions if key access remains blocked indefinitely.

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 12

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 provides virtual machine database systems with full root access and OS-level control.

Answer

Oracle Exadata Database Service on Dedicated Infrastructure

Answer

OCI NoSQL Database service

Answer

Oracle Autonomous Database Serverless

Question 13

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. Autonomous Database requires mTLS connections and specific egress/ingress rules; when using GoldenGate to connect to Autonomous Database, the GoldenGate subnet must allow outbound traffic and connect using the appropriate wallet and port 1522.

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 14

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 provides a web-based interface for running SQL queries, developing PL/SQL, managing users, and loading data into 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 15

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 <standby_database_name>;. To perform a planned switchover with zero data loss using Data Guard Broker, the SWITCHOVER command is executed.

Answer

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Answer

CONVERT DATABASE TO PHYSICAL STANDBY;

Answer

FAILOVER TO <standby_database_name>;