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

Question 1

Which type of Oracle database deployment provides full administrative privileges (SYS and SYSTEM access) at the operating system and database level in OCI?

Accepted Answer

Oracle Base Database System (Virtual Machine or Bare Metal). Oracle Base Database System (also called Base Database Service) runs on a dedicated VM or Bare Metal shape and gives the customer full OS-level and database-level administrative control, including SYS/SYSTEM access and root/sudo on the host. This is the only OCI database deployment among the options that provides that level of privileged access. Autonomous Database variants deliberately restrict OS and SYSDBA-level access to preserve their self-managing model.

Answer

Autonomous JSON Database

Answer

Oracle Autonomous Database

Answer

Oracle Database Serverless Cloud Service

Question 2

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?

Accepted Answer

Exadata Smart Scan (Storage Offload). Exadata Smart Scan is the storage-offload feature that pushes predicate filtering, column projection, and certain joins down to the Exadata storage cells, so only relevant rows and columns return to the database nodes. This dramatically reduces I/O and CPU load on the compute tier, which is why a query that fails to offload runs noticeably slower.

Answer

Oracle Database In-Memory Column Store

Answer

Hybrid Columnar Compression (HCC)

Answer

Automatic Storage Management (ASM) Mirroring

Question 3

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. When provisioning an Autonomous Database, the two primary capacity parameters are the number of OCPUs (compute) and the storage size in terabytes. These are set at creation and can be scaled independently afterward — compute can be scaled up or down without downtime, and storage can be increased online. This decoupling is a core ADB design feature, so OCPU count and storage size in TB is the correct answer.

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 4

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.. Oracle Active Data Guard extends standard Data Guard by allowing the physical standby database to be open in read-only mode while redo apply (including real-time apply) continues. This means reporting, ad-hoc queries, and read-only workloads can be offloaded to the standby without interrupting the apply process. Standard Data Guard requires the standby to be mounted (not open) for redo apply, so it cannot serve queries. Active Data Guard thus provides both disaster recovery and read scalability from the same standby.

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 5

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). To use customer-managed encryption keys for data at rest on an Oracle Base Database System, you must integrate with OCI Vault (Key Management Service). OCI Vault stores and manages the master encryption keys, and the database uses them to encrypt datafiles, backups, and other storage. This satisfies compliance requirements that mandate customer-controlled keys rather than Oracle-managed keys.

Answer

Oracle Cloud Guard

Answer

Identity and Access Management (IAM) Policies

Answer

OCI Object Storage Server-Side Encryption

Question 6

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 an Oracle Base Database System (VM), storage can be scaled up by editing the DB system's storage size directly in the OCI Console, which expands the underlying ASM disk group (+DATA) without requiring a rebuild. OCI handles the block volume expansion and ASM rebalancing automatically. This is the supported, non-disruptive scaling path for adding storage to an existing DB system.

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 7

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. For Oracle Base Database Service (DB Systems) on OCI, the backup retention period is configured directly in the DB system's backup configuration settings in the OCI Console (or via CLI/SDK). You can set a custom retention period (e.g., 60 days) when enabling automatic backups, and this value is stored as part of the DB system's backup policy. This is a native OCI-level configuration, not something managed through Object Storage lifecycle rules or database initialization parameters.

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 8

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 in Autonomous Database automatically increases OCPU count (up to 3x the base) when CPU utilization is high and scales back down when demand drops, without manual intervention. This provides performance elasticity for variable workloads while controlling cost.

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 9

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

Accepted Answer

Scale storage size. Option B (Scale storage size) is correct because the OCI Console for Oracle Base Database Service lets you scale the storage of the DB system, increasing the usable data storage capacity allocated to the database. Option D (Create manual backups) is correct because the console provides backup management where you can create on-demand (manual) backups of the database in addition to configuring automatic backups. Option E (Apply database and grid infrastructure patches) is correct because the console exposes patching operations that apply database and Grid Infrastructure patches to the DB system. Option A is not a supported operation since customers cannot modify the operating system kernel source code of the managed DB system, and Option C is not allowed because direct modification of Oracle internal data dictionary tables is unsupported and would corrupt the database.

Answer

Modify the operating system kernel source code

Answer

Directly modify Oracle internal data dictionary tables

Question 10

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. Rolling infrastructure maintenance combined with RAC and Data Guard provides zero data loss and minimal downtime: RAC allows one node to remain available while another is patched, and Data Guard synchronizes a standby database for failover protection. Together they enable maintenance to proceed without taking the entire database offline. This is the standard Oracle-recommended approach for mission-critical Exadata deployments.

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 11

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

Accepted Answer

