Free 1Z0-931-25 Practice Test Questions and Answers (2026)

Viewing the maintenance history of Autonomous Exadata Infrastructure (AEI) requires navigating the

OCI console correctly. The correct path is:

Under Solutions and Platforms then Platform Services then Autonomous Exadata (C): In the OCI

console, AEI is categorized under “Solutions and Platforms” (a section for integrated services), then

“Platform Services” (covering cloud platform offerings), and finally “Autonomous Exadata.” Here, you

select your AEI instance (e.g., by name or OCID), and the details page displays a “Maintenance

History” section listing past events (e.g., patching dates, durations, and statuses like “Completed on

2025-03-01”). For example, a quarterly RU applied on January 15 might show “Patch Applied: RU

23.1” with start/end times. This path reflects AEI’s role as a dedicated platform supporting

Autonomous Container Databases (ACDs) and Autonomous Databases (ADBs).

The incorrect options are:

Under Core Infrastructure then Compute then Autonomous Exadata (A): “Core Infrastructure” >

“Compute” is for virtual machines or bare metal hosts, not Exadata infrastructure. AEI isn’t a

compute instance; it’s a database platform.

Under Database then Autonomous Transaction Processing then Autonomous Exadata (B): “Database”

> “Autonomous Transaction Processing” focuses on ATP instances, not the underlying Exadata

infrastructure. AEI maintenance is separate from specific ADB types.

Under Core Infrastructure then Autonomous Exadata (D): “Core Infrastructure” doesn’t directly list

AEI; it’s too broad and lacks the “Platform Services” context needed for Exadata-specific

management.

This navigation ensures you access AEI-specific maintenance details efficiently.

Reference: Oracle Cloud Infrastructure Documentation - Managing Autonomous Exadata

Infrastructure

Oracle Data Integrator (ODI) Web Edition integrates with Autonomous Database:

Correct Answer (B): “ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI)

Marketplace” is true. It’s offered as a Marketplace image for easy deployment on OCI compute

instances.

Correct Answer (D): “All capabilities of ODI Classic are available with ODI Web Edition” is correct; the

web version retains full functionality for data integration tasks.

Incorrect Options:

A: ODI Web Edition is not limited to Oracle Linux; it runs on various platforms supported by OCI.

C: The Data Transforms Card in Database Actions uses a simplified UI, not full ODI Web Edition

access.

This enhances data integration flexibility in the cloud.

Reference: ODI on OCI Marketplace

SQL Developer Web in Autonomous Database relies on Oracle REST Data Services (ORDS) for access.

The correct package is:

ORDS_ADMIN.ENABLE_SCHEMA (B): To allow a non-admin user (e.g., ANALYST1) to use SQL

Developer Web, the ADMIN user executes ORDS_ADMIN.ENABLE_SCHEMA to enable the schema for

ORDS access. This procedure activates the schema for RESTful services, granting privileges like

CONNECT and SELECT implicitly for web-based SQL execution. Example:

BEGIN

ORDS_ADMIN.ENABLE_SCHEMA(p_schema => 'ANALYST1');

END;

