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

Question 1

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?

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

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 2

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 3

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 4

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 5

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.

Question 6

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. Autonomous Database includes built-in automated SQL tuning and indexing capabilities as part of its self-tuning architecture.

Answer

Oracle Enterprise Manager Tuning Pack

Answer

Database Resource Manager

Answer

Automatic Storage Management (ASM)

Question 7

You are managing an Oracle Base Database System and need to secure data at rest by using your own encryption keys rather than Oracle-managed keys. Which OCI service must you integrate with the database?

Accepted Answer

OCI Vault (Key Management Service). Customer-managed encryption keys for Oracle databases in OCI are managed using OCI Vault (Key Management Service).

Answer

Oracle Cloud Guard

Answer

Identity and Access Management (IAM) Policies

Answer

OCI Object Storage Server-Side Encryption

Question 8

You are scaling up an Oracle Base Database System (VM) to add more storage to your existing database data disk group (+DATA). What is the correct procedure in the OCI Console?

Accepted Answer

Edit the DB system storage size in the OCI Console to allocate more storage.. For Base DB systems, you can increase the storage size directly in the OCI Console, and ASM automatically recognizes and resizes the disk groups.

Answer

Terminate the DB system, create a larger block volume, and attach it as root.

Answer

Create a clone of the database to a new shape with higher storage limits.

Answer

Log into the OS via SSH, format a new iSCSI disk, and manually add it to the ASM disk group using SQL*Plus.

Question 9

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 10

You are managing an Oracle Base Database System and need to configure automated backups to retain backups for a custom period (e.g., 60 days). Where can you configure this retention period?

Accepted Answer

In the DB system backup configuration settings within the OCI Console. In OCI Base Database Systems, you can configure automated backup retention and backup windows during creation or by editing the backup configuration in the OCI Console.

Answer

By modifying retention rules on Object Storage lifecycle policies

Answer

Backup retention is fixed at 30 days and cannot be modified.

Answer

By editing the 'init.ora' parameter file using SQL*Plus

Question 11

What is the primary benefit of using Oracle Autonomous Database's autoscaling feature for CPU and storage?

Accepted Answer

It automatically increases OCPU or storage capacity when workload spikes, and scales down when demand drops.. Autoscaling allows the database to automatically allocate additional CPU or storage resources when workload demands increase, without manual intervention.

Answer

It automatically pauses billing when the database is idle for more than one hour.

Answer

It automatically converts your database from Transaction Processing to Data Warehouse workloads.

Answer

It automatically migrates the database to a different cloud region during high load.

Question 12

Which THREE operations can be performed on an Oracle Base Database System from the OCI Console?

Accepted Answer

Scale storage size. From the OCI Console, you can scale storage, patch database homes, and create manual backups.

Answer

Modify the operating system kernel source code

Answer

Directly modify Oracle internal data dictionary tables

Question 13

You are designing a high availability architecture for a mission-critical Oracle Exadata Database Service. You need to ensure zero data loss and minimal downtime during planned hardware maintenance. Which Oracle feature should you leverage?

Accepted Answer

Rolling infrastructure maintenance combined with Real Application Clusters (RAC) and Data Guard. Exadata infrastructure maintenance is coordinated with Oracle Data Guard switchover or RAC rolling maintenance to ensure continuous application availability.

Answer

Manual database export using Data Pump during the maintenance window

Answer

OCI Load Balancer health checks with DNS failover

Answer

Cold backups taken right before maintenance window execution

Question 14

Which THREE features are automatically managed by Oracle Autonomous Database without requiring manual DBA intervention?

Accepted Answer

Performance tuning and indexing. Autonomous Database automates patching, backups, and performance tuning.

Answer

Business requirement definition and data modeling

Answer

Custom corporate application code development

Question 15

Which TWO characteristics distinguish Exadata Cloud Service (ExaCS) from standard Oracle Base Database Systems?

Accepted Answer

Support for Hybrid Columnar Compression (HCC). ExaCS features specialized Exadata storage servers with Smart Scan and supports Hybrid Columnar Compression, unlike standard Base DB systems.

Answer

Requirement to run exclusively on Windows Server operating systems

Answer

Exclusive reliance on standard OCI Block Volume iSCSI storage

Answer

Inability to use Oracle Real Application Clusters (RAC)