1Z0-1072-26 Database Practice Test 5 — 15 Questions

Question 1

You are configuring security for an Oracle Base Database Service instance in a private subnet. Which OCI networking construct should you configure to allow the database to download software patches from Oracle Object Storage without traversing the public internet?

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

Accepted Answer

Service Gateway. A Service Gateway in OCI provides private access from a VCN to Oracle services like Object Storage, so the database can download patches without using the public internet or a NAT gateway. Traffic stays on the Oracle network backbone, satisfying the private-subnet requirement.

Answer

Internet Gateway

Answer

Local Peering Gateway

Answer

NAT Gateway

Question 2

When provisioning an Oracle Base Database Service DB system, which storage management software is used underneath to provide high performance and reliable storage volumes?

Accepted Answer

Oracle Automatic Storage Management (ASM). Oracle Base Database Service (formerly Bare Metal and VM DB Systems) uses Oracle Automatic Storage Management (ASM) as the underlying storage management software. ASM provides striping, mirroring, and rebalancing across available block volumes, delivering high performance and reliability for the database files.

Answer

ZFS Storage Appliance software

Answer

EXT4 journaling file system

Answer

Linux Logical Volume Manager (LVM)

Question 3

Which feature of Autonomous Database allows you to create a point-in-time read-only or read-write copy of your database instantly without duplicating all the underlying physical data blocks?

Accepted Answer

Database Cloning. Database Cloning in Autonomous Database creates a point-in-time copy of the database using copy-on-write technology, so it does not physically duplicate all underlying data blocks at creation time. The clone is immediately available as read-only or read-write, depending on the option chosen.

Answer

Database backup and restore

Answer

Manual RMAN duplicate command

Answer

Data Pump Export and Import

Question 4

Which THREE statements are true regarding Exadata Cloud Service architecture and capabilities? (Choose three.)

Accepted Answer

It combines Oracle Database software with Exadata database servers and storage servers in OCI.. Option A is correct because Exadata Cloud Service (ExaCS) in OCI is precisely the combination of Oracle Database software running on dedicated Exadata database servers and Exadata storage servers within Oracle Cloud Infrastructure. Option B is correct because Exadata storage is presented to the database through Oracle Automatic Storage Management (ASM), which stripes and mirrors data across the Exadata Smart Flash Cache and high-performance disk storage to deliver the platform's characteristic performance and redundancy. Option C is correct because a single Exadata infrastructure rack in OCI can host multiple VM clusters, each running its own Grid Infrastructure and databases, allowing consolidation and isolation on shared Exadata hardware. Option D is not correct because ExaCS fully supports Oracle Real Application Clusters (RAC) for high availability and scalability. Option E is not correct because ExaCS supports both RAC and single-instance databases, and high availability is a core capability rather than something absent.

Answer

It does not support Oracle Real Application Clusters (RAC).

Answer

It only supports single-instance databases with no option for high availability.

Question 5

Which TWO deployment options are available when provisioning an Oracle Autonomous Database? (Choose two.)

Accepted Answer

Shared Exadata Infrastructure. Option A (Shared Exadata Infrastructure) is correct because Oracle Autonomous Database can be provisioned on shared Exadata infrastructure, where the underlying Exadata hardware and Exadata Storage Server software are managed by Oracle and shared across multiple tenants while each database remains isolated. Option D (Dedicated Exadata Infrastructure) is also correct because Autonomous Database supports a dedicated deployment model in which the Exadata infrastructure is single-tenant and provisioned exclusively for one customer, typically via Oracle Exadata Cloud@Customer or dedicated region capacity. Option B is incorrect because Autonomous Database is an Oracle-managed cloud service and is not deployed on customer local on-premises hypervisor virtual machines. Option C is incorrect because OCI Block Volume multi-attach storage clusters are not a supported deployment substrate for Autonomous Database; the service runs on Exadata infrastructure. Option E is incorrect because Autonomous Database is built on Exadata infrastructure, so a bare metal single-tenant instance without Exadata infrastructure is not an available deployment option.

Answer

Local on-premises hypervisor virtual machines

Answer

Standard OCI Block Volume multi-attach storage clusters

Answer

Bare metal single-tenant instances without Exadata infrastructure

Question 6

Which TWO tasks can an administrator perform when managing database homes in Oracle Base Database Service? (Choose two.)

Accepted Answer