After this, the user accesses SQL Developer Web via a URL (e.g., https:///ords/analyst1/_sdw), logging in with their database credentials. This is necessary because SQL

Developer Web runs on ORDS, and only enabled schemas can interact with it. For instance, an

analyst might query SELECT * FROM sales in the web interface post-enablement, without needing

full admin rights.

The incorrect options are:

ORDS_ADMIN.GRANT_SCHEMA (A): No such procedure exists in ORDS_ADMIN. Granting is handled

via database roles/privileges (e.g., GRANT CONNECT), not a specific ORDS grant function.

ORDS_PRIV.ENABLE_SCHEMA (C): There’s no ORDS_PRIV package; this might confuse with

ORDS_ADMIN. The correct package is ORDS_ADMIN for schema enablement.

SQLDEV_ADMIN.GRANT_SCHEMA (D): No SQLDEV_ADMIN package exists. SQL Developer Web

access is managed through ORDS, not a separate SQL Developer-specific package.

ORDS_ADMIN.ENABLE_SCHEMA is the standard, secure way to enable non-admin access to this tool

in ADB.

Reference: Oracle Cloud Infrastructure Documentation - SQL Developer Web Setup

Full Detailed In-Depth Explanation:

When provisioning an Autonomous Database (ADB) on dedicated infrastructure, the placement

within the infrastructure is critical:

A . Listener endpoint: Incorrect. This is for connectivity, not placement.

B . Client Credentials wallet: Incorrect. This is for secure connections, not determining location.

C . The container database in which the Autonomous instance should run: Correct. On dedicated

infrastructure, an Autonomous Container Database (ACD) hosts multiple ADB instances. Selecting the

ACD during provisioning determines where the ADB resides, affecting resource allocation and

isolation.

D . The compartment: Incorrect. Compartments organize resources in OCI, but multiple ACDs can

exist within a compartment, so this doesn’t pinpoint the exact location.

Choosing the ACD is a key provisioning step for dedicated deployments.

Reference: Oracle Autonomous Database Dedicated Documentation - Provisioning

Provisioning an Autonomous Database without using the OCI Console is possible through

programmatic methods. The correct answer is:

Using the cloud infrastructure command line interface or REST API calls (D): The Oracle Cloud

Infrastructure Command Line Interface (OCI CLI) and REST APIs allow users to provision and manage

Autonomous Database resources programmatically. This method is ideal for automation or when GUI

access is not preferred. For example, the OCI CLI command oci db autonomous-database create can

be used to provision a database by specifying parameters like compartment ID, database name, and

workload type. Similarly, a REST API POST request to /autonomousDatabases achieves the same

result.

The incorrect options are:

Using the DBCA on the database server (A): The Database Configuration Assistant (DBCA) is a tool for

on-premises Oracle databases, not for cloud-based Autonomous Databases, which are fully managed

by Oracle.

Connecting to the cloud infrastructure console using the SSH wallet (B): SSH wallets are for secure

shell access to compute instances, not for provisioning databases or interacting with the OCI

Console.

It cannot be done (C): This is false, as programmatic provisioning via CLI or API is explicitly supported.

This capability enhances automation and integration into DevOps workflows.

Reference: Oracle Cloud Infrastructure Documentation - CLI for Autonomous Database and REST API

for Autonomous Database

Data Insights is a feature in Autonomous Database that helps users understand their data. The false

statement is:

Data Insights are automatically generated by various analytic functions built into the database (C):

This is incorrect. Data Insights are not solely the result of automatic execution of built-in analytic

functions (e.g., AVG, SUM, or RANK). Instead, they are generated through a combination of user-

initiated analysis and Oracle’s machine learning-driven capabilities within the Data Insights

dashboard (part of Database Actions or OCI console). Users select datasets or tables, and the system

applies algorithms to identify patterns (e.g., trends in sales) or anomalies (e.g., outlier transactions),

but this process isn’t just a passive outcome of pre-existing database functions—it’s an active,

curated feature requiring configuration. For example, a user might explore a SALES table, and Data

Insights highlights a spike in Q4 sales, but this requires user input to define scope, not just automatic

function output.

The true statements are:

Data Insights display information about patterns and anomalies in the data of entities in your Oracle

Autonomous Database (A): True. The feature visualizes trends (e.g., seasonal sales increases) and

outliers (e.g., unexpected data drops) in tables or views, helping users spot significant data

behaviors. For instance, it might show a bar chart of monthly revenue with an anomaly flagged for a

sudden dip.

Data Insights provides a wide range of graphical data presentation capabilities (B): True. It offers

visualizations like bar charts, line graphs, and scatter plots, customizable to represent data insights

effectively. E.g., a line graph might track customer sign-ups over time, with options to adjust axes or

filters.

The results of the Insight analysis appear as a series of bar charts in the Data Insights dashboard (D):

True, partially. While bar charts are a common default (e.g., comparing sales by region), the

dashboard supports multiple chart types, but the statement’s focus on bar charts aligns with typical

output for simple insights.

The misconception in C overlooks the interactive, ML-assisted nature of Data Insights, distinguishing

it from passive function-based analytics.

Reference: Oracle Cloud Infrastructure Documentation - Data Insights in Database Actions

Creating an Autonomous Database (ADB) via OCI’s REST API involves a specific endpoint. The correct

command is:

POST /20160918/autonomousDatabases (D): This is the official REST API endpoint to create an ADB

instance. The POST request to /20160918/autonomousDatabases (versioned at API 20160918)

submits a JSON payload defining the database (e.g., compartment, name, workload type). Example:

curl -X POST "https://database.us-ashburn-1.oraclecloud.com/20160918/autonomousDatabases" \

-H "Authorization: Bearer " \

-H "Content-Type: application/json" \

-d '{

"compartmentId": "ocid1.compartment.oc1..example",

"dbName": "MYADB",

"cpuCoreCount": 1,

"dataStorageSizeInTBs": 1,

"dbWorkload": "OLTP",

"adminPassword": "Secure#123"

}'

