1Z0-1072-26 Database — Timed 25 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?

25 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

Question 11

A DBA needs to configure automatic backups for an Oracle Base Database Service instance. Which retention period range is natively supported for automated backups?

Accepted Answer

7 days to 60 days. Oracle Base Database Service automated backups support a retention period ranging from 7 days to 60 days. This is configured when setting up the backup policy and can be adjusted within that range. The retention determines how long backup copies are kept before being purged.

Answer

30 days to 365 days

Answer

1 day to 14 days

Answer

1 hour to 24 hours

Question 12

Which THREE features are supported by Oracle Base Database Service on virtual machines? (Choose three.)

Accepted Answer

Automated daily and weekly backups to OCI Object Storage. Option A is correct because Oracle Base Database Service on VMs provides automated backups (daily incremental and weekly full) that are stored in OCI Object Storage, with configurable retention policies. Option C is correct because the VM-based offering grants customers full root (sudo) access to the underlying compute instances, unlike the autonomous or Exadata-based services. Option D is correct because Oracle Data Guard is supported on Base Database Service VMs, allowing you to configure a standby database for high availability and disaster recovery. Option B is incorrect because automatic zero-downtime shard migration across tenants is a feature of Oracle Sharding in Autonomous Database, not Base Database Service on VMs. Option E is incorrect because physical hardware rack scaling is not an automated feature of this service; scaling is handled by OCI's infrastructure and is not exposed as an automatic capability of the database service.

Answer

Automatic zero-downtime shard migration across tenants

Answer

Automatic scaling of physical server hardware racks

Question 13

Which TWO methods can be used to connect securely to an Autonomous Database instance? (Choose two.)

Accepted Answer

TLS authentication without a wallet when using private endpoints configured with a keystore. Option B is correct because Autonomous Database natively supports Mutual TLS (mTLS) authentication, where the client presents a downloaded credentials wallet (containing the client certificate and private key) to establish an encrypted, mutually authenticated connection to the database. Option A is correct because when an Autonomous Database is configured with a private endpoint and a keystore, TLS authentication can be performed without requiring the client to use a downloaded wallet, since the server-side keystore handles the TLS handshake and authentication. Option C is incorrect because Autonomous Database never accepts unencrypted plain text TCP/IP connections on port 1521; all traffic must be encrypted with TLS. Option D is incorrect because unauthenticated HTTP REST calls without authorization headers are rejected—REST access requires proper authentication (e.g., bearer token or wallet-based mTLS). Option E is incorrect because direct SSH tunneling through port 22 is not a supported connection method for Autonomous Database, as SSH access to the underlying infrastructure is not provided.

Answer

Unencrypted plain text TCP/IP sockets on port 1521

Answer

Direct unauthenticated HTTP REST calls without authorization headers

Answer

Direct SSH tunneling through port 22 without database credentials

Question 14

Which TWO actions can be performed on an Oracle Autonomous Transaction Processing database using the OCI Console? (Choose two.)

Accepted Answer

Scale up or down the number of OCPUs and storage capacity.. The OCI Console allows users to manage Autonomous Database resources, including scaling OCPUs and storage (Option A) and downloading the required client credentials wallet for secure connectivity (Option D). Options B, C, and E are incorrect because Autonomous Database is a fully managed service where the underlying OS, kernel, and redo log configurations are abstracted and managed by Oracle, preventing user-level access.

Answer

Manually configure custom standby redo log files using SQL*Plus.

Answer

Directly access the database server via SSH using root privileges.

Answer

Modify the underlying Linux operating system kernel parameters.

Question 15

When configuring database backups in Oracle Base Database Service, which THREE components or options can be managed or customized? (Choose three.)

Accepted Answer

Automated backup retention period between 7 and 60 days. Option A is correct because Oracle Base Database Service lets you configure the automated backup retention period within a range of 7 to 60 days, controlling how long recovery points are preserved. Option C is correct because you can set the backup window that determines when the daily automated backup job starts, allowing scheduling around peak workloads. Option D is correct because you can run on-demand manual backups (full or incremental) that are stored in Oracle Object Storage, giving additional recovery points beyond the automated schedule. Option B is not a supported behavior, as backups are not automatically deleted immediately upon database shutdown. Option E is not supported because Base Database Service does not directly replicate backup files to customer local tape drives.

Answer

Automatic deletion of backup files immediately after database shutdown

Answer

Direct replication of backup files to local customer tape drives

Question 16

You are configuring backups for an Oracle Base Database System on OCI. You want to store automated full backups and incremental backups to OCI Object Storage. What is the default retention period you can select for automated backups when using the console?

Accepted Answer

Configurable retention periods such as 7, 15, 30, 45, or 60 days. When configuring automated backups for an Oracle Base Database System on OCI via the console, you can select from configurable retention periods such as 7, 15, 30, 45, or 60 days. This flexibility allows you to meet compliance and recovery requirements. The default retention is typically 30 days, but you can adjust it within these predefined options.

Answer

Up to 7 days only

Answer

Real-time streaming backups with no retention limits

Answer

Exactly 365 days fixed

Question 17

When provisioning an Exadata Database Service on Dedicated Infrastructure, what is the fundamental hardware unit that you provision first before creating database deployments?

Accepted Answer

Exadata Infrastructure (Rack). In the OCI console and documentation for Exadata Database Service on Dedicated Infrastructure, the resource is referred to as 'Exadata Infrastructure', not 'Exadata Infrastructure (Rack)'.

Answer

Individual DB System node

Answer

Autonomous Data Warehouse instance

Answer

Autonomous Container Database

Question 18

When configuring automated backups for an Oracle Base Database System on OCI, which THREE options or parameters can you configure or customize? (Choose three.)

Accepted Answer

Backup window (the 2-hour daily timeframe when automated backups start). In OCI Base Database Service, automated backups are configured through the console or API, where you can set the backup window (A), a 2-hour daily timeframe during which the automated backup job starts, allowing you to align backups with low-activity periods. You can also configure the backup retention period (C), choosing how long backups are kept (for example, 7 to 60 days) to meet recovery and compliance requirements. The backup destination (D) is configurable as an OCI Object Storage bucket, where the automated backups are stored and from which they can be restored. Options B and E are not valid configuration parameters: custom RMAN compression shell scripts run via cron are not part of the managed automated backup configuration, and manual kernel-level edits to checksum/encryption algorithms are neither supported nor exposed as a backup setting.

Answer

Custom RMAN compression scripts written in shell script format executed via cron.

Answer

Manual physical block-level checksum encryption algorithms via direct OS kernel edits.

Question 19

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?

Accepted Answer

Oracle Recovery Manager (RMAN). Oracle Recovery Manager (RMAN) is the Oracle-native tool for performing point-in-time recovery using incremental backups and archived redo logs. It is the only tool listed that can apply incremental backups and redo logs to roll a database forward to a specific SCN or timestamp.

Answer

Data Pump (impdp)

Answer

OCI Block Storage Volume Snapshots

Answer

SQL*Loader

Question 20

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 an Oracle Base Database System (VM), you can scale the compute shape by editing the DB system configuration in the OCI Console, which allows you to change the OCPU count or select a different shape. This operation can be performed online or may require a brief restart depending on the change, but it does not require terminating and recreating the system.

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.