1Z0-1072-26 Database — Timed 10 Questions

Question 1

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?

10 minute time limit — choose an answer to begin.

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 2

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. Oracle Cloud Infrastructure (OCI) provides built-in workflows in the OCI Console and the command-line utility `dbaascli` to manage, patch, and upgrade database homes and operating systems on Oracle Base Database Systems.

Answer

Autonomous Patching Daemon (autopatchd)

Answer

Oracle Enterprise Manager Cloud Control Cloud Agent only

Answer

YUM Package Manager

Question 3

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 mode provides the highest level of data protection that is possible without compromising the availability of the primary database. It uses synchronous redo transport (SYNC) to ensure zero data loss, but if the standby becomes unavailable, the primary will continue to process transactions (unlike Maximum Protection, which would shut down).

Answer

Maximum Performance

Answer

Maximum Protection

Answer

Maximum Throughput

Question 4

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 the standard staging area for manual RMAN backups of Oracle Base Database Systems because it provides scalable, durable, and cost-effective object storage accessible via the internet or private endpoints. RMAN can back up directly to Object Storage using the Oracle Database Cloud Backup Module, which integrates with the S3-compatible API. This allows DBAs to move backup files off the database system and later restore or transfer them as needed, without provisioning block or file storage.

Answer

OCI File Storage Service (FSS) NFS mount

Answer

OCI Block Volume service attached via iSCSI

Answer

Local NVMe scratch disks

Question 5

Which feature of Oracle Autonomous Database automatically inspects and tunes SQL statements, creates indexes, and optimizes execution plans without human intervention?

Accepted Answer

Automatic Indexing and SQL Tuning Advisor. Oracle Autonomous Database features self-tuning capabilities that include automatic indexing, which automatically creates, rebuilds, and drops indexes based on workload, alongside automatic SQL tuning to optimize execution plans.

Answer

Oracle Enterprise Manager Tuning Pack

Answer

Database Resource Manager

Answer

Automatic Storage Management (ASM)

Question 6

You are configuring a Data Guard association for an Autonomous Database on Dedicated Infrastructure. How is the Data Guard standby database provisioned and managed?

Accepted Answer

You enable Data Guard through the OCI Console, and OCI automatically provisions and manages the standby database.. On Dedicated Exadata Infrastructure, Autonomous Data Guard is enabled via the OCI Console or API by selecting the peer region, and OCI automates the provisioning and synchronization of the standby.

Answer

You must manually configure Oracle Net listener files and run 'DGMGRL' commands from the OS command line.

Answer

You must back up the database to Object Storage and restore it manually as a standby in the target region.

Answer

Data Guard is not supported on Autonomous Database Dedicated; you must use GoldenGate instead.

Question 7

Which TWO methods can be used to connect to an Autonomous Database securely from an on-premises application server?

Accepted Answer

Using a downloaded client credentials wallet (mTLS connection). Option A is correct because Autonomous Database supports mutual TLS (mTLS) connections, where the application server downloads a client credentials wallet (containing the ewallet.pem, tnsnames.ora, and sqlnet.ora files) and uses it to authenticate and encrypt the connection to the database's public endpoint. Option E is correct because when a private endpoint is configured, clients can connect using one-way TLS authentication with just the private endpoint hostname and a valid TLS certificate, without needing a wallet, since the network path is already private and mTLS is not mandatory in that configuration. Option B is incorrect because SSH tunneling through a database control plane is not a supported or documented connection method for Autonomous Database. Option C is incorrect because Telnet is unencrypted and port 1521 requires TLS/mTLS, not plaintext Telnet access. Option D is incorrect because anonymous FTP is not a database connection method and is not supported for accessing an Autonomous Database.

Answer

Direct SSH tunneling through the database control plane

Answer

Unencrypted Telnet connection over port 1521

Answer

Anonymous FTP file transfer into the database home

Question 8

Which THREE actions occur during a Data Guard switchover operation for an Oracle Base Database System?

Accepted Answer

The standby database is promoted to the primary role.. Option A is correct because a switchover promotes the standby database to the primary role, allowing it to accept read/write transactions after the transition completes. Option D is correct because the original primary is converted into a standby database, reversing the roles of the two systems in the Data Guard configuration. Option E is correct because a switchover is a graceful, planned operation that ensures zero data loss by transmitting and applying all redo (including committed transactions) before the role reversal, so no committed data is lost. Option B is incorrect because switchover does not delete database files from the original primary server; those files remain and are used when the former primary becomes a standby. Option C is incorrect because VCN peering is a network configuration independent of Data Guard role transitions and is not automatically deleted during a switchover.

Answer

The database files are permanently deleted from the original primary server.

Answer

The Virtual Cloud Network (VCN) peering connection is automatically deleted.

Question 9

You need to deploy a traditional Oracle Database on OCI where you have complete administrative root access to the underlying operating system and database server. Which Oracle Database service should you choose?

Accepted Answer

Oracle Base Database Service. Oracle Base Database Service (formerly Bare Metal/VM DB Systems) provides full OS-level root access via SSH along with SYSDBA access to the database, allowing complete administrative control. It is the only OCI database offering that grants this traditional DBA/OS-admin model while still being an Oracle-managed service. Autonomous Database and Exadata Cloud Service with Autonomous Container Databases abstract away OS access entirely.

Answer

OCI NoSQL Database

Answer

Exadata Cloud Service with Autonomous Container Databases

Answer

Oracle Autonomous Database

Question 10

You are provisioning an Exadata Database Service on Dedicated Infrastructure and need to choose a shape that supports high performance workloads. Which option represents a valid Exadata shape family available in OCI?

Accepted Answer

Exadata.X9M.Quarter3. Exadata Database Service on Dedicated Infrastructure uses specific Exadata rack shapes, such as Exadata.X9M.Quarter, Exadata.X9M.Half, or Exadata.X9M.Full. Option C is the only valid Exadata shape structure among the choices.

Answer

Exadata.X9M.8

Answer

BM.GPU.DenseIO2.8

Answer

VM.Standard2.4