Oracle ADB (Autonomous Database)
Certification Exam | Actual Questions &
Answers | 100% Correct | Update
Multiple-Choice Questions
QUESION 1 What is the primary goal of Oracle Autonomous Database (ADB)?
Answer: To deliver a self-managing, self-securing, and self-repairing database service
Rationale: ADB automates database tasks to enhance efficiency and security.
QUESION 2 What infrastructure underpins Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: Exadata provides high-performance hardware for ADB.
QUESION 3 What are the two deployment options for ADB?
Answer: Shared and dedicated Exadata infrastructure
Rationale: Shared offers cost-efficiency; dedicated provides isolation.
QUESION 4 What does provisioning an ADB instance entail?
Answer: Configuring resources and workload type for a new database
Rationale: Provisioning sets up compute, storage, and network parameters.
QUESION 5 What Oracle Cloud Infrastructure (OCI) tool manages ADB instances?
Answer: OCI Console
Rationale: The OCI Console provides a graphical 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.
, QUESION 7 What procedure modifies ADB performance data retention?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure adjusts retention settings.
QUESION 8 What tool is used for migrating data to ADB?
Answer: Data Pump
Rationale: Data Pump enables efficient data transfer to ADB.
QUESION 9 What objects does Data Pump typically migrate to ADB?
Answer: Tablespaces and data
Rationale: Data Pump focuses on tablespaces and data, excluding indexes.
QUESION 10 What is a primary advantage of using Data Pump for ADB migration?
Answer: Selective migration of objects
Rationale: Data Pump allows exclusion of unnecessary objects.
QUESION 11 What is the role of Oracle Application Express (APEX) in ADB?
Answer: To develop low-code applications
Rationale: APEX enables rapid app development within ADB.
QUESION 12 What tool provides a web-based interface for SQL queries in ADB?
Answer: SQL Developer Web
Rationale: SQL Developer Web supports browser-based SQL execution.
QUESION 13 What ADB feature automatically optimizes workloads?
Answer: Automatic workload optimization
Rationale: Machine learning dynamically adjusts performance.
Certification Exam | Actual Questions &
Answers | 100% Correct | Update
Multiple-Choice Questions
QUESION 1 What is the primary goal of Oracle Autonomous Database (ADB)?
Answer: To deliver a self-managing, self-securing, and self-repairing database service
Rationale: ADB automates database tasks to enhance efficiency and security.
QUESION 2 What infrastructure underpins Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: Exadata provides high-performance hardware for ADB.
QUESION 3 What are the two deployment options for ADB?
Answer: Shared and dedicated Exadata infrastructure
Rationale: Shared offers cost-efficiency; dedicated provides isolation.
QUESION 4 What does provisioning an ADB instance entail?
Answer: Configuring resources and workload type for a new database
Rationale: Provisioning sets up compute, storage, and network parameters.
QUESION 5 What Oracle Cloud Infrastructure (OCI) tool manages ADB instances?
Answer: OCI Console
Rationale: The OCI Console provides a graphical 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.
, QUESION 7 What procedure modifies ADB performance data retention?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure adjusts retention settings.
QUESION 8 What tool is used for migrating data to ADB?
Answer: Data Pump
Rationale: Data Pump enables efficient data transfer to ADB.
QUESION 9 What objects does Data Pump typically migrate to ADB?
Answer: Tablespaces and data
Rationale: Data Pump focuses on tablespaces and data, excluding indexes.
QUESION 10 What is a primary advantage of using Data Pump for ADB migration?
Answer: Selective migration of objects
Rationale: Data Pump allows exclusion of unnecessary objects.
QUESION 11 What is the role of Oracle Application Express (APEX) in ADB?
Answer: To develop low-code applications
Rationale: APEX enables rapid app development within ADB.
QUESION 12 What tool provides a web-based interface for SQL queries in ADB?
Answer: SQL Developer Web
Rationale: SQL Developer Web supports browser-based SQL execution.
QUESION 13 What ADB feature automatically optimizes workloads?
Answer: Automatic workload optimization
Rationale: Machine learning dynamically adjusts performance.
