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

Question 1

Which TWO mechanisms are used by OCI Database backup services to ensure data consistency and integrity during backups of Oracle Base Database Systems?

Accepted Answer

Oracle Recovery Manager (RMAN) backup validation and incremental backup integration. Option B is correct because Oracle Base Database Systems use Oracle Recovery Manager (RMAN) to perform validated backups and incremental backups, which verify block integrity and maintain consistency across datafiles, control files, and archived redo logs. Option C is correct because OCI Block Volume snapshots provide crash-consistent, point-in-time copies of the underlying storage, ensuring the database files captured in a backup are consistent as of a single moment. Option A is incorrect because mirroring /etc/passwd via FTP is unrelated to database backup consistency and integrity. Option D is incorrect because manually copying files with SQL*Plus while the database is read-write risks inconsistent, torn backups. Option E is incorrect because converting database files to CSV is not a backup mechanism and would destroy the Oracle datafile format.

Answer

Third-party FTP mirroring of the /etc/passwd file

Answer

Manual SQL*Plus file copy commands while the database is in read-write mode

Answer

Automatic conversion of all database files to CSV format prior to backup

Question 2

Which THREE factors should you evaluate when determining whether to use an Oracle Base Database System versus Exadata Cloud Service?

Accepted Answer

Need for Exadata-specific features such as Smart Scan and Hybrid Columnar Compression. Option B is correct because Exadata Cloud Service is the only platform that delivers Exadata-specific capabilities such as Smart Scan, Storage Indexes, and Hybrid Columnar Compression, so a requirement for those features forces the Exadata choice. Option D is correct because Exadata's scale-out architecture, RDMA over Converged Ethernet (RoCE) fabric, and NVMe flash provide far higher I/O throughput and scalability than a single-VM Oracle Base Database System, making workload performance and growth the primary technical discriminator. Option E is correct because Exadata infrastructure carries a substantially higher entry cost (dedicated Exadata quarter/half racks or Exadata Cloud@Customer) than a base system built on a single VM or bare-metal shape, so budget and cost constraints directly influence the decision. Option A is not a valid factor because MySQL compatibility is not a kernel feature of Oracle Database and is irrelevant to choosing between these two Oracle Database services. Option C is not a valid factor because both Oracle Base Database System and Exadata Cloud Service run on Oracle Linux (and Exadata is not offered on Microsoft Windows), so the OS choice does not differentiate them.

Answer

Requirement for MySQL compatibility in the Oracle database kernel

Answer

Whether the operating system must be Microsoft Windows or Linux

Question 3

Which THREE tools or methods can be used to load data into an Oracle Autonomous Database?

Accepted Answer

DBMS_CLOUD PL/SQL package (loading files from OCI Object Storage). Option A (DBMS_CLOUD PL/SQL package) is correct because Autonomous Database provides the DBMS_CLOUD package to load files directly from OCI Object Storage (and other supported cloud storage) into tables using procedures such as DBMS_CLOUD.COPY_DATA. Option C (Database Actions / SQL Developer Web data loading interface) is correct because Database Actions is the built-in web-based toolset for Autonomous Database that includes a Data Load wizard for uploading CSV, XLSX, and other files into tables. Option D (Oracle Data Pump impdp) is correct because Autonomous Database supports Data Pump import/export, typically by placing dump files in OCI Object Storage and using DBMS_CLOUD or the impdp utility with the appropriate credentials and directory objects. Option B is incorrect because direct raw disk block editing via FTP is not possible on Autonomous Database, which is a fully managed service that does not expose the underlying OS or storage. Option E is incorrect because direct OS command line piping via 'cat' and SSH is not available, as Autonomous Database does not grant SSH access to the underlying host.

Answer

Direct raw disk block editing via FTP

Answer

Direct OS command line piping via 'cat' and SSH

Question 4

Which TWO editions of Oracle Database are generally available for provisioning when creating an Oracle Base Database System in OCI?

Accepted Answer