Apply Database Updates (Database Software Patches) to the DB home.. Option A is correct because Oracle Base Database Service allows administrators to apply database updates (database software patches) to a DB home, which patches the Oracle Database software binaries in that home. Option E is correct because a single DB home can host multiple databases as long as they all run the same Oracle Database software version, since the home provides one set of binaries. Option B is wrong because customers cannot modify the hypervisor's physical CPU hardware model in this managed service. Option C is wrong because deleting a DB home requires or removes its associated databases; they cannot all keep running unaffected. Option D is wrong because a DB home cannot be converted into an Autonomous Container Database, which is a separate Autonomous Database construct.

Answer

Modify the underlying physical CPU hardware model of the hypervisor.

Answer

Delete the DB home while keeping all associated databases running unaffected.

Answer

Convert the database home into an Autonomous Container Database.

Question 7

Which THREE security features are enabled by default or configurable on an Oracle Autonomous Database? (Choose three.)

Accepted Answer

Network Access Control Lists (ACLs) and private endpoints to restrict IP connectivity. Option A is correct because Oracle Autonomous Database supports network ACLs and private endpoints (via Oracle Cloud Infrastructure VCN and private endpoint configuration) to restrict IP connectivity and keep traffic off the public internet. Option B is correct because Oracle autonomously applies mandatory security patches and vulnerability updates to the database and underlying infrastructure, removing that burden from the customer. Option C is correct because Transparent Data Encryption (TDE) is enabled by default on Autonomous Database, encrypting all user data at rest with Oracle-managed keys (with customer-managed keys optionally configurable). Option D is not correct because customers do not manually manage OS root access on Autonomous Database; Oracle manages the operating system and infrastructure. Option E is not correct because disabling all network security controls to allow unrestricted global access is the opposite of the platform's secure-by-default posture and is not a supported security feature.

Answer

Manual customer management of operating system root access permissions

Answer

Disabling all network security controls to allow unrestricted global access

Question 8

You are managing an Oracle Base Database System (DB System) on OCI and need to minimize downtime during a planned operating system patching cycle. Which action should you perform to achieve this for a 2-node RAC DB System?

Accepted Answer

Perform a rolling patch on one node at a time using the OCI console or CLI.. For a 2-node RAC DB System on OCI, a rolling patch applies the OS update to one node at a time while the other node continues serving database traffic, so the RAC cluster maintains availability throughout the patching cycle. The OCI console and CLI expose this as a patching option that orchestrates the node-by-node sequence and waits for each node to rejoin the cluster before proceeding. This is the standard, supported method to minimize downtime for planned OS maintenance on multi-node RAC systems.

Answer

Apply the patch simultaneously to both nodes to ensure the cluster remains synchronized.

Answer

Take a full manual backup, terminate the DB System, and reprovision with the new patched image.

Answer

Convert the 2-node RAC to a Single Instance database, patch it, and convert it back.

Question 9

Which type of Oracle Cloud Infrastructure Database service provides full access to Oracle Database features and root access to the underlying database operating system, while OCI manages the physical hardware and hypervisor?

Accepted Answer

Base Database. Oracle Base Database Service (Base DB) provides full access to Oracle Database features and gives you root access to the underlying database operating system, while OCI manages the physical hardware and hypervisor. This distinguishes it from Autonomous Database, which abstracts OS access entirely. Thus, Base Database is the correct answer.

Answer

Autonomous JSON Database

Answer

Autonomous Database

Answer

NoSQL Database

Question 10

An application running on OCI requires an Autonomous Transaction Processing (ATP) database with the ability to automatically scale compute resources up and down based on workload demand, without manual intervention. Which feature should you enable during or after database provisioning?

Accepted Answer

Auto Scaling. Auto Scaling is the Autonomous Database feature that automatically scales compute resources up and down based on workload demand without manual intervention. It is enabled during or after provisioning and adjusts the number of OCPUs within the defined base and maximum limits.

Answer

Dynamic Scaling Policy

Answer

Compute Autoscaling Groups

Answer

Elastic Resource Pools

Question 11

You are planning a Disaster Recovery strategy for an Oracle Base Database System using Oracle Data Guard on OCI. You need the standby database to be open in read-only mode for reporting queries while simultaneously applying redo data from the primary database. Which Data Guard mode should you configure?

Accepted Answer

Active Data Guard. Active Data Guard enables physical standby databases to be open for read-only queries while performing real-time apply of redo from the primary database.

Answer

Snapshot Standby

Answer

Logical Standby in read-write mode

