Oracle AI Database Foundations Associate (1Z0-1195-26) practice questions

Exam overview 1Z0-1195-26

Domain coverage 6 domains

• AI and Vector Foundations (15%)
• Using Oracle Database Actions and Data Studio Tools (15%)
• Working with JSON and Graph in Oracle AI Database (20%)
• Identifying Oracle AI Database 26ai Strategy and Autonomous AI Database Basics (20%)
• Implementing Select AI and AI Vector Search in Autonomous AI Database (20%)
• Building Low-Code Applications and Agentic AI (10%)

Sample questions 9 of 81 shown

1. Q1

   What does Oracle mean by a converged database strategy?

   1. One reporting tool replaces SQL, JSON APIs, and graph queries
   2. One application server manages all databases without schema changes
   3. One storage tier is reserved only for AI workloads and vector indexes
   4. One database architecture supports multiple data types and workloads together

   Converged means relational, JSON, graph, spatial, XML, and vector data live in one engine that understands one optimizer, one transaction model, and one security model, so an application can mix them in a single SQL statement. Option A confuses a tooling consolidation with the data-model claim. Option B describes an application server topology, not the database architecture. Option C invents a segregated storage tier — vector columns sit beside ordinary tables rather than in a separate silo.
2. Q2

   Which pair correctly matches an AI domain to an example?

   1. Vision — image classification
   2. Language — object detection in photos
   3. Forecasting — entity extraction from text
   4. Speech — product demand prediction

   Image classification is a computer-vision task: pixels in, category out. Option B assigns an image task to Language, which handles text analytics such as sentiment and entities. Option C assigns a text-extraction task to Forecasting, which projects numeric time series. Option D assigns demand prediction to Speech, which converts between audio and text.
3. Q3

   Which set of characteristics is commonly used to describe an Autonomous AI Database?

   1. Self-training, self-upgrading, and self-documenting
   2. Self-hosted, self-audited, and self-architected
   3. Self-coding, self-licensing, and self-networking
   4. Self-driving, self-securing, and self-repairing

   Oracle's positioning triad is self-driving (automated provisioning, tuning, and scaling), self-securing (automatic patching and encryption), and self-repairing (automated detection and remediation of failures and downtime). Options A, B, and C all swap in tasks that remain human responsibilities — documenting a schema, hosting the infrastructure, licensing, or designing the network — so none of them describes the autonomous model.
4. Q4

   What is the main difference between Autonomous AI Database Serverless and Dedicated deployment choices?

   1. Serverless requires customers to manage isolated Exadata infrastructure, while Dedicated is fully shared by default
   2. Serverless is used only for JSON workloads, while Dedicated is used only for relational workloads
   3. Serverless is simple and elastic, while Dedicated provides isolated private resources and more customization
   4. Serverless and Dedicated differ only in the SQL tools available to developers

   Serverless pools capacity on Oracle-managed Exadata and scales with the workload, which is why it needs almost no setup; Dedicated gives you your own Exadata infrastructure with isolation, private resources, and control over maintenance and networking. Option A inverts the two models. Option B invents a workload restriction — both serve relational, JSON, and AI workloads. Option D is wrong by category: the SQL and development tooling is the same.
5. Q5

   What is the operational benefit of a converged database compared with several point-solution databases?

   1. It automatically removes the need to review security policies for database workloads
   2. It guarantees that all workloads use the same physical schema and access method
   3. It can reduce operational complexity through a more consistent approach to security and patching
   4. It requires every application team to maintain a separate synchronization process

   Consolidating onto one engine means one patching cycle, one set of security controls, one backup and recovery process, and no cross-database synchronization to build and operate. Option A overstates it — policy review is still required, it is just centralized. Option B is false, since workloads keep their own schemas. Option D describes the point-solution problem this approach removes.
6. Q6

   Which set is included in the Oracle AI Database 26ai converged approach?

   1. Relational, JSON, vector, object-only files, and separate document stores
   2. JSON, document APIs, storage buckets, monitoring, and billing
   3. Relational, XML, spatial, external-only graph stores, and separate vector databases
   4. Relational, JSON, vector, graph, and spatial

   26ai brings relational, JSON, vector, graph, and spatial data into one engine, which is what lets a single query filter on relational columns, rank by vector distance, and traverse a property graph. Options A and C both push part of the model outside the database — object-only file stores or separate vector and graph databases — which contradicts the converged premise. Option B lists platform services rather than data models.
7. Q7

   A development team needs an Autonomous AI Database deployment that starts small, minimizes setup effort, and scales easily. Which deployment choice fits?

   1. A fixed-capacity deployment, because it maintains consistent performance without scaling
   2. Dedicated, because it allows full control over infrastructure configuration and capacity planning
   3. Dedicated, because it requires capacity to be provisioned and scaled by administrators
   4. Serverless, because it is designed for simple deployment and elastic scaling

   Serverless requires no infrastructure provisioning: you create the database, and compute and storage scale with demand. Options B and C both describe Dedicated, whose advantages are isolation and control rather than minimal setup — and whose capacity work is exactly the overhead this team wants to avoid. Option A describes a fixed deployment that contradicts the elastic-scaling requirement.
8. Q8

   Which statement describes Artificial Intelligence?

   1. Systems use data and algorithms to perform tasks that normally require human intelligence
   2. Systems eliminate the need for training data in every use case
   3. Systems are identical to AGI in all current enterprise products
   4. Systems replace databases by storing all data as graphs

   AI is defined by capability — perception, language, reasoning, and decision-making that would otherwise need a person — implemented with data and algorithms. Option B is false: supervised learning depends on labeled examples, and even self-supervised models learn from large corpora. Option C confuses narrow, task-specific systems with artificial general intelligence, which no commercial product delivers. Option D is a category error: AI systems consume databases, they do not replace them with graphs.
9. Q9

   What is an embedding in the context of AI Vector Search?

   1. A text-only backup of a JSON collection
   2. A maintenance schedule attached to a database instance
   3. A sequence of numbers that represents semantic content
   4. A graph edge label stored in a property graph

   An embedding is a dense numeric vector produced by a model, where geometric proximity encodes semantic similarity — which is why distance between vectors works as a relevance score. Option A describes a backup artifact. Option B is an administrative object. Option D confuses a graph label with a vector; the two data models solve different problems even though both live in the same database.

Answer all 81 questions with instant feedback →

Reader reviews 77 ratings

• The 1Z0-1195-26 practice exam was crucial to my success. The domains map perfectly to the official exam blueprint.

  ★★★★★★ Jennifer F.

• Got 856 out of 900 on the 1Z0-1195-26 exam. This question bank was my primary study resource. Highly recommend.

  ★★★★★ Alyssa D.

• I used this for three months on and off for 1Z0-1195-26. The progress tracker helped me stay consistent.

  ★★★★★★ Hannah K.

• Got the 1Z0-1195-26 certification after three weeks of self-study with this question bank. Very happy with the purchase.

  ★★★★★★ Victoria K.

• Couldn’t have passed the 1Z0-1195-26 exam without this. The questions are challenging, the explanations are thorough, and the value is unbeatable.

  ★★★★★ Hannah L.

• Took the 1Z0-1195-26 exam today and passed with 87%. Used this as my main prep material for about a month.

  ★★★★★★ Grace L.

Frequently asked questions

More Oracle exams