This creates an ATP instance named MYADB with 1 OCPU and 1 TB storage. The response includes an

OCID (e.g., ocid1.autonomousdatabase.oc1..example), and provisioning starts asynchronously,

visible in the OCI console as “PROVISIONING.” The endpoint’s plural form (autonomousDatabases)

reflects the resource collection, consistent with OCI API conventions.

The incorrect options are:

POST /20160918/createADB (A): No such endpoint exists. OCI APIs use resource-based paths (e.g.,

/autonomousDatabases), not action-specific ones like createADB.

POST /20160918/createautonomousDatabases (B): Incorrect syntax—APIs don’t prepend “create” to

resource paths, and “autonomousDatabases” is lowercase here, matching the real endpoint.

POST /20160918/createDatabases (C): Too generic; it doesn’t specify “autonomous” databases, and

no such endpoint exists for ADB creation.

This REST command is a programmatic alternative to console-based provisioning, ideal for

automation.

Reference: Oracle Cloud Infrastructure API Documentation - CreateAutonomousDatabase

A refreshable clone in Autonomous Database is a read-only copy of a source database that syncs

periodically, but it has a refresh time limit (typically 7 days). Once this limit is exceeded, specific

actions are available. The two correct options are:

You can disconnect from the source to make the database a read/write database (B): After the

refresh time limit passes, the clone can no longer sync with the source. You can “disconnect” it (via

the OCI console or API, e.g., oci db autonomous-database update --is-refreshable-clone false),

converting it into an independent, read/write Autonomous Database. This requires a new license and

incurs full costs, but it allows modifications (e.g., INSERT or UPDATE) that were blocked in read-only

mode. For example, a test clone might be disconnected to become a production instance after

testing.

You can use the instance as a read-only database (C): Even after the refresh limit, the clone remains

functional as a read-only database, retaining its last refreshed state. You can query it (e.g., SELECT *

FROM sales) for analysis or reporting without further refreshes, though it won’t reflect source

updates. This is useful if ongoing read-only access suffices without needing write capabilities.

The incorrect options are:

You can manually refresh the clone (A): False. Once the refresh time limit (e.g., 7 days) is exceeded,

manual refreshes are not possible. The clone’s refresh capability expires, and it can’t sync again

unless recreated. This is a fixed constraint to manage resource usage in ADB.

You can extend the refresh time limit (D): False. The refresh period (set during clone creation, max 7

days) cannot be extended after provisioning. You’d need to create a new clone with a longer limit if

needed, but post-expiry, no extension is allowed.

These options provide flexibility post-expiry, balancing read-only continuity and full database

conversion.

Reference: Oracle Cloud Infrastructure Documentation - Refreshable Clones

Third-party software can connect to an Autonomous Database using standard Oracle connectivity

options. The correct answer is:

Any protocol supported by Oracle Net Services (B): Autonomous Database leverages Oracle Net

Services (also known as SQL*Net) for connectivity, supporting protocols like TCP/IP with TLS for

secure communication. This allows a wide range of third-party tools (e.g., SQL Developer, Tableau, or

custom applications) to connect using established Oracle networking standards.

The incorrect options are:

New ADB-specific protocols (A): There are no proprietary, ADB-specific protocols; it uses Oracle’s

existing Net Services framework.

SQL*NET only (C): While SQLNet is part of Oracle Net Services, the broader term “Oracle Net

Services” encompasses all supported protocols, not just SQLNet.

JDBC only (D): JDBC is a specific Java-based API for database connectivity, not a protocol, and it’s just

one of many ways to connect via Oracle Net Services.

This flexibility ensures compatibility with diverse client applications.