Performance tuning and indexing. Option B (Performance tuning and indexing) is correct because Oracle Autonomous Database uses automatic indexing and built-in performance tuning features such as Automatic SQL Tuning and SQL plan management to optimize workloads without DBA intervention. Option C (Automated backups) is correct because Autonomous Database automatically configures and performs backups, including retention and recovery capabilities, without manual scheduling. Option D (Database patching and upgrades) is correct because Autonomous Database automatically applies patches and performs upgrades during maintenance windows, minimizing manual DBA effort. Option A is not correct because defining business requirements and designing data models are human design activities, not database self-management features. Option E is not correct because developing custom corporate application code is performed by developers and is outside the scope of Autonomous Database automation.

Answer

Business requirement definition and data modeling

Answer

Custom corporate application code development

Question 12

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

Accepted Answer

Support for Hybrid Columnar Compression (HCC). Option C is correct because Exadata Cloud Service runs on Exadata engineered systems, whose storage servers and database nodes support Hybrid Columnar Compression (HCC) for both OLTP and data warehousing workloads, whereas standard Oracle Base Database Systems on OCI use regular block storage that does not provide the same Exadata-optimized HCC capabilities. Option D is correct because ExaCS includes Exadata intelligent storage servers that offload SQL processing via Smart Scan, a feature unique to the Exadata architecture that is not available in standard Oracle Base Database Systems. Options A, B, and E are incorrect: ExaCS does not require Windows Server (it runs Oracle Linux), it does not rely solely on standard OCI Block Volume iSCSI storage (it uses Exadata's internal storage servers), and it fully supports Oracle Real Application Clusters (RAC), which is in fact a core capability of Exadata deployments.

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)

Question 13

Which TWO of the following are valid deployment models for Oracle Autonomous Database in OCI?

Accepted Answer

Autonomous Database on Shared Infrastructure. Option C, Autonomous Database on Shared Infrastructure, is correct because Oracle offers ADB in a shared (serverless) deployment model where the Exadata infrastructure and database are managed by Oracle and shared across tenants, with the customer only provisioning the database. Option E, Autonomous Database on Dedicated Exadata Infrastructure, is also correct because Oracle provides a dedicated deployment model where the customer provisions an Exadata Cloud@Customer or dedicated Exadata infrastructure in OCI, giving isolated, single-tenant Exadata hardware for the Autonomous Database. Options A and D are not valid because Oracle does not offer ADB on local block storage or on a standalone bare metal VM as named deployment models. Option B is not valid because Autonomous Database is not deployed on a customer's local on-premises Linux server; on-premises deployment is only available via Exadata Cloud@Customer, not a generic Linux server.

Answer

Autonomous Database on Local Block Storage

Answer

Autonomous Database on Local On-Premises Linux Server

Answer

Autonomous Database on Standalone Bare Metal VM

Question 14

Which THREE network components must be correctly configured in a VCN to allow an application instance in a private subnet to connect to an Autonomous Database with a private endpoint?

Accepted Answer

Security lists or network security groups allowing traffic on port 1522. Option A is correct because the Autonomous Database private endpoint listener accepts connections on TCP port 1522, so the security list or NSG applied to the application subnet (and the ADB endpoint subnet) must permit ingress/egress on port 1522 between the application instance and the database endpoint. Option B is correct because the application must resolve the private endpoint's hostname to its private IP; this requires proper DNS configuration, typically via the VCN resolver and, for private endpoints, the private DNS zone/record associated with the ADB endpoint. Option E is correct because a private endpoint for Autonomous Database must reside in a subnet within the VCN (often a dedicated subnet), and that subnet must be properly designated and configured so the endpoint is reachable from the application's private subnet. Option C is incorrect because an Internet Gateway is only for public internet traffic and is not required for private subnet-to-private endpoint communication. Option D is incorrect because a Public Load Balancer is not needed and would not provide the private connectivity path to the ADB private endpoint.

Answer

An Internet Gateway attached to the private subnet

Answer

A Public Load Balancer fronting the private IP address

Question 15

Which TWO storage options are available when provisioning an Oracle Base Database System?

Accepted Answer

OCI Block Volume storage managed via Automatic Storage Management (ASM). Option D is correct because Oracle Base Database System on OCI can be provisioned with OCI Block Volume storage that is presented to the database host and managed by Automatic Storage Management (ASM), which is the standard Oracle storage management layer for database files. Option E is correct because certain Bare Metal shapes for Base Database System offer local NVMe storage, which can be used as high-performance direct-attached storage for the database. Options A, B, and C are not valid provisioning choices for Oracle Base Database System: Google Cloud Persistent Disk and Amazon S3 are other cloud providers' services, and local floppy disk drives are obsolete and far too small for database storage.

Answer

Google Cloud Persistent Disk

Answer

Local floppy disk drives

Answer

Amazon S3 object storage buckets