Oracle ADB (Autonomous Database)
Certification Exam Review | Actual
Questions & Answers | 100% Correct | 2025 /
2026 Update
Multiple-Choice Questions
QUESION 1 What is the core purpose of Oracle Autonomous Database (ADB)?
Answer: To provide a self-managing, self-securing, and self-repairing database
Rationale: ADB automates routine database tasks to enhance efficiency and security.
QUESION 2 What infrastructure powers Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: Exadata provides high-performance hardware for ADB operations.
QUESION 3 What are the two primary deployment models for ADB?
Answer: Shared and dedicated Exadata infrastructure
Rationale: Shared is cost-effective, while dedicated offers isolated resources.
QUESION 4 What does provisioning an ADB instance involve?
Answer: Configuring resources and workload type for a new database
Rationale: Provisioning sets up compute, storage, and network settings.
QUESION 5 What interface is used to manage ADB instances in Oracle Cloud?
Answer: OCI Console
Rationale: The OCI Console provides a user-friendly interface for ADB management.
QUESION 6 What is the default retention period for ADB performance data?
Answer: Eight days
Rationale: Performance data is retained for eight days for monitoring purposes.
, QUESION 7 What procedure adjusts the retention period for ADB performance data?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure customizes retention.
QUESION 8 What tool is commonly used for data migration to ADB?
Answer: Data Pump
Rationale: Data Pump enables efficient data transfer to ADB.
QUESION 9 What objects are typically migrated using Data Pump to ADB?
Answer: Tablespaces and data
Rationale: Data Pump focuses on tablespaces and data, excluding indexes.
QUESION 10 What is a key benefit of using Data Pump for ADB migration?
Answer: Selective object migration
Rationale: Data Pump allows exclusion of unnecessary objects like indexes.
QUESION 11 What is Oracle Application Express (APEX) used for in ADB?
Answer: Developing low-code applications
Rationale: APEX supports rapid app development within ADB.
QUESION 12 What tool provides a web-based SQL interface for ADB?
Answer: SQL Developer Web
Rationale: SQL Developer Web enables browser-based SQL queries.
QUESION 13 What ADB feature optimizes workloads automatically?
Answer: Automatic workload optimization
Rationale: Machine learning adjusts performance dynamically.
QUESION 14 What is the purpose of Access Control Lists (ACLs) in ADB?
Answer: To restrict network access
Rationale: ACLs enhance security by controlling database connections.
Certification Exam Review | Actual
Questions & Answers | 100% Correct | 2025 /
2026 Update
Multiple-Choice Questions
QUESION 1 What is the core purpose of Oracle Autonomous Database (ADB)?
Answer: To provide a self-managing, self-securing, and self-repairing database
Rationale: ADB automates routine database tasks to enhance efficiency and security.
QUESION 2 What infrastructure powers Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: Exadata provides high-performance hardware for ADB operations.
QUESION 3 What are the two primary deployment models for ADB?
Answer: Shared and dedicated Exadata infrastructure
Rationale: Shared is cost-effective, while dedicated offers isolated resources.
QUESION 4 What does provisioning an ADB instance involve?
Answer: Configuring resources and workload type for a new database
Rationale: Provisioning sets up compute, storage, and network settings.
QUESION 5 What interface is used to manage ADB instances in Oracle Cloud?
Answer: OCI Console
Rationale: The OCI Console provides a user-friendly interface for ADB management.
QUESION 6 What is the default retention period for ADB performance data?
Answer: Eight days
Rationale: Performance data is retained for eight days for monitoring purposes.
, QUESION 7 What procedure adjusts the retention period for ADB performance data?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure customizes retention.
QUESION 8 What tool is commonly used for data migration to ADB?
Answer: Data Pump
Rationale: Data Pump enables efficient data transfer to ADB.
QUESION 9 What objects are typically migrated using Data Pump to ADB?
Answer: Tablespaces and data
Rationale: Data Pump focuses on tablespaces and data, excluding indexes.
QUESION 10 What is a key benefit of using Data Pump for ADB migration?
Answer: Selective object migration
Rationale: Data Pump allows exclusion of unnecessary objects like indexes.
QUESION 11 What is Oracle Application Express (APEX) used for in ADB?
Answer: Developing low-code applications
Rationale: APEX supports rapid app development within ADB.
QUESION 12 What tool provides a web-based SQL interface for ADB?
Answer: SQL Developer Web
Rationale: SQL Developer Web enables browser-based SQL queries.
QUESION 13 What ADB feature optimizes workloads automatically?
Answer: Automatic workload optimization
Rationale: Machine learning adjusts performance dynamically.
QUESION 14 What is the purpose of Access Control Lists (ACLs) in ADB?
Answer: To restrict network access
Rationale: ACLs enhance security by controlling database connections.
