Free Oracle 1Z0-931-26 Practice Test & Real Exam Questions

Exam Code/Number: 1Z0-931-26
Exam Name/Title: Oracle Autonomous AI Database Professional
Certification Provider: Oracle
Corresponding Certification: Oracle Cloud

Exam Questions: 151
Updated On: Oct 24, 2026

Question #1

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?

A. Unplug into a PDB archive, which can be uploaded to Object Storage.

B. PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.

C. Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.

D. Create a database link from the source database to the Autonomous Database environment and clone the PDB.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #2

How do you change the tablespace quota for user MTHEO on an Autonomous Database on Shared Infrastructure?

A. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;

B. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;

C. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');

D. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #3

Which is NOT needed to manage Oracle Autonomous Database with REST APIs?

A. Database ADMIN password

B. Fingerprint of the public key

C. Tenancy's OCID

D. User's OCID

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #4

Which Autonomous Database Cloud Service ignores hints in SQL statements by default?

A. Both services ignore hints by default

B. Autonomous Data Warehouse

C. Neither service ignores hints by default

D. Autonomous Transaction Processing

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #5

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

A. Data Pump export/import

B. RMAN Cross-Platform backup and restore

C. GoldenGate on-premise installation

D. GoldenGate Cloud Service

E. PDB unplug/plug operation

F. Data Guard Physical Standby

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

Which three statements are true about procedures in the DBMS_CLOUD package?

A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.

B. The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse.

C. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse.

D. The DBMS_CLOUVALIDATE_EXTERNAL_TABLE validates the source file for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a bad file table in Autonomous Data Warehouse.

E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

Which three event types are supported for Autonomous Database?

A. Update IORM Begin

B. Maintenance Begin

C. Change Compartment Begin

D. Change Autoscaling Configuration Compartment

E. Terminate End

Discussion 0

Correct Answer: B,C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

What is the default time range in Performance Hub?

A. 15 Minutes

B. 24 Hours

C. 1 Hour

D. 1 Week

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #9

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

A. You cannot use .NET with ADB

B. Java

C. SQL*Plus

D. Oracle Data Access Components for Windows

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #10

How many Network Security Groups (NSGs) can you configure for an Autonomous Database?

A. 9

B. 3

C. 7

D. 5

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1Z0-931-26 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-931-26 exam.