Three full-length practice tests for the Agentic AI for Oracle AI Database Professional (1Z0-1159-26) certification exam - 50 questions per test, 90 minutes, 68% to pass, unlimited retakes.
Every question is grounded in Oracle's official exam objectives and product documentation - written fresh for this course, not recycled from public dumps.
What you'll be tested on
- Building AI agents that operate directly against Oracle AI Database
- Select AI, Oracle AI Vector Search, and natural-language-to-SQL workflows
- Private Agent Factory and the Autonomous AI Database MCP Server for tool discovery and orchestration
- Data privacy, access control, and guardrails for autonomous database agents
- Performance, monitoring, and troubleshooting agentic database workloads
Where candidates lose points
This exam is new for 2026, so there's no public pass-rate data to lean on yet. What's clear from the objectives themselves: the natural-language-to-SQL and vector search mechanics tend to be the easier half for candidates coming from an application-development background, while the database-security half is where they lose points - defining tight tool/function boundaries so an agent can't run arbitrary SQL, and scoping Select AI and vector search access to exactly what the calling agent is authorized to see.
Sample question
A team is deploying an AI agent that uses Select AI to translate analyst questions into SQL against a production schema. Which control best prevents the agent from executing a statement it was never intended to run?
- A. Increase the LLM's context window so it has more schema information before generating SQL
- B. Restrict the database user or role the agent connects as to read-only privileges on the target schema
- C. Instruct the LLM in the system prompt to "never write DELETE or DROP statements"
- D. Cache every SQL statement the agent generates for later review
Full explanations and 149 more questions like this are in the practice tests.
How long to prepare
Budget 3-4 weeks of focused study if you already work with Oracle AI Database and have some exposure to agent frameworks. The professional tier assumes you're not learning vector search or Select AI from scratch, just applying them in an agentic context, so the ramp is shorter for anyone with hands-on Oracle Database 23ai experience.

