Free 1z0-931-25: Oracle Autonomous Database Cloud 2025 Professional Exam Questions and Answers

Last updated: September 19, 2026

Exam code

931-25

Provider

Oracle

Questions in our bank

1000+

Free to read

First 10, with answers

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

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

   • A. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => 'MTHEO', tablespace_quota => 'UNLIMITED');
   • B. Execute ALTER USER MTHEO QUOTA UNLIMITED ON TABLESPACE DATA;
   • C. Execute ALTER TABLESPACE DATA SET QUOTA = 10G;
   • D. Execute ALTER DATABASE FOR USER MTHEO TABLESPACE DATA QUOTA = 10G;
   Reveal Answer

2. Question #2

   What are three methods to load data into the Autonomous Database? (Choose three.)

   Select 3 answers.

   • A. Oracle Data Pump
   • B. RMAN Restore
   • C. Oracle GoldenGate
   • D. Transportable Tablespace
   • E. SQL*Loader
   Reveal Answer

3. Question #3

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

   Select 3 answers.

   • A. 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.
   • 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_CLOUD.VALIDATE_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.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.
   Reveal Answer

4. Question #4

   Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

   Select 3 answers.

   • A. Using SFTP to copy CSV files into an Autonomous Database
   • B. Using Oracle Zero Downtime Migration (ZDM)
   • C. Using GoldenGate
   • D. Using Data Pump
   • E. Using Recovery Manager (RMAN)
   Reveal Answer

5. Question #5

   You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

   • A. Create a database user with connect, resource, and object privileges
   • B. Create a database user with the default privileges
   • C. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer Web, and provide the user with the user-specific modified URL
   • D. Create an IDCS user, create a database user with connect, resource, and object privileges
   Reveal Answer

6. Question #6

   Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)

   Select 2 answers.

   • A. Change administrator password
   • B. Start
   • C. Update License type
   • D. Update Network Access
   Reveal Answer

7. Question #7

   Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?

   • A. You can skip a scheduled maintenance ru
   • B. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed
   • C. You can perform a "rolling restart" on all the Autonomous Database
   • D. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available
   • E. You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure
   • F. You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure
   Reveal Answer

8. Question #8

   While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

   • A. Quarterly Bundle Patch (QBP)
   • B. Prior Release Update Revision (PRUR)
   • C. Prior Release Update (PRU)
   • D. Release Update (RU)
   Reveal Answer

9. Question #9

   Which is a feature of a graph query language?

   • A. Run key-value queries
   • B. Scripting language
   • C. Object-oriented language
   • D. Ability to specify patterns
   Reveal Answer

10. Question #10

    Which statement is true when connecting an OCI Marketplace image to a shared Autonomous Database?

    • A. Compute Image and Shared ADB must be in the same VCN and Subnet
    • B. ADB must be configured with Private endpoints
    • C. ADB must be configured with NSG
    • D. Cannot connect OCI Marketplace image to shared ADB
    Reveal Answer