1Z0-997-26 Practice Test 3 — 25 Questions

Question 1

Which TWO features of OCI Object Storage contribute to its high durability and reliability for disaster recovery workflows? (Choose two.)

Accepted Answer

Object versioning support to protect against accidental deletion or overwriting.. Object Storage stores data redundantly across multiple fault domains/ADs and offers lifecycle management / versioning capabilities.

Answer

Restricting bucket access exclusively to local console sessions.

Answer

Storing all objects on a single physical disk inside a single compute instance.

Answer

Requiring manual user replication scripts for every individual file uploaded.

Question 2

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 3

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). Standard Edition 2 and Enterprise Edition are core editions available for Oracle Base Database systems.

Answer

Oracle Database Micro Edition (ME)

Answer

Oracle Database Web Edition (WE)

Answer

Oracle Database Personal Edition (PE)

Question 4

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 5

An enterprise application running on Oracle Autonomous Transaction Processing (ATP) requires dedicated infrastructure isolation for compliance reasons. You need to provision an Autonomous Database on Dedicated Exadata Infrastructure. Which architectural step is mandatory before you can provision the database instance?

Accepted Answer

Create an Autonomous Exadata Infrastructure resource in your compartment and virtual cloud network.. Before provisioning an Autonomous Database on Dedicated Exadata Infrastructure, you must first create an Autonomous Exadata Infrastructure resource within a specific availability domain or fault domains, which reserves the underlying compute and storage resources.

Answer

Contact Oracle Support to manually allocate physical rack boundaries in your tenancy region.

Answer

Create a Pluggable Database (PDB) manually via SQL*Plus on an existing multitenant container database.

Answer

Provision a standard Exadata Cloud Service cluster using the Database management service console.

Question 6

When designing high availability for an Oracle RAC (Real Application Clusters) database deployed on OCI Exadata Database Service, which THREE architectural characteristics ensure fault tolerance and uptime? (Choose three.)

Accepted Answer

Multi-node database clustering across distinct Fault Domains or Availability Domains. RAC on Exadata leverages multiple database nodes across fault domains, transparent application failover (TAF/Application Continuity), and shared storage across redundant storage cells.

Answer

Running the entire cluster on a single Oracle Linux compute instance without Grid Infrastructure

Answer

Storing all database data on a single local NVMe drive on node 1

Question 7

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 8

Which TWO backup destinations are natively supported when configuring automated backups for Oracle Base Database systems on OCI? (Choose two.)

Accepted Answer

OCI Object Storage Archive tier (for long-term retention policies). Base Database systems support backups directly to OCI Object Storage (Standard bucket) or OCI Object Storage Classic / Archive storage tiers.

Answer

Local unformatted swap partitions on the database host

Answer

Public GitHub code repositories

Answer

Local USB flash drives plugged into the database VM guest node

Question 9

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 10

You are performing maintenance on an OCI Load Balancer backend set. You want to temporarily stop sending traffic to a specific backend server without immediately dropping active persistent connections. What feature should you use?

Accepted Answer

Enable Connection Draining on the backend server.. Draining allows a load balancer to stop sending *new* requests to a backend server while allowing existing persistent connections to complete gracefully.

Answer

Set the backend server weight to zero without enabling draining.

Answer

Delete the backend server from the backend set immediately.

Answer

Modify the security list to drop all TCP packets on port 443.

Question 11

You are optimizing the cost and performance of an Exadata Database Service on Dedicated Infrastructure environment hosting multiple large databases. Which THREE practices should you implement to achieve optimal resource utilization and cost efficiency?

Accepted Answer

Consolidate multiple non-CDB databases into a single Multitenant Container Database (CDB) with multiple PDBs.. To optimize Exadata Dedicated environments, you can leverage OCPUs scaling, database consolidation into multitenant container databases, and storage server flash cache optimizations.

Answer

Migrate all table data to standard Block Volume storage to bypass Exadata storage servers.

Answer

Disable automatic backups entirely to save OCI Object Storage costs.

Question 12

An OCI architect is setting up a disaster recovery environment where compute instances in the DR region need identical network configurations (private IPs, VNICs, security lists) to the primary region. Which OCI capability assists in deploying reproducible network topologies across regions?

Accepted Answer

OCI Resource Manager with Terraform configurations. OCI Resource Manager uses Terraform to provision infrastructure as code, allowing architects to replicate identical VCN, subnet, and security configurations across regions.

Answer

OCI File Storage Network File System (NFS) exports

Answer

OCI IAM Domain Federation wizard

Answer

OCI Streaming service partition replication

Question 13

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 14

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 15

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 VM clusters utilize Oracle Virtual Machine (dom0/domU) virtualization architecture to completely isolate resources between different clusters on the same physical 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 16

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 policies and schedules for Exadata Database Service are configured directly through the OCI Console, CLI, or API under the database system backup settings.

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 17

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 18

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 19

You are managing an Oracle Base Database Service instance configured with Data Guard in OCI. Due to a severe networking anomaly, the standby database falls significantly behind in applying redo. You decide to rebuild the standby database from an incremental backup taken on the primary. Which Recovery Manager (RMAN) command or process is used to synchronize the standby with the new incremental backup?

Accepted Answer

Apply an incremental backup from SCN on the primary database to the standby database using RMAN.. RMAN incremental backup from SCN allows you to apply an incremental backup taken from the primary database directly to the standby database to catch it up without having to recreate the entire standby from scratch.

Answer

Execute a complete cold restore of all datafiles using FTP over port 21.

Answer

Reboot the OCI compute host using the OCI console 'Reset' button.

Answer

Run 'ALTER DATABASE CONVERT TO SNAPSHOT STANDBY' and drop all tablespaces.

Question 20

When designing high availability for stateless web servers in OCI, which combination of services provides automatic scaling and load distribution across multiple Availability Domains?

Accepted Answer

OCI Instance Pools, Autoscaling Configurations, and a regional OCI Load Balancer. Combining OCI Instance Pools, Autoscaling Configurations, and an OCI Load Balancer provides automated scaling and multi-AD high availability.

Answer

OCI Streaming and OCI Notifications service

Answer

OCI Database Backup Policies and Local Peering Gateways

Answer

OCI Vaults and OCI Key Management service