Reference: Oracle Cloud Infrastructure Documentation - Connecting to Autonomous Database

Compartment quotas in OCI control resource usage within compartments. The incorrect statement

is:

Compartment quotas are set by Oracle (A): This is false. Compartment quotas are not set by Oracle;

they are defined by OCI administrators using quota policies in the Identity and Access Management

(IAM) system. Admins write policies (e.g., set database quota to 2 autonomous-databases in

tenancy) to limit resources like Autonomous Databases per compartment, giving customers full

control over resource allocation. Oracle provides the framework, but the specific quotas are user-

defined, not Oracle-imposed.

The correct statements are:

Along with compartment budgets, compartment quotas create a powerful toolset to manage your

spending (B): True. Quotas limit resource creation (e.g., max 5 ADBs), while budgets track spending

(e.g., $1000/month), together offering comprehensive cost management. For example, a quota

might cap ADB instances, and a budget alerts when costs approach a threshold.

There are three types of quota policy statements which are set, unset, and zero (C): True. SET assigns

a quota (e.g., set compute quota to 10 instances), UNSET removes it, and ZERO sets it to none,

effectively blocking resource creation. These verbs provide flexible quota management.

Compartment quotas use policies that allow allocation of resources with a high level of flexibility (D):

True. Policies are written in OCI’s IAM syntax, allowing granular control (e.g., set database quota to 1

autonomous-database where target.compartment.id = 'ocid1.compartment...'), tailored to specific

compartments or resources.

This customer-driven approach distinguishes quotas from Oracle-managed limits.

Reference: Oracle Cloud Infrastructure Documentation - Managing Quotas

Data Lakes in OCI Object Storage store raw data for analysis. The three correct characteristics are:

Schema on read (C): Data Lakes store data in its raw, native format (e.g., JSON, CSV, Parquet) without

a predefined schema. The schema is applied when data is read or processed, not when written,

offering flexibility. For example, a Parquet file with sales data might be queried with SQL only when

analyzed, not structured upfront like in a database.

Multiple subject areas (D): Data Lakes aggregate data from diverse sources—sales, HR, IoT—

spanning multiple subject areas. This enables cross-domain analysis, like combining customer data

with weather data for insights, all stored in a single OCI bucket.

Mixed data types (E): Data Lakes support varied formats: structured (e.g., CSV tables), semi-

structured (e.g., JSON documents), and unstructured (e.g., videos). For instance, a bucket might hold

CSV logs, JSON events, and image files, all accessible for processing.

The incorrect options are:

High concurrency (A): Data Lakes in Object Storage are not designed for high-concurrency

transactional access (e.g., thousands of simultaneous updates). They’re optimized for batch

processing or analytics, unlike ATP’s concurrency focus.

High transaction performance (B): Transactional performance (e.g., fast commits) is a database

strength, not a Data Lake’s. Object Storage prioritizes scalability and durability over transactional

speed, making it unsuitable for OLTP workloads.

These traits make Data Lakes ideal for big data analytics, not real-time transactions.

Reference: Oracle Cloud Infrastructure Documentation - Object Storage Overview

Full Detailed In-Depth Explanation:

Autonomous Transaction Processing (ATP) supports specific service names for connectivity:

TPURGENT: High-priority service with 200 concurrent statements per OCPU and parallelism.

MEDIUM: Balanced service for moderate workloads.

HIGH: Optimized for reporting/batch jobs with high parallelism.

LOW: Low-priority service for minimal resource use.

TP: General-purpose transactional service.

TPPERFORMANT is not a recognized service name in ATP documentation, making A the correct

answer.

Reference: Oracle Autonomous Database Shared Documentation - Service Names

Managing Autonomous Database via REST APIs relies on OCI authentication:

Correct Answer (D): “Database ADMIN password” is not needed. REST API access uses OCI IAM

credentials, not database-level credentials like the ADMIN password.

Required Items:

A: User’s OCID identifies the API caller.

B: Tenancy’s OCID specifies the cloud environment.

C: Fingerprint of the public key authenticates API requests with a private-public key pair.

This ensures secure, external management without exposing database credentials.

Reference: REST API Authentication

