Question bank
Oracle Autonomous AI Database Professional
45 Oracle Autonomous AI Database Professional questions with the correct answer and a written explanation, organised across 9 exam domains.
- 45 questions
- 9 domains
- Foundation level
certilumQuestion index
Jump straight to any question. Answers and explanations are inline.
Applying Autonomous Database Serverless Architectures
5 questions in this domain
- Question 1Single Choice
In an Oracle Autonomous Database Serverless architecture, what does the term serverless mean for infrastructure management?
- AOracle automatically provisions, scales, and manages resources.Correct answer
- BCustomers must reserve dedicated hardware.
- COnly storage resources are managed automatically.
- DThe database is limited to short-lived environments.
Why this is the answer
Serverless architecture means Oracle automatically handles the complete infrastructure provisioning, scaling, and management for Autonomous Database.
- Question 2Multiple Select
Based on Autonomous Database fundamentals, which workload types are supported by Autonomous Database in Oracle Cloud?
- AData warehouseCorrect answer
- BTransaction processingCorrect answer
- CJSON databaseCorrect answer
- DObject storage archive
Why this is the answer
Autonomous Database supports data warehouse, transaction processing, and JSON database workload types. Object storage archive is not a supported workload.
- Question 3Interactive
Review the OCI CLI command provided in the code block, then identify which database workload type is specified by the command.
- AData warehouseCorrect answer
- BTransaction processing
- CJSON database
- DData lake
Why this is the answer
The command uses the --db-workload DW option, which specifies that the provisioned Autonomous Database is a data warehouse workload.
- Question 4Single Choice
What is a core benefit of the autoscaling capability available in Oracle Autonomous Database Serverless environments?
- AResources scale automatically without downtime.Correct answer
- BA new database must be created to scale.
- CStorage scaling requires a maintenance window.
- DCPU resources remain fixed after provisioning.
Why this is the answer
Autoscaling automatically adjusts compute resources to match workload demand while the database remains available and does not require downtime.
- Question 5Multiple Select
Which capabilities are included in the always-on security features of Oracle Autonomous Database Serverless?
- AEncryption of data at restCorrect answer
- BEncryption of data in transitCorrect answer
- COracle-managed patchingCorrect answer
- DCustomer-managed firewall appliances
Why this is the answer
Autonomous Database includes automatic encryption of data at rest and in transit, and Oracle applies security patches automatically. Customer-managed firewall appliances are not included.
Applying Select AI Capabilities
4 questions in this domain
- Question 6Single Choice
What is the primary capability of the SELECT AI feature in Oracle Autonomous Database?
- ANatural language queriesCorrect answer
- BManual schema design
- CData entry automation
- DNetwork configuration
Why this is the answer
SELECT AI translates natural language prompts into SQL queries, allowing users to question data conversationally.
- Question 7Multiple Select
Which two tasks are considered fundamental when implementing an Oracle Autonomous Database?
- AAutomated provisioningCorrect answer
- BAutomatic backupsCorrect answer
- CManual performance tuning
- DManual security patch application
Why this is the answer
Autonomous Database automates provisioning and backups; manual tuning and patching are not required.
- Question 8Interactive
Given the SQL command in the code block, which part represents the natural language prompt?
- ASELECT AI
- BFROM sales_data
- Cwhat is the total sales per regionCorrect answer
- Dsales_data
Why this is the answer
The prompt after SELECT AI is the natural language text interpreted by the AI engine.
- Question 9Single Choice
Which SELECT AI action displays the details of how a query result was obtained?
- ASET
- BSHOW
- CEXPLAINCorrect answer
- DRUN
Why this is the answer
The EXPLAIN action in Select AI returns details about how the natural language query was interpreted and executed.
Designing Unified Data Management and AI Analytics
6 questions in this domain
- Question 10Single Choice
According to the fundamentals of Oracle Autonomous Database, which phrase best describes its defining operational characteristic?
- ASelf-driving, self-securing, and self-repairing operationsCorrect answer
- BManual tuning and patching by DBAs
- CRequires daily human administration
- DOn-premises-only deployment model
Why this is the answer
Oracle Autonomous Database is self-driving, self-securing, and self-repairing, using automation to reduce ongoing manual administration.
- Question 11Multiple Select
Identify which workload types are natively supported by Oracle Autonomous Database in a unified data management environment.
- AData warehousing and analyticsCorrect answer
- BOnline transaction processingCorrect answer
- CJSON and document workloadsCorrect answer
- DMachine learning within the databaseCorrect answer
Why this is the answer
Oracle Autonomous Database supports analytics, online transaction processing, JSON documents, and in-database machine learning for unified workloads.
- Question 12Interactive
Analyze the provided SQL statement. Which keyword should be added to define a column that uniquely identifies each row?
- APRIMARY KEYCorrect answer
- BFOREIGN KEY
- CNOT NULL
- DDEFAULT
Why this is the answer
A PRIMARY KEY constraint enforces uniqueness and non-null values, making it the correct way to identify each row.
- Question 13Single Choice
In the Oracle Autonomous Database model, which administrative task is handled automatically by the system?
- AProvisioning, tuning, and patchingCorrect answer
- BWriting application code
- CDesigning the data model
- DDefining business metrics
Why this is the answer
Autonomous Database automates provisioning, scaling, tuning, and patching, reducing the need for manual DBA work.
- Question 14Multiple Select
Which outcomes are associated with a unified data management approach using Oracle Autonomous Database today?
- AFewer data silosCorrect answer
- BReduced data duplicationCorrect answer
- COne source of truthCorrect answer
- DSeparate storage for every workload
Why this is the answer
Unified data management consolidates workloads, reduces duplication, eliminates silos, and provides a single source of truth.
- Question 15Interactive
Examine the SQL statement in the code block. Which category of function is being used to produce one result per group of rows?
- AAggregate functionCorrect answer
- BScalar function
- CAnalytic function
- DString function
Why this is the answer
COUNT with GROUP BY aggregates rows into groups and returns one result per group, making it an aggregate function.
Implementing Autonomous Database Dedicated Deployments
8 questions in this domain
- Question 16Single Choice
What is the first infrastructure resource to provision in an Autonomous Database Dedicated deployment?
- AAutonomous Exadata InfrastructureCorrect answer
- BAutonomous Container Database
- CAutonomous VM Cluster
- DAutonomous Database
Why this is the answer
Autonomous Exadata Infrastructure provides the dedicated compute, storage, and networking resources on which Autonomous Container Databases and Autonomous Databases run.
- Question 17Multiple Select
Which resources are part of an Autonomous Database Dedicated deployment? Select all that apply.
- AAutonomous Exadata InfrastructureCorrect answer
- BAutonomous Container DatabaseCorrect answer
- CAutonomous DatabaseCorrect answer
- DObject Storage bucket
Why this is the answer
Autonomous Exadata Infrastructure, Autonomous Container Database, and Autonomous Database form the core dedicated deployment stack. Object Storage is used for backups but is not part of the dedicated database stack.
- Question 18Interactive
Review the JSON provisioning request in the code block. Which field references the Autonomous Container Database that will host the new Autonomous Database?
- AautonomousDatabase
- BautonomousContainerDatabaseIdCorrect answer
- CdatabaseName
- DcpuCoreCount
Why this is the answer
The autonomousContainerDatabaseId property links the Autonomous Database to its Autonomous Container Database in a Dedicated deployment.
- Question 19Single Choice
Which statement best describes an Autonomous Container Database in a Dedicated deployment?
- AA physical Exadata rack that stores all customer databases
- BA logical container that groups and manages one or more Autonomous DatabasesCorrect answer
- CA shared Oracle Cloud Infrastructure service used to connect to Autonomous Databases
- DA backup storage area inside an Autonomous Database
Why this is the answer
Autonomous Container Database is a logical container that groups one or more Autonomous Databases and manages lifecycle operations on the dedicated infrastructure.
- Question 20Multiple Select
Which two benefits are specific to Autonomous Database Dedicated compared with shared Autonomous Database? Select two.
- ADedicated Exadata resources are reserved for one customer.Correct answer
- BMaintenance can be scheduled at the Autonomous Container Database level.Correct answer
- CThere is no customer isolation.
- DThe customer must apply quarterly security patches manually.
Why this is the answer
Dedicated deployment provides reserved Exadata resources and allows maintenance to be managed at the Autonomous Container Database level, while Oracle handles the underlying patching.
- Question 21Interactive
Review the Terraform configuration in the code block. Which resources are prerequisites for the Autonomous Database resource? Select all that apply.
- Aoci_database_autonomous_exadata_infrastructure.test_aeiCorrect answer
- Boci_database_autonomous_container_database.test_acdbCorrect answer
- Coci_database_autonomous_database.test_adb
- Doci_core_subnet.example_subnet
Why this is the answer
The Autonomous Exadata Infrastructure must exist before the Autonomous Container Database, and the Autonomous Container Database must exist before the Autonomous Database.
- Question 22Single Choice
Which resource must be provisioned before an Autonomous Container Database can be created in a Dedicated deployment?
- AAutonomous Database
- BAutonomous Exadata InfrastructureCorrect answer
- CObject Storage bucket
- DDynamic Routing Gateway
Why this is the answer
Autonomous Exadata Infrastructure is the physical platform required before an Autonomous Container Database can be created in a dedicated deployment.
- Question 23Multiple Select
Which statements about Autonomous Database Dedicated are true? Select all that apply.
- AAn Autonomous Container Database can host multiple Autonomous Databases.Correct answer
- BEach Autonomous Database requires a separate Autonomous Exadata Infrastructure.
- CPatching and maintenance are managed by Oracle on the dedicated infrastructure.Correct answer
- DAutonomous Database Dedicated can be deployed only in Oracle Cloud Government regions.
Why this is the answer
An Autonomous Container Database can host multiple Autonomous Databases, and Oracle manages patching and maintenance. One Exadata Infrastructure can support many databases, and dedicated deployment is not limited to Government regions.
Implementing Autonomous Database Fundamentals
8 questions in this domain
- Question 24Single Choice
What is the main benefit of using Oracle Autonomous Database for provisioning and operations?
- AIt uses automation to provision, tune, patch, and back up the database with minimal human intervention.Correct answer
- BIt requires DBAs to manually apply quarterly patches to production databases.
- CIt provides only on-premises database deployment.
- DIt separates compute and storage but requires manual scaling.
Why this is the answer
Autonomous Database uses automation to deliver self-driving capabilities including provisioning, tuning, patching, backups, and high availability.
- Question 25Multiple Select
Which workload types can be deployed with Oracle Autonomous Database services?
- AData warehousingCorrect answer
- BTransaction processingCorrect answer
- CJSON document storageCorrect answer
- DObject file system hosting
Why this is the answer
Autonomous Database includes Autonomous Data Warehouse, Autonomous Transaction Processing, and Autonomous JSON Database workload options. Object file system hosting is not a database workload type.
- Question 26Interactive
Examine the OCI CLI command shown in the code block. Which Autonomous Database workload is being requested?
- AAutonomous Data WarehouseCorrect answer
- BAutonomous Transaction Processing
- CAutonomous JSON Database
- DAutonomous Database on Dedicated Exadata Infrastructure
Why this is the answer
The db-workload value DW indicates a data warehouse workload, so the command provisions Autonomous Data Warehouse.
- Question 27Single Choice
Which task is completely automated by Oracle in an Autonomous Database environment?
- AApplying database software patchesCorrect answer
- BWriting PL/SQL application code
- CDefining user access policies
- DDesigning table partitioning strategies
Why this is the answer
Oracle automatically applies database software patches in Autonomous Database, while application code and database design remain customer responsibilities.
- Question 28Multiple Select
Which activities are automatically performed by Oracle Autonomous Database? Select all that apply.
- ABackup and recoveryCorrect answer
- BSecurity patchingCorrect answer
- CDesigning application schemas
- DInstalling web servers
Why this is the answer
Autonomous Database automates backups, recovery, security patching, tuning, and scaling. Application schema design and web server installation remain customer responsibilities.
- Question 29Interactive
Examine the OCI CLI command in the code block. What effect will executing this command have on the target Autonomous Database?
- AIt updates the instance to use 8 OCPUs.Correct answer
- BIt deletes the Autonomous Database instance.
- CIt changes the database workload from ATP to ADW.
- DIt creates a backup of the Autonomous Database.
Why this is the answer
The update command uses the cpu-core-count parameter to scale the target Autonomous Database instance to 8 OCPUs.
- Question 30Single Choice
How does Oracle Autonomous Database handle hardware or software failures?
- AThe service automatically detects the failure and recovers by reprovisioning on healthy hardware.Correct answer
- BThe database remains down until a DBA opens a support ticket.
- CAll data and configuration changes are lost permanently.
- DThe system only reports failure after the next scheduled backup.
Why this is the answer
Autonomous Database continuously monitors health and automatically reprovisions or recovers databases after hardware or software failures, minimizing downtime.
- Question 31Multiple Select
Which manual database management tasks are eliminated in Oracle Autonomous Database? Select all that apply.
- AApplying quarterly database patchesCorrect answer
- BConfiguring and monitoring backup jobsCorrect answer
- CTuning SGA/PGA memory parametersCorrect answer
- DDesigning end-user application screens
Why this is the answer
Patch management, backup configuration, and memory tuning are automated by Autonomous Database. Designing application screens is an application development task, not a database task.
Implementing MCP Server Integration
2 questions in this domain
- Question 32Single Choice
Which of the following best describes the core operational model of Oracle Autonomous Database?
- ASelf-driving, self-securing, and self-repairingCorrect answer
- BManual DBA intervention for every maintenance task
- CStatic provisioning that requires downtime for scaling
- DA read-only data warehouse with no automated backups
Why this is the answer
Oracle Autonomous Database relies on automation to handle routine administration, including tuning, scaling, security, and repair, reducing the need for manual DBA work.
- Question 33Multiple Select
Which of the following administrative tasks are automated by Oracle Autonomous Database? (Select all that apply.)
- ADatabase provisioningCorrect answer
- BScaling compute and storageCorrect answer
- CApplying security patchesCorrect answer
- DWriting custom application code
Why this is the answer
Oracle Autonomous Database automates provisioning, scaling, patching, tuning, and backups. Writing custom application code remains the responsibility of developers and is not automated by the database.
Managing, Monitoring, and Optimizing Performance
7 questions in this domain
- Question 34Single Choice
Which Oracle Autonomous Database console component provides real-time and historical performance monitoring, including SQL monitoring and wait-event analysis?
- APerformance HubCorrect answer
- BSQL Developer
- CCloud Shell
- DDatabase Configuration Assistant
Why this is the answer
Performance Hub is the built-in performance monitoring console, providing real-time and historical data such as SQL monitoring, ASH analytics, and wait event information.
- Question 35Multiple Select
Which capabilities are included in Autonomous Database to help manage and optimize performance automatically? (Select all that apply.)
- AAutomatic indexingCorrect answer
- BAuto scaling of CPU and I/O resourcesCorrect answer
- CPerformance Hub for diagnosticsCorrect answer
- DManual SGA/PGA tuning
Why this is the answer
Autonomous Database automates indexing, resource scaling, and provides Performance Hub. Manual memory tuning is not required or available because memory, SGA, and PGA are automatically managed.
- Question 36Interactive
Look at the following SQL statement. What does the output of this command provide?
- AA report of automatic SQL tuning recommendationsCorrect answer
- BThe real-time SQL execution plan
- CA list of invalid database objects
- DThe current wait class histogram
Why this is the answer
DBMS_AUTO_SQL_TUNING.REPORT_ACTIVITY returns a report of automatic SQL tuning activities, including recommendations for SQL plan changes and profiles.
- Question 37Single Choice
When auto scaling is enabled in Autonomous Database, which resource can be scaled automatically in response to workload demand?
- ACPU and I/OCorrect answer
- BMaximum database storage size
- CNumber of schemas
- DNetwork bandwidth
Why this is the answer
Autonomous Database auto scaling dynamically increases CPU and I/O resources as needed, while storage and network bandwidth are not part of the same scaling model.
- Question 38Multiple Select
Which of the following V$ views help monitor autonomous database performance and SQL execution? (Select all that apply.)
- AV$SQLCorrect answer
- BV$ACTIVE_SESSION_HISTORYCorrect answer
- CDBA_HIST_SQLSTATCorrect answer
- DDBA_DATA_FILES
Why this is the answer
V$SQL, V$ACTIVE_SESSION_HISTORY, and DBA_HIST_SQLSTAT provide SQL performance and historical activity data. DBA_DATA_FILES describes datafile storage, not performance.
- Question 39Interactive
Review the query below. Which performance details can be derived from the V$SQL results? (Select all that apply.)
- ASQL statements ordered by elapsed timeCorrect answer
- BCPU time consumed by each SQL statementCorrect answer
- CNumber of times each SQL statement was executedCorrect answer
- DPhysical tablespace free space
Why this is the answer
The query returns sql_id, elapsed_time, cpu_time, and executions, which identify statements with the highest elapsed time, CPU consumption, and execution counts.
- Question 40Single Choice
Which Automatic Workload Repository (AWR) report type is typically used to compare database performance between two snapshots?
- AAWR Compare Period ReportCorrect answer
- BAWR SQL Report
- CASH Report
- DADDM Report
Why this is the answer
AWR Compare Period Report compares performance metrics and statistics over two selected periods, helping isolate performance changes.
Understanding Migration and Data Integration
3 questions in this domain
- Question 41Single Choice
Which Oracle tool is often used to import an existing database into Autonomous Database?
- AOracle Data PumpCorrect answer
- BOracle APEX
- COracle Cloud Guard
- DOracle Analytics Cloud
Why this is the answer
Oracle Data Pump is commonly used to export data from an existing database and import it into Oracle Autonomous Database during a migration.
- Question 42Multiple Select
Which statements correctly describe migration requirements for Oracle Autonomous Database?
- AAutonomous Database connections must use a TLS wallet.Correct answer
- BOracle Data Pump can be used to import schemas into Autonomous Database.Correct answer
- CAutonomous Database requires the DBA to perform manual quarterly patching.
- DAutonomous Database connections always require a public IP and no encryption.
Why this is the answer
Autonomous Database enforces TLS for client connections, and Data Pump is a supported migration service. Manual patching is not required because Oracle manages maintenance, and public unencrypted access is not the standard connection method.
- Question 43Interactive
What action does the PL/SQL block in the code block perform?
- AIt registers a credential for use with Oracle Cloud Object Storage.Correct answer
- BIt deletes an existing database credential.
- CIt creates an Autonomous Database schema.
- DIt starts a data migration job.
Why this is the answer
DBMS_CLOUD.CREATE_CREDENTIAL stores an object storage credential that can be referenced by DBMS_CLOUD functions when loading data into Autonomous Database.
Utilizing and Analyzing Autonomous Database Tools
2 questions in this domain
- Question 44Single Choice
Which Oracle Autonomous Database tool provides real-time and historical performance monitoring for database workloads?
- APerformance HubCorrect answer
- BDatabase Configuration Assistant
- COracle Data Pump
- DCloud Shell
Why this is the answer
Performance Hub is the Oracle Autonomous Database tool designed for real-time and historical performance analysis.
- Question 45Multiple Select
Which two Oracle Autonomous Database tools can be used to analyze workload and access database performance data?
- APerformance HubCorrect answer
- BSQL Developer WebCorrect answer
- COracle Net Manager
- DOracle Recovery Manager
Why this is the answer
Performance Hub provides workload and performance charts, while SQL Developer Web offers a SQL interface for analyzing database data and operations.
Frequently asked questions
Everything about the Oracle Autonomous AI Database Professional question bank and how to use it.