Certification Exam Review Latest

Oracle ADB (Autonomous Database) Certification Exam Review (Latest Update 2025 / 2026) Questions and Answers | Grade A | 100% Correct

Question:

Which method will NOT permit you to change the database apsrn user's password of an Oracle Autonomous Database on Shared Infrastructure?

Answer:

OS command line from the database server

Question:

Which two options are available to restore an Oracle Autonomous Database?(Choose all correct answers)

Answer:

Specify the point in time (timestamp) to restore Select the backup from which restore needs to be done

• / 3

Question:

What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose all correct answers)

Answer:

Users have more control over the maintenance schedule Offers greater control and Isolation starting at the Exadata cloud infrastructure level

Question:

Your customer has upgraded their on-premises 11.2 Database to 12.2. Dui database was migrated to a pluggable database and is now in production.How should the customer unplug their database to migrate to Autonomous Database (ADB)?

Answer:

Pluggable databases cannot be migrated to ADB using plug, unplug, or clone.

Question:

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?

Answer:

Month of the Quarter, Week of the Month, Day of the week, Start Hour

• / 3

Question:

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

Answer:

Execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA(username => MTHEO;, tablespace quota -

UNLIMITED

Question:

Which two statements are true about Data Insights? (Choose all correct answers)

Answer:

You can retrieve previously executed Data Insights searches

You can search for Data Insights against a base table or business model

Question:

Which native data type is used to store spatial information?

Answer:

spo_Geometry

• / 3