Standard Edition 2 (SE2). When provisioning an Oracle Base Database System in OCI, the two generally available database editions offered are Standard Edition 2 (SE2) and Enterprise Edition (EE). Option A, Standard Edition 2 (SE2), is correct because Oracle Base Database Service supports SE2 as a lower-cost edition suitable for standard workloads. Option B, Enterprise Edition (EE), is correct because it is the flagship edition that provides advanced features like multitenant, partitioning, and Data Guard, and is a standard provisioning choice on OCI Base Database. The unmarked options do not belong: Oracle Database Lite Edition (C) is a discontinued lightweight database for mobile/embedded use, Oracle Database Express Edition (XE) Cloud Managed (D) is not an OCI Base Database provisioning edition, and Community Edition SQL Server (E) is a Microsoft product unrelated to Oracle Database.

Answer

Oracle Database Lite Edition

Answer

Oracle Database Express Edition (XE) Cloud Managed

Answer

Community Edition SQL Server

Question 5

An enterprise workload requires a fully managed Oracle Autonomous Data Warehouse with dedicated infrastructure to guarantee isolation from other tenants. Which deployment architecture should you select when provisioning this database?

Accepted Answer

Autonomous Data Warehouse on Dedicated Exadata Infrastructure. Autonomous Database on Dedicated Exadata Infrastructure provides a dedicated database environment that gives you an isolated Exadata infrastructure exclusively for your organization.

Answer

Autonomous Data Warehouse on Shared Exadata Infrastructure

Answer

Exadata Cloud@Customer without Autonomous operations

Answer

Oracle Base Database Service on Dedicated Exadata

Question 6

Your development team needs to access an Autonomous Transaction Processing (ATP) database instance securely over the internet. What artifact must be downloaded and distributed to clients to establish a secure, encrypted connection?

Accepted Answer

A Client Credentials Wallet (wallet.zip) file. To connect to an Autonomous Transaction Processing (ATP) database over the internet with encryption, clients must use a Client Credentials Wallet (wallet.zip). This wallet contains the credentials, connection strings (tnsnames.ora, sqlnet.ora), and the SSL/TLS certificates required for mutual TLS (mTLS) authentication. It is downloaded from the OCI Console and distributed to each client that needs secure access.

Answer

An Identity and Access Management (IAM) API signing key

Answer

An SSH Private Key (.ppk) file

Answer

A Transparent Data Encryption (TDE) master key file

Question 7

You are configuring a Data Guard association between a primary Oracle Base Database Service DB system and a standby DB system in a different availability domain. The primary database encounters a catastrophic failure. Which action must you perform to promote the standby database to primary using the OCI Console?

Accepted Answer

Perform a Failover operation from the standby database details page.. When the primary database has suffered a catastrophic failure and is unavailable, the correct OCI Console action is Failover from the standby database details page. Failover promotes the standby to primary without requiring the original primary to be online, which is exactly the scenario described. Switchover, by contrast, requires both databases to be healthy and is a planned role reversal.

Answer

Perform a Switchover operation from the standby database details page.

Answer

Delete the Data Guard association and create a new primary database from a backup.

Answer

Run RMAN restore commands directly on the standby host operating system.

Question 8

An administrator needs to scale up CPU cores for an existing Oracle Autonomous Transaction Processing database without causing application downtime. Which feature of Autonomous Database allows this?

Accepted Answer

Autonomous Database Elastic Resource Scaling. Autonomous Database Elastic Resource Scaling allows you to scale the number of OCPU cores (and optionally storage) up or down on a running Autonomous Transaction Processing database without any downtime. The scaling operation is performed online by Oracle's managed infrastructure, so active sessions and applications continue to run. This is the built-in feature specifically designed for the 'scale up CPU cores without downtime' requirement.

Answer

Database migration via Oracle Zero Downtime Migration tool

Answer

Manual resizing through operating system configuration files

Answer

Database cloning

Question 9

You are planning to restore an Oracle Base Database Service DB system from an object storage backup. Which backup types are supported by OCI for creating a new DB system?

Accepted Answer

Automated backups or manual full backups. Oracle Base Database Service on OCI supports restoring from automated backups or manual full backups stored in Object Storage. These backup types contain the full database state needed to provision a new DB system. Incremental-only or Data Pump exports are not supported as direct sources for creating a new DB system via the OCI console or API.

Answer

OCI Block Volume snapshots

Answer

Only incremental manual backups

Answer

Only Data Pump export dump files

Question 10

You manage an Autonomous Database instance and want to configure Auto-Scaling for storage. What is the behavior of storage auto-scaling when enabled?

Accepted Answer

