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

Question 1

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?

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

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 2

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 3

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 4

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 5

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.

Question 6

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 (ExaCS), tenant isolation at the hypervisor level is provided by Oracle VM or KVM guest virtualization (domU). Each customer's database infrastructure runs in isolated virtual machines (domU) on the Exadata hardware, managed by a hypervisor (dom0). This ensures that tenants are separated at the virtualization layer, preventing cross-tenant access.

Answer

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

Answer

Storage Server Cell software zones

Answer

Exadata Database Vault compartment boundaries

Question 7

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 8

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. By default, OCI stores automated backups of an Oracle Base Database System in an Oracle-managed Object Storage bucket. This bucket is provisioned and managed by Oracle, and customers do not need to configure FSS, local disk, or block volumes for default automated backups. The backups are retained according to the configured retention policy and can be restored via the Console or CLI.

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 9

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 10

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. The Data Warehouse workload type is optimized for complex analytical queries, reporting, and high-throughput data warehousing. It uses columnar storage, parallel execution, and other optimizations specifically for analytical workloads.

Answer

JSON Database

Answer

APEX

Answer

Transaction Processing

Question 11

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). To connect securely to an Autonomous Database, you must download the Client Credentials Wallet (wallet.zip) from the OCI Console. This wallet contains the credentials and network configuration files (including tnsnames.ora, sqlnet.ora, and cwallet.sso) needed for secure TLS connections. It is required for both JDBC and other client connections.

Answer

An SSH private key (.pem)

Answer

Oracle Wallet Manager Master Encryption Key

Answer

tnsnames.ora configuration text file only

Question 12

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.. When the primary Autonomous Database experiences an unplanned regional outage, you can perform a failover operation in the OCI Console to promote the standby Autonomous Database to primary. This is the documented Data Guard failover workflow for Autonomous Database, allowing business continuity across regions. The standby does not automatically promote itself; an explicit failover action is required.

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 13

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). Oracle Base Database System (Base DB) requires Enterprise Edition (EE) to unlock advanced features such as Oracle Multitenant (with up to 3 PDBs included at no extra cost), Active Data Guard, and Database In-Memory. EE is the only edition that licenses these options; SE2 and lower editions either lack them entirely or require costly add-ons. This makes EE the correct choice for any deployment needing Multitenant, Data Guard, and In-Memory together.

Answer

Personal Edition

Answer

Standard Edition 2 (SE2)

Answer

Express Edition (XE)

Question 14

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 independent scaling of storage servers and compute servers. To increase storage capacity and IOPS independently, you add storage cells to the Exadata infrastructure resource, which expands the ASM disk group without changing the compute node count.

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 15

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.