All 6 domains
24 official topics
56–74 hrs suggested study
-
Domain 01
This section covers the building blocks of Oracle AI Vector Search: embeddings, the native VECTOR data type and its formats, generating embeddings with in-database ONNX models or external providers, and the SQL functions that create and inspect vectors.
Inside this domain
- Explain vector embeddings and semantic similarity search
- Store embeddings with the VECTOR data type
- Generate embeddings inside and outside the database
- Use vector SQL functions and constructors
Watch for Keyword search finds meaning
- Topics
- 4
Read the domain guide →
-
Domain 02
This section covers how Oracle compares vectors and makes search fast: distance metrics, exact and approximate queries, HNSW and IVF vector indexes, vector pool sizing, accuracy checks and hybrid vector indexes.
Inside this domain
- Select vector distance metrics
- Perform exact and approximate similarity search
- Create and tune HNSW and IVF vector indexes
- Manage vector memory, accuracy and hybrid indexes
Watch for Bigger distance is better
- Topics
- 4
Read the domain guide →
-
Domain 03
This section covers retrieval-augmented generation inside Oracle AI Database: extracting and chunking documents, embedding and retrieving chunks, and grounding LLM answers with DBMS_VECTOR_CHAIN or Select AI with RAG.
Inside this domain
- Describe the RAG workflow in Oracle AI Database
- Prepare documents with DBMS_VECTOR_CHAIN
- Generate, store and retrieve chunk embeddings
- Generate grounded responses with LLM providers
Watch for RAG retrains the model
- Topics
- 4
Read the domain guide →
-
Domain 04
This section covers Select AI on Autonomous AI Database and its agent framework: AI profiles, natural-language-to-SQL actions, and the tools, agents, tasks and teams of Select AI Agent.
Inside this domain
- Configure Select AI profiles for natural language to SQL
- Use Select AI actions and conversations
- Build Select AI Agent tools, agents and tasks
- Orchestrate agent teams and the agent loop
Watch for Rows go to the LLM for SQL
- Topics
- 4
Read the domain guide →
-
Domain 05
This section covers how agents reach Oracle AI Database through governed interfaces: Model Context Protocol basics, the managed Autonomous AI Database MCP Server, tool design and least-privilege access controls.
Inside this domain
- Explain the Model Context Protocol for database agents
- Enable and use the Autonomous AI Database MCP Server
- Expose database capabilities as agent tools
- Secure agent access to database data
Watch for Client defines tools
- Topics
- 4
Read the domain guide →
-
Domain 06
This section covers Oracle AI Database Private Agent Factory: deploying the platform in your own environment, building agents visually, choosing private or hosted models, governing data and access, and monitoring agents.
Inside this domain
- Describe Private Agent Factory architecture and deployment
- Build agents with Agent Builder and prebuilt agents
- Govern data sources, models and user access
- Monitor and operate deployed agents
Watch for It is SaaS
- Topics
- 4
Read the domain guide →
Domain names, weights and topics come from Oracle's official outline (1Z0-1159-26 exam topics (2026 release; section names from secondary source, unverified)). Question counts and study hours are editorial planning estimates, not official figures. Last reviewed October 2026.