It automatically expands storage space as needed without user intervention, up to three times the base storage size.. Storage auto-scaling on Autonomous Database automatically expands allocated storage when utilization approaches capacity, without downtime or manual intervention, and it can grow up to three times the base storage size. This is a one-way expansion — storage is never automatically shrunk — and it is billed only for the storage actually consumed. The feature is designed to prevent out-of-space errors during unpredictable workload spikes.

Answer

It scales down storage during low usage windows to reduce monthly cloud billing.

Answer

It automatically deletes old backups to free up block storage when thresholds are reached.

Answer

It automatically adds OCPUs whenever storage utilization exceeds 80 percent.

Question 11

An architect needs to perform a point-in-time recovery (PITR) on an Oracle Base Database Service DB system using the OCI Console. What is a prerequisite constraint when selecting a recovery timestamp?

Accepted Answer

The timestamp must be within the retention window of the automated backups and archive log backups.. Point-in-time recovery on Oracle Base Database Service relies on automated backups plus archived redo logs to reconstruct the database to a chosen moment. The selected timestamp must fall within the retention window configured for those backups and archive logs; if the timestamp is older than the retention period, the required redo is no longer available and recovery cannot proceed. This is the fundamental prerequisite constraint when choosing a recovery timestamp in the OCI Console.

Answer

Point-in-time recovery is only supported via SQL*Plus and cannot be initiated from the OCI Console.

Answer

The target timestamp must be aligned precisely with the exact minute of the last incremental backup.

Answer

The database must first be converted to an Autonomous Database before PITR can be executed.

Question 12

You are deploying an Exadata Cloud Service instance and need to configure separate Virtual Machine clusters on the same Exadata rack. Which architectural feature enables this separation?

Accepted Answer

Exadata VM Clusters. Exadata VM Clusters are the architectural construct that lets you carve a single Exadata Cloud Service rack into multiple isolated VM clusters, each with its own compute nodes, storage access, and network configuration. This is the supported mechanism for multi-tenant separation on the same physical rack.

Answer

OCI Compartment boundaries

Answer

Oracle Multitenant container databases with PDB isolation

Answer

Dynamic Routing Gateways (DRG)

Question 13

You are configuring Data Guard between two Exadata Cloud Service instances across different OCI regions. Which network component is mandatory to facilitate redo transport securely across regional boundaries?

Accepted Answer

Remote VCN Peering. Remote VCN Peering connects VCNs in different OCI regions, providing the private network path needed for Data Guard redo transport between Exadata Cloud Service instances in separate regions. Without it, redo traffic would have to traverse the public internet, which is neither secure nor supported for this use case.

Answer

OCI API Gateway

Answer

An Internet Gateway with public IP addresses

Answer

Local VCN Peering gateway

Question 14

You need to migrate a 10 TB Oracle Database from an on-premises data center to OCI Base Database Service with minimal downtime. Which migration tool leverages Oracle Data Guard to achieve near-zero downtime?

Accepted Answer

Oracle Zero Downtime Migration (ZDM) with physical migration method. Oracle Zero Downtime Migration (ZDM) with the physical migration method uses Oracle Data Guard to replicate the on-premises database to OCI Base Database Service, keeping the source and target synchronized until a planned switchover. This minimizes downtime to only the final switchover window, which is typically seconds to minutes even for a 10 TB database. Logical methods (Data Pump) would require a full export/import cycle and much longer downtime.

Answer

SQL Developer database copy wizard

Answer

Oracle Data Pump export and import

Answer

OCI Object Storage manual file copy using multipart uploads

Question 15

An administrator wishes to enable Autonomous Data Guard for an Autonomous Database on Dedicated Exadata Infrastructure. What is the primary benefit of enabling this feature?

Accepted Answer

It automatically provisions a standby database and handles failover and switchover operations to ensure high availability.. Autonomous Data Guard is Oracle's managed standby solution for Autonomous Database on Dedicated Exadata Infrastructure. When enabled, Oracle automatically provisions and maintains a standby database in a separate availability domain or region, and it orchestrates role transitions (switchover for planned maintenance, failover for unplanned outages) without manual intervention. This delivers high availability and disaster recovery with an RPO near zero and minimal administrative overhead.

Answer

It allows read-write operations simultaneously on both primary and standby databases across regions.

Answer

It automatically shards tables across two different cloud regions to speed up write operations.

Answer

It reduces cloud storage billing by compressing redundant backup blocks on the standby instance.