1Z0-1072-26 Database — Timed 25 Questions

Question 1

You need to restore an Oracle Base Database System to a specific point in time using incremental backups and archived redo logs. Which tool should you use at the OS level if you are managing the recovery manually?

25 minute time limit — choose an answer to begin.

Accepted Answer

Oracle Recovery Manager (RMAN). Oracle Recovery Manager (RMAN) is the standard Oracle tool used for backup, restoration, and recovery of database files including datafiles, control files, and archived redo logs.

Answer

Data Pump (impdp)

Answer

OCI Block Storage Volume Snapshots

Answer

SQL*Loader

Question 2

You are managing an Oracle Base Database System (Virtual Machine) and need to scale up the compute shape to a higher number of OCPUs to handle an upcoming month-end processing spike. Which action should you perform?

Accepted Answer

Edit the DB system configuration in the OCI Console and update the OCPU count or shape directly.. For Oracle Base Database Systems, you can scale up the compute shape by modifying the OCPU core count or shape directly from the OCI Console without losing data.

Answer

Terminate the current DB system and provision a new one with the larger shape, then restore from a manual backup.

Answer

Stop the database instance via SQL*Plus and run the 'alter system modify shape' command.

Answer

Attach an additional block storage volume with higher performance tiers to absorb the extra compute load.

Question 3

You are configuring an Exadata Cloud Service (ExaCS) instance and need to ensure maximum isolation and security for your database infrastructure. Which architectural layer provides tenant isolation at the hypervisor level in ExaCS?

Accepted Answer

Oracle VM or KVM guest virtualization (domU). In Exadata Cloud Service, Oracle manages the underlying hardware, and tenant isolation is achieved using Oracle VM (OVM) or KVM-based virtualization to isolate dom0 and guest domU virtual machines.

Answer

Virtual Cloud Network (VCN) security lists and network security groups

Answer

Storage Server Cell software zones

Answer

Exadata Database Vault compartment boundaries

Question 4

Which Autonomous Database deployment model runs on dedicated Exadata infrastructure residing in a customer's OCI tenancy, providing maximum isolation?

Accepted Answer

Autonomous Database on Dedicated Exadata Infrastructure. Autonomous Database on Dedicated Exadata Infrastructure (Autonomous Dedicated) provides a completely dedicated database environment within a dedicated Exadata rack.

Answer

Exadata Cloud at Customer (ExaCC)

Answer

Autonomous Database on Shared Infrastructure

Answer

Oracle Base Database System

Question 5

You are managing an Oracle Base Database System and need to configure automated backups. By default, where does OCI store these automated backups?

Accepted Answer

An Oracle-managed Object Storage bucket. OCI stores automated backups of database systems in an Oracle-managed Object Storage bucket specific to your tenancy.

Answer

A customer-managed File Storage Service (FSS) mount target

Answer

The local root file system (/u01) of the database VM

Answer

A locally attached block volume separate from the database data disk

Question 6

You are setting up Oracle Data Guard between a primary Base Database System in the us-ashburn-1 region and a standby database in the us-phoenix-1 region. Which networking configuration is mandatory to enable redo transport across regions?

Accepted Answer

Configuring a Dynamic Routing Gateway (DRG) and Remote VCN Peering between the regions. Cross-region Data Guard requires Remote VCN Peering or DRG attachments with appropriate security list rules allowing traffic on listener ports (e.g., port 1521) between the primary and standby subnets.

Answer

A Public Load Balancer fronting the standby database listener

Answer

Enabling NAT gateways in both regions to route private database redo packets

Answer

Installing an IPSec VPN appliance directly on the database node operating systems

Question 7

Your development team needs to perform automated regression testing against a production copy of an Autonomous Transaction Processing (ATP) database. Which feature allows you to create a point-in-time, space-efficient copy of the production database instantly?

Accepted Answer

Autonomous Database Clone (Thin Clone). Autonomous Database Clones allow you to create either a full clone or a metadata-only thin clone instantly for development and testing purposes.

Answer

Cross-Region Object Storage Export

Answer

Autonomous Database Data Guard

Answer

Oracle RMAN Duplicate Database

Question 8

An application requires an Oracle Autonomous Database that supports complex analytical queries, reporting, and high-throughput data warehousing workloads. Which workload type should you select during provisioning?

Accepted Answer

Data Warehouse. Autonomous Data Warehouse (ADW) is optimized for data warehousing, complex analytical queries, and reporting workloads, whereas ATP is optimized for OLTP workloads.

Answer

JSON Database

Answer

APEX

Answer

Transaction Processing

Question 9

You are managing an Oracle Base Database System and need to patch the database home and operating system. Which utility is provided by Oracle in OCI to automate and orchestrate database patching safely?

Accepted Answer

OCI Database Management Service and Console Patching workflow. OCI provides built-in database management tools, specifically the OCI Console workflow and DBaaS CLI (dbaascli), to apply database and grid infrastructure patches.

Answer

Autonomous Patching Daemon (autopatchd)

Answer

Oracle Enterprise Manager Cloud Control Cloud Agent only

Answer

YUM Package Manager

Question 10

When connecting securely to an Autonomous Database instance, what file must be downloaded from the OCI Console and provided to your database client applications?

Accepted Answer

Client Credentials Wallet (wallet.zip). Autonomous Database requires mutual TLS (mTLS) authentication by default, which is established using credentials packaged in a Wallet zip file.

Answer

An SSH private key (.pem)

Answer

Oracle Wallet Manager Master Encryption Key

Answer

tnsnames.ora configuration text file only

Question 11