Answer

Traditional Physical Standby (Mount mode)

Question 12

Which TWO actions can be performed on an OCI Autonomous Database to manage or alter its compute and storage configurations after initial provisioning? (Choose two.)

Accepted Answer

Scale up or down the number of OCPUs without downtime.. Option B is correct because OCI Autonomous Database supports online scaling of OCPUs (the ECPU/OCPU compute count) through the OCI Console, CLI, or API, and this scaling operation is performed without downtime while the database remains available. Option E is correct because Autonomous Database storage can be increased online in terabyte increments without interrupting database operations, allowing capacity growth as data volumes increase. Options A, C, and D are incorrect because Autonomous Database is a fully managed service: customers have no access to the underlying cluster nodes, cannot manually configure Oracle Grid Infrastructure clusterware, cannot attach raw OS mount points or repartition tablespaces at the OS level, and cannot modify kernel parameters with root privileges—Oracle handles all infrastructure and OS administration.

Answer

Manually configure Oracle Grid Infrastructure clusterware parameters on the underlying cluster nodes.

Answer

Manually repartition tablespaces using raw OS mount points attached to the DB node.

Answer

Modify the operating system kernel parameters using root user privileges.

Question 13

You are migrating an on-premises Oracle database to an OCI Autonomous Database using Oracle Data Pump. Which wallet-related file must be downloaded and used by the client utility to establish a secure connection to the Autonomous Database?

Accepted Answer

Database Connection Wallet (Credentials zip file). To connect a client utility such as Oracle Data Pump to an Autonomous Database, you must download the Database Connection Wallet (Credentials zip file) from the OCI Console. This wallet contains the tnsnames.ora, sqlnet.ora, and keystore files needed to establish a secure TLS connection to the Autonomous Database. The client references the wallet directory via the TNS_ADMIN environment variable or connection string.

Answer

OS-level password shadow file

Answer

Public SSH Key pair

Answer

Keystore and ciphers configuration file

Question 14

Which THREE features are provided natively by Exadata Cloud Service to deliver high performance and high availability for Oracle databases? (Choose three.)

Accepted Answer

Oracle Real Application Clusters (RAC) support for database high availability.. Option B is correct because Exadata Cloud Service natively runs Oracle Real Application Clusters (RAC), allowing multiple database instances on separate database nodes to access shared storage, which delivers high availability through instance failover and transparent application continuity. Option C is correct because Exadata Smart Scan is a core Exadata storage-server feature that pushes SQL predicate filtering and column projection down to the cells, reducing data transferred to the database nodes and dramatically improving query performance for analytics and large scans. Option D is correct because Exadata systems use an RDMA over Converged Ethernet (RoCE) network fabric for the internal cluster interconnect between database and storage servers, providing the ultra-low latency and high bandwidth required for RAC cache fusion and Smart Scan traffic. Option A is not provided natively by Exadata Cloud Service, since Exadata runs Oracle Database and does not translate PL/SQL into AWS Redshift SQL. Option E is not provided because Exadata Cloud Service is a managed service where Oracle, not the client, handles hypervisor and infrastructure patching; customers do not get direct SSH access to Dom0.

Answer

Automatic translation of PL/SQL code into native AWS Redshift SQL syntax.

Answer

Client-managed hypervisor patching via direct SSH access to Dom0 dom0 hypervisor nodes.

Question 15

You are managing an Oracle Base Database Service DB system on OCI. The DB system hosts a production database, and you must configure Oracle Data Guard so the standby database can take over automatically with no data loss. The primary and standby must be in different availability domains of the same region, and you want to minimize manual intervention during a switchover. Which TWO configuration choices should you make? (Choose two.)

Accepted Answer

Configure a Data Guard association using the OCI Console or CLI, which creates the standby and broker configuration automatically.. Automatic, zero-data-loss takeover in a single region is achieved by pairing Maximum Availability protection with SYNC transport and by letting OCI create and manage the Data Guard association. The managed association provisions the standby in the required availability domain and configures the broker, while Maximum Availability with SYNC ensures every committed transaction exists on the standby before the primary acknowledges it, so a switchover or failover loses nothing.

Answer

Manually build the standby with RMAN duplicate and register it in the broker without an OCI Data Guard association.

Answer

Set the Data Guard protection mode to Maximum Performance with ASYNC transport.

Answer

Place the standby in a different region and rely on cross-region redo transport for the no-data-loss guarantee.