Oracle ADB (Autonomous Database)
Certification Exam Practice | Actual
Questions & Answers | 100% Correct |
Update
Multiple-Choice Questions
QUESION 1 What is the primary function of Oracle Autonomous Database?
Answer: To provide a self-managing, self-securing, and self-repairing database service
Rationale: Oracle ADB automates database management tasks to reduce manual intervention.
QUESION 2 What type of infrastructure supports Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: ADB runs on Oracle’s Exadata platform for high performance and scalability.
QUESION 3 What are the two main deployment options for Oracle Autonomous Database?
Answer: Shared and dedicated
Rationale: ADB offers shared Exadata infrastructure for cost-efficiency and dedicated for
isolation.
QUESION 4 What is the purpose of provisioning an Autonomous Database instance?
Answer: To create and configure a database for specific workloads
Rationale: Provisioning sets up the database with required resources and settings.
QUESION 5 What Oracle Cloud Infrastructure (OCI) service is used to manage ADB instances?
Answer: OCI Console
Rationale: The OCI Console provides a user interface for managing ADB resources.
,QUESION 6 What is the default backup retention period for Autonomous Database performance
data?
Answer: Eight days
Rationale: Performance data is retained for eight days by default for monitoring purposes.
QUESION 7 What procedure modifies the default retention period for performance data in
ADB?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure adjusts retention settings.
QUESION 8 What tool is used to migrate data to Autonomous Database using Data Pump?
Answer: Data Pump
Rationale: Data Pump facilitates efficient data migration to ADB.
QUESION 9 What objects are imported when using Data Pump to migrate to ADB?
Answer: Tablespaces and data
Rationale: Data Pump imports tablespaces and data, but not indexes or materialized views.
QUESION 10 What is a key advantage of using Data Pump for ADB migration?
Answer: Ability to exclude unnecessary objects
Rationale: Data Pump allows selective migration, excluding objects like indexes.
QUESION 11 What is the purpose of Oracle Application Express (APEX) in ADB?
Answer: To develop low-code applications
Rationale: APEX enables rapid application 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 allows users to run SQL queries via a browser.
, QUESION 13 What feature of ADB automatically optimizes workloads?
Answer: Automatic workload optimization
Rationale: ADB uses machine learning to optimize performance dynamically.
QUESION 14 What is the purpose of setting up Access Control Lists (ACLs) in ADB?
Answer: To control network access to the database
Rationale: ACLs enhance security by restricting network connections.
QUESION 15 What is the role of Private End Points in ADB?
Answer: To provide secure, private network access
Rationale: Private End Points ensure connections within a virtual cloud network.
QUESION 16 What is the minimum backup retention period for an Autonomous Container
Database?
Answer: Seven days
Rationale: ADB enforces a minimum seven-day backup retention for recovery.
QUESION 17 What is the maximum backup retention period for an Autonomous Container
Database?
Answer: Sixty days
Rationale: The maximum retention period is sixty days, not 120.
QUESION 18 What Oracle feature supports natural language queries in ADB?
Answer: Generative AI
Rationale: Generative AI enables natural language query processing.
QUESION 19 What is the purpose of Oracle Machine Learning in ADB?
Answer: To enable AI-based data analytics
Rationale: Oracle Machine Learning supports predictive modeling and analytics.
Certification Exam Practice | Actual
Questions & Answers | 100% Correct |
Update
Multiple-Choice Questions
QUESION 1 What is the primary function of Oracle Autonomous Database?
Answer: To provide a self-managing, self-securing, and self-repairing database service
Rationale: Oracle ADB automates database management tasks to reduce manual intervention.
QUESION 2 What type of infrastructure supports Oracle Autonomous Database?
Answer: Exadata infrastructure
Rationale: ADB runs on Oracle’s Exadata platform for high performance and scalability.
QUESION 3 What are the two main deployment options for Oracle Autonomous Database?
Answer: Shared and dedicated
Rationale: ADB offers shared Exadata infrastructure for cost-efficiency and dedicated for
isolation.
QUESION 4 What is the purpose of provisioning an Autonomous Database instance?
Answer: To create and configure a database for specific workloads
Rationale: Provisioning sets up the database with required resources and settings.
QUESION 5 What Oracle Cloud Infrastructure (OCI) service is used to manage ADB instances?
Answer: OCI Console
Rationale: The OCI Console provides a user interface for managing ADB resources.
,QUESION 6 What is the default backup retention period for Autonomous Database performance
data?
Answer: Eight days
Rationale: Performance data is retained for eight days by default for monitoring purposes.
QUESION 7 What procedure modifies the default retention period for performance data in
ADB?
Answer: MODIFY_SNAPSHOT_SETTINGS
Rationale: This DBMS_WORKLOAD_REPOSITORY procedure adjusts retention settings.
QUESION 8 What tool is used to migrate data to Autonomous Database using Data Pump?
Answer: Data Pump
Rationale: Data Pump facilitates efficient data migration to ADB.
QUESION 9 What objects are imported when using Data Pump to migrate to ADB?
Answer: Tablespaces and data
Rationale: Data Pump imports tablespaces and data, but not indexes or materialized views.
QUESION 10 What is a key advantage of using Data Pump for ADB migration?
Answer: Ability to exclude unnecessary objects
Rationale: Data Pump allows selective migration, excluding objects like indexes.
QUESION 11 What is the purpose of Oracle Application Express (APEX) in ADB?
Answer: To develop low-code applications
Rationale: APEX enables rapid application 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 allows users to run SQL queries via a browser.
, QUESION 13 What feature of ADB automatically optimizes workloads?
Answer: Automatic workload optimization
Rationale: ADB uses machine learning to optimize performance dynamically.
QUESION 14 What is the purpose of setting up Access Control Lists (ACLs) in ADB?
Answer: To control network access to the database
Rationale: ACLs enhance security by restricting network connections.
QUESION 15 What is the role of Private End Points in ADB?
Answer: To provide secure, private network access
Rationale: Private End Points ensure connections within a virtual cloud network.
QUESION 16 What is the minimum backup retention period for an Autonomous Container
Database?
Answer: Seven days
Rationale: ADB enforces a minimum seven-day backup retention for recovery.
QUESION 17 What is the maximum backup retention period for an Autonomous Container
Database?
Answer: Sixty days
Rationale: The maximum retention period is sixty days, not 120.
QUESION 18 What Oracle feature supports natural language queries in ADB?
Answer: Generative AI
Rationale: Generative AI enables natural language query processing.
QUESION 19 What is the purpose of Oracle Machine Learning in ADB?
Answer: To enable AI-based data analytics
Rationale: Oracle Machine Learning supports predictive modeling and analytics.