Autonomous Database provides predefined roles tailored to specific use cases. The correct answer is: DWROLE (B): The DWROLE predefined role is designed for Data Warehouse developers. It includes privileges commonly needed for data warehousing tasks, such as creating tables, views, and materialized views, as well as executing analytical queries. This role is optimized for Autonomous Data Warehouse (ADW) workloads. The incorrect options are: ADBDEV (A): There is no predefined ADBDEV role in Autonomous Database; this appears to be a fictional or misinterpreted role. ADMIN (C): The ADMIN role is a superuser role with full database privileges, far exceeding the needs of a typical Data Warehouse developer and not tailored to that specific use case. ADWC (D): This is not a predefined role; it might be a typo or confusion with ADW (Autonomous Data Warehouse), but no such role exists. DWROLE is the best fit for a Data Warehouse developer’s needs. Reference: Oracle Cloud Infrastructure Documentation - Predefined Database Roles

Creating an Autonomous Database offers specific deployment options. The two correct ones are:

APEX Service on Dedicated Infrastructure (A): This option provisions an Autonomous Database on

dedicated Exadata infrastructure with Oracle Application Express (APEX) pre-installed and optimized.

It’s ideal for APEX-based apps (e.g., custom web forms) requiring isolated resources. In the OCI

console, you select “Dedicated Infrastructure” and “APEX Service” as the workload type, specifying

OCPUs and storage. For example, a company might deploy an APEX app for internal reporting on a

dedicated ACD, ensuring performance isolation from other tenants.

Autonomous JSON Database on Shared Infrastructure (C): This creates a schema-less, JSON-centric

ADB on shared infrastructure, optimized for document storage (e.g., { "order_id": 123, "items": [...]

}). It’s provisioned via the OCI console under “Shared Infrastructure,” selecting “JSON Database” as

the workload type. For instance, a mobile app might use it to store user data, leveraging SQL/JSON

queries like SELECT JSON_VALUE(doc, '$.order_id'). It’s cost-effective and fully managed, sharing

Exadata resources.

The incorrect options are:

APEX Service on Shared Infrastructure (B): There’s no distinct “APEX Service” workload type on

shared infrastructure. APEX is available within ATP or ADW on shared infra, but it’s not a standalone

option—you’d provision ATP and enable APEX manually, not as a dedicated “APEX Service.”

Autonomous JSON Database on Dedicated Infrastructure (D): JSON Database is only offered on

shared infrastructure, not dedicated. Dedicated options include ATP, ADW, and APEX Service, but

JSON Database leverages shared resources for simplicity and cost.

These options cater to specific app development (APEX) and NoSQL (JSON) needs.

Reference: Oracle Cloud Infrastructure Documentation - Creating Autonomous Database

Oracle Spatial Studio is a self-service tool for working with spatial data in Autonomous Database. The

three correct functions are:

Map visualization (A): Spatial Studio provides robust capabilities to visualize spatial data on

interactive maps, enabling users to explore geographic patterns and relationships visually.

Spatial analysis (C): It offers tools for performing spatial operations like proximity analysis, spatial

joins, and buffering, which are essential for deriving insights from geographic data.

Spatial data editing (E): Users can edit spatial data, such as modifying geometries or updating

attributes, directly within Spatial Studio, making it a powerful tool for data management.

The incorrect options are:

Custom SQL queries (B): While Spatial Studio supports spatial operations, it is primarily a graphical

tool and does not focus on executing custom SQL queries. Such functionality is more aligned with

tools like SQL Developer.

Geocoding (D): Geocoding (converting addresses to coordinates) is not a core feature of Spatial

Studio. It focuses on visualization, analysis, and editing rather than address-to-coordinate

conversion, which is typically handled by separate Oracle services or tools.

These functions align with Spatial Studio’s purpose of simplifying spatial data management and

analysis.

Reference: Oracle Cloud Infrastructure Documentation - Spatial Studio Overview

ACLs control network access to Autonomous Database on Shared Infrastructure:

Correct Answer (B): “When you restore a database, the existing ACLs are not overwritten by the

restore” is true. ACLs are part of the database’s network configuration, preserved during restore

operations to maintain security settings.

Incorrect Options:

A: ACLs can include both IP addresses and VCN CIDR blocks simultaneously; they’re not mutually

exclusive.

C: ACLs apply to public endpoints, not just private ones, to restrict access.

