Key details for this exam, checked against the published exam outline
Each question shows the correct answer and an explanation of why it is right
Which four file formats are supported when loading data from Cloud Storage?
Full Detailed In-Depth Explanation:
Supported formats:
A: False. DDL is a language, not a data format.
B: True. AVRO is supported for structured data.
C: True. Parquet is optimized for analytics.
D: False. DOC is not supported.
E: True. JSON is flexible for semi-structured data.
F: True. CSV is widely used for tabular data.
Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?
Migrating a PDB to Autonomous Database has limitations:
Correct Answer (B): ''PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone'' is true. Autonomous Database does not support direct plugging/unplugging of PDBs due to its managed architecture and differing storage/backup mechanisms.
Incorrect Options:
A: Unplugging into an XML file is valid for traditional PDBs, but Autonomous Database doesn't accept this for migration.
C: Cloning via database link isn't a standard method; it's more aligned with replication tools like GoldenGate.
D: PDB archives (e.g., .pdb files) are not supported for direct import into Autonomous Database.
Instead, use tools like Data Pump or GoldenGate for migration.
You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling? (Choose two.)
Enabling auto scaling on an existing Autonomous Database can be done without unnecessary complexity:
Correct Answer (A): ''Click Scale Up/Down and select the Auto Scaling checkbox'' is the simplest GUI method. In the OCI Console, navigate to the database, select ''Scale Up/Down,'' and enable the auto scaling option, allowing up to 3x the base OCPUs dynamically.
Correct Answer (C): ''Use a REST call to enable Auto Scaling'' leverages the OCI REST API to update the database configuration with the isAutoScalingEnabled parameter set to true. This is ideal for programmatic control.
Incorrect Options:
B: Shutting down the instance is unnecessary; auto scaling can be enabled while the database is running.
D: Multiple REST calls, including shutdown and restart, overcomplicate the process when a single API call suffices.
These methods ensure minimal disruption and efficient resource management.
You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance. Which tool would you use to automate data exploration and create pivot tables?
Full Detailed In-Depth Explanation:
A: False. APEX is for app development, not data exploration.
B: False. SQL Developer Web is for SQL queries, not pivot tables.
C: True. Business Models in ADW automates data exploration and generates pivot tables.
D: False. Data Load is for importing data, not analysis.
Which statement is NOT correct when setting up compartment quotas?
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.
Which is a feature of a graph query language?
Graph query languages, like Oracle's Property Graph Query Language (PGQL), are designed for graph databases:
Correct Answer (D): ''Ability to specify patterns'' is a defining feature. Graph queries excel at defining and matching patterns (e.g., nodes and edges) to explore relationships, such as finding paths or subgraphs, critical for applications like social network analysis or fraud detection.
Incorrect Options:
A: Key-value queries are typical of NoSQL key-value stores, not graph databases.
B: While scripting may be possible in some contexts, it's not a core feature of graph query languages.
C: Graph query languages are not inherently object-oriented; they focus on relational graph structures.
This pattern-matching capability distinguishes graph queries from other query paradigms.
Which three options do NOT change when enabling auto scaling? (Choose three.)
When enabling auto scaling in an Oracle Autonomous Database, the feature dynamically adjusts resources based on workload demand, but certain configuration elements remain unchanged unless manually altered.
Amount of storage (A): Auto scaling focuses on adjusting CPU and I/O resources to meet performance needs. The storage allocation remains constant because it is a separately provisioned resource that requires manual adjustment via the OCI Console or API. This ensures that storage capacity is not inadvertently reduced or expanded without explicit user intent.
Parallelism settings (B): These settings determine how many parallel processes are used for query execution. Auto scaling does not modify this pre-defined configuration; it adjusts resource usage (e.g., CPU cores) without altering the parallelism framework established for the database.
Level of concurrency (E): Concurrency refers to the maximum number of simultaneous user sessions. While auto scaling can indirectly influence concurrency by adjusting available resources, the concurrency limit itself is a fixed setting that remains unchanged unless explicitly modified by the administrator.
Incorrect Options:
I/O resources (C): Auto scaling directly impacts I/O resources by increasing or decreasing them alongside CPU adjustments to handle workload fluctuations.
Number of OCPUs displayed in the console (D): While the base OCPU count remains static, the effective number of OCPUs in use (up to three times the base) changes dynamically with auto scaling, and this is reflected in the console, making this option subject to change.
This behavior ensures that auto scaling optimizes performance without disrupting foundational database configurations.
Exam domains verified against: Official Oracle 1Z0-931-25 exam guide, last checked October 2026.
Understand Autonomous Database architecture, its key components, and how it integrates with Oracle Cloud Infrastructure. Learn the distinctions between shared and dedicated infrastructure offerings and the licensing models that apply to each deployment type.
Master instance management through REST APIs and OCI CLI tools, handle patching and upgrades, and implement access controls with ACLs and private endpoints. Configure performance monitoring, set up notifications, and use built-in services like auto-indexing and Data Safe.
Use Oracle Machine Learning, APEX, and SQL Developer Web within Autonomous Database for development tasks. Understand data transformation capabilities, create business models, and apply data insights for analytics and exploration.
Provision and manage shared instances with scaling of OCPUs and storage. Perform cloning operations, consolidate workloads using elastic resource pools, and manage backups and restores. Set up Data Guard for high availability and handle disaster recovery scenarios.
Sample question from this domain above: Q2
Evaluate migration strategies and key considerations for moving workloads to Autonomous Database. Use Data Pump and other migration tools to transfer data and metadata from on-premises or other cloud platforms.
Build applications using generative AI and natural language queries for enhanced data interaction. Leverage Autonomous JSON Database, Oracle Text, Spatial capabilities, and Graph functions. Integrate Object Storage data and perform data lake analytics on Autonomous Database.
Provision and manage dedicated Exadata infrastructure and Cloud@Customer deployments. Create OCI policies specific to dedicated environments, monitor dedicated infrastructure, manage encryption keys, and schedule maintenance windows and patching.
Common questions about the exam itself