You have configured an Oracle Data Guard association between a primary Autonomous Database and a standby Autonomous Database. What happens to the standby database if the primary database experiences an unplanned regional outage?

Accepted Answer

You can perform a failover operation in the OCI Console to promote the standby database to primary.. In Autonomous Database Data Guard, if the primary goes down, you can manually initiate a role transition (switchover/failover) or rely on automatic failover depending on the configuration, promoting the standby to primary.

Answer

The standby database remains permanently read-only and cannot accept write transactions.

Answer

The standby database automatically destroys itself and reprovisions in the primary region.

Answer

Data Guard automatically switches back to the primary database via split-brain prevention algorithms.

Question 12

Which database edition is required when provisioning an Oracle Base Database System if you want to use advanced features like Oracle Multitenant (up to 3 PDBs without extra cost), Data Guard, and In-Memory?

Accepted Answer

Enterprise Edition (EE). Enterprise Edition (EE) or Enterprise Edition High Performance / Extreme Performance is required for advanced Oracle database features.

Answer

Personal Edition

Answer

Standard Edition 2 (SE2)

Answer

Express Edition (XE)

Question 13

You have an Oracle Exadata Database Service on Dedicated Infrastructure. You need to scale the storage server grid independently of the compute servers to accommodate a massive data ingestion project. How should you accomplish this?

Accepted Answer

Add additional storage servers (storage cells) to the Exadata infrastructure resource.. Exadata Database Service on Dedicated Infrastructure allows you to add storage servers (storage cells) independently of compute servers through the OCI console or APIs.

Answer

Migrate the database to a Bare Metal DB system with larger local NVMe drives.

Answer

Scale up the Exadata VM cluster shape by adding more OCPUs.

Answer

Attach OCI Block Storage volumes directly to the Exadata database nodes via iSCSI.

Question 14

You are managing an Autonomous Database instance on shared infrastructure and need to restrict database access so that only clients connecting from a specific Corporate CIDR block (e.g., 192.168.10.0/24) can connect. How should you implement this?

Accepted Answer

Configure an Access Control List (ACL) specifying the allowed IP CIDR block in the OCI Console.. Autonomous Database allows you to configure Access Control Lists (ACLs) using IP notations or Virtual Cloud Networks to restrict network access.

Answer

Modify the SQL*Net configuration file (sqlnet.ora) stored in the database home.

Answer

Deploy an OCI Web Application Firewall (WAF) policy in front of the database port.

Answer

Attach a VCN Security List directly to the Autonomous Database service endpoint IP.

Question 15

Which type of Oracle database deployment provides full administrative privileges (SYS and SYSTEM access) at the operating system and database level in OCI?

Accepted Answer

Oracle Base Database System (Virtual Machine or Bare Metal). Base Database Systems (VM and BM) provide full root access to the OS via SSH and full DBA privileges on the database.

Answer

Autonomous JSON Database

Answer

Oracle Autonomous Database

Answer

Oracle Database Serverless Cloud Service

Question 16

You are troubleshooting a slow-running query on an Exadata Cloud Service database. You suspect that smart scan is not being utilized by the storage cells. Which Exadata feature enables offloading SQL processing operations like filtering and projections directly to the storage servers?

Accepted Answer

Exadata Smart Scan (Storage Offload). Exadata Smart Scan (Storage Index and Offload processing) offloads database query processing tasks from the database compute nodes to the Exadata storage cells.

Answer

Oracle Database In-Memory Column Store

Answer

Hybrid Columnar Compression (HCC)

Answer

Automatic Storage Management (ASM) Mirroring

Question 17

You are configuring a Data Guard association for an Oracle Base Database System. You want to minimize performance impact on the primary database while ensuring zero data loss in the event of a failure. Which Data Guard protection mode should you configure?

Accepted Answer

Maximum Availability. Maximum Availability protection mode guarantees zero data loss (synchronous redo transport) while ensuring that if the standby is unavailable, the primary continues processing transactions asynchronously.

Answer

Maximum Performance

Answer

Maximum Protection

Answer

Maximum Throughput

Question 18

You need to back up an Oracle Base Database System to an external target or move database files manually using RMAN. Which OCI storage service is typically used as a staging area for manual RMAN backups?

Accepted Answer

OCI Object Storage. OCI Object Storage is used for storing RMAN backup sets when performing manual backups or database migrations.

Answer

OCI File Storage Service (FSS) NFS mount

Answer

OCI Block Volume service attached via iSCSI

Answer

Local NVMe scratch disks

Question 19

When provisioning an Autonomous Database, what parameter determines the initial compute and storage capacity allocated to the database, which can be scaled independently later?

Accepted Answer

OCPU count and Storage size in Terabytes. Autonomous Database compute is measured in OCPUs (Oracle CPUs), and storage is measured in terabytes (TB).

Answer

Block volume IOPS and Throughput MB/s

Answer

Number of database threads and PGA memory limits

Answer

RAM size in Gigabytes and CPU core clock speed

Question 20

You are planning disaster recovery for an Exadata Database Service on Dedicated Infrastructure. You need to configure Oracle Active Data Guard with real-time apply. What unique capability does Active Data Guard provide over standard Data Guard?wirtschaft

Accepted Answer

It allows read-only queries to run on the physical standby database while real-time redo apply is active.. Active Data Guard allows the physical standby database to be open for read-only queries while simultaneously applying redo received from the primary database in real time.

Answer

It replicates data at the block level across heterogeneous database engines (e.g., PostgreSQL to Oracle).

Answer

It automatically shards the primary database tables across multiple standby regions.

Answer

It allows read-write operations on the standby database while synchronizing with the primary.