D: ACLs can be modified post-creation, not just at provisioning time.

This ensures consistent security post-restore.

Reference: Access Control Rules

Autonomous Database on Dedicated Infrastructure supports customer-managed encryption (CME)

keys for enhanced security control. The correct vaults are:

Oracle Key Vault, Oracle Cloud Infrastructure Vault (D):

Oracle Key Vault (OKV): A centralized key management solution designed for Oracle environments,

OKV securely stores and manages encryption keys. It integrates with Autonomous Database to

provide customer-managed TDE (Transparent Data Encryption) keys, offering features like key

rotation and auditing. For example, a DBA might upload a master encryption key to OKV, which the

database then uses to encrypt data at rest.

Oracle Cloud Infrastructure Vault (OCI Vault): OCI Vault is a general-purpose secrets management

service in OCI, capable of storing encryption keys, passwords, and other sensitive data. It supports

storing TDE keys for Autonomous Database, providing a cloud-native option with high availability and

scalability. You might store a key in OCI Vault and link it to your database via the OCI console.

The incorrect options are:

Oracle Audit Vault, Oracle Key Vault (A): Oracle Audit Vault is for audit log management and analysis,

not key storage. It doesn’t support CME for Autonomous Database.

Oracle Cloud Infrastructure Vault, Oracle Database Vault (B): Oracle Database Vault enforces access

controls within the database but isn’t a key storage vault; it’s about privilege management, not key

management.

Oracle Database Vault, Oracle Key Vault (C): As above, Database Vault isn’t a key storage solution,

making this pairing incorrect.

Both OKV and OCI Vault offer robust security for CME, giving customers flexibility based on their

infrastructure p

(on-premises OKV vs. cloud-based OCI Vault).

Reference: Oracle Cloud Infrastructure Documentation - Customer-Managed Keys

The OCI Command Line Interface (CLI) provides a range of commands for managing Autonomous

Database via OCI APIs. The correct answer is:

Create, Get, List, Stop, Restore (B): These are key operations supported by the OCI CLI for

Autonomous Database:

Create: oci db autonomous-database create provisions a new ADB instance.

Get: oci db autonomous-database get retrieves details of a specific ADB.

List: oci db autonomous-database list lists all ADBs in a compartment.

Stop: oci db autonomous-database stop halts the database.

Restore: oci db autonomous-database restore restores from a backup.

The incorrect options are:

A (Start, Delete, Update, Query, Stop): “Query” is not a CLI command; “Delete” and “Update” are

valid but not part of this specific subset.

C (Create, Query, Update, List, Start): “Query” is invalid; “Update” is supported but not listed here.

D (Create, Query, List, Stop, Restore): “Query” is not a valid CLI operation.

This subset reflects common management tasks via CLI.

Reference: Oracle Cloud Infrastructure Documentation - OCI CLI for Autonomous Database

Oracle Data Safe enhances database security across various Oracle environments. The false

statement is:

Oracle Data Safe only supports Autonomous Database (D): This is incorrect. Oracle Data Safe supports

a wide range of Oracle databases, not just Autonomous Database. It works with Autonomous

Database (shared and dedicated), Oracle Database Cloud Service (VM and Bare Metal), Exadata DB

Systems, on-premises Oracle Databases, and Oracle Database on OCI Compute. For example, a DBA

could use Data Safe to mask sensitive data in an on-premises 19c database or assess security in an

Exadata Cloud@Customer deployment, not just ADB. This broad compatibility makes it a unified

security tool across Oracle’s ecosystem.

The true statements are:

Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your

database and its data dictionary (A): Data Safe’s Data Discovery feature scans tables and metadata to

identify sensitive columns (e.g., SSNs, credit card numbers), using predefined and custom patterns.

Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing

database configurations (B): The Security Assessment feature evaluates settings like encryption,

auditing, and privileges, providing risk scores and recommendations.

Oracle Data Safe evaluates user types, how users are authenticated, and the password policies

assigned to each user (C): User Assessment analyzes user accounts, authentication methods (e.g.,

password, SSO), and policies, highlighting risks like weak passwords.

The misconception in D limits Data Safe’s scope, which extends beyond ADB to all supported Oracle

databases.

Reference: Oracle Cloud Infrastructure Documentation - Data Safe Overview