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