Active Data Guard (ADG) Certification Exam
2025–2026 Accurate Real Exam Questions and
Verified Correct Answers JUST RELEASED
Which Database Actions tool is used to get information about the entities in
your Oracle Autonomous Database and to see the effect that changing an
object has on other objects?
Options are :
Data Load
Catalog
Data Insights
JOSN - answer>>>Catalog (Correct)
Which two license types does a customer need to benefit from Bring Your
Own License (BYOL) when leveraging on-premises Enterprise Database
licenses in Oracle Autonomous Database? (Choose all correct answers)
Options are :
Exadata
Muttitenant
Active Data Guard
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
Transparent Data Encryption (TDE) - answer>>>Exadata (Correct)
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
(Correct)
,Which three Oracle Cloud Infrastructure (OCI) resources do you need to
configure before provisioning your Autonomous Database with Private
Endpoint? (Choose all correct answers)
Options are :
Subnet
Route Table
VCN
Network Security Group
Security List - answer>>>Subnet
VCN (Correct)
Network Security Group (Correct)
In the Autonomous Database on Dedicated Infrastructure service, what does
the fleet administrator use to control OCPU utilization?
Options are :
SQL Develope Web Console
Compartment quotas
Resource Manager settings
Oracle Machine Learning notebook - answer>>>Compartment quotas
(Correct)
Autonomous Database's auto scaling feature allows your databa base
number of OCPU cores at any time. As demand increases, auto number of
,cores in use. Likewise, as demand drops, auto scaling automatically cores in
use. Which statement is FALSE regarding the auto scaling feature?
Options are :
The base number of OCPU cores allocated to a database is not guaranteed.
For databases on dedicated Exadata infrastructure, the maximum number of
cores is limited by the number of free cores that aren't being used by other
auto scaling databases to meet high-load demands.
Auto scaling is enabled by default and can be enabled or disabled at any
time.
For databases on dedicated Exadata infrastructure, the maximum number of
cores available to a database depends on the total number of cores available
in the Exadata infrastructure instance. - answer>>>The base number of
OCPU cores allocated to a database is not guaranteed. (Correct)
During the provisioning of an Autonomous Database on dedicated hardware,
what does the database administrator need to select to determine where
the Autonomous Database is created on the dedicated infrastructure?
Options are :
The Listener endpoint where the Autonomous Database should register on
The container database in which the Autonomous instance should run
The compartment of the dedicated infrastructure because each
compartment only runs one dedicated environment
The Client Credentials wallet, which is used to connect to the Autonomous
Database - answer>>>The container database in which the Autonomous
instance should run (Correct)
, Which three are Oracle-recommended best practices for Autonomous
Database alarms? (Choose all correct answers)
Options are :
Create a single alarm for each metric.
Routinely tune your alarms.
Use a single interval for all alarms.
Select the correct alarm interval for your metric.
Create multiple alarm metrics.
Suppress alarms during investigations. - answer>>>Create a single alarm for
each metric. (Correct)
Select the correct alarm interval for your metric. (Correct)
Suppress alarms during investigations. (Correct)
You need to set up a notification for a scheduled shutdown of an
Autonomous Database instance. What should you do?
Options are :
Create an Oracle Cloud Infrastructure Alarm for Shutdown metric.
Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database.
Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous
Database STOP END."
Create a notification alert using DBMS_SNMP package - answer>>>Create a
notification alert using DBMS_SNMP package
Which statement is FALSE about Oracle Autonomous JSON Database?
Options are :
2025–2026 Accurate Real Exam Questions and
Verified Correct Answers JUST RELEASED
Which Database Actions tool is used to get information about the entities in
your Oracle Autonomous Database and to see the effect that changing an
object has on other objects?
Options are :
Data Load
Catalog
Data Insights
JOSN - answer>>>Catalog (Correct)
Which two license types does a customer need to benefit from Bring Your
Own License (BYOL) when leveraging on-premises Enterprise Database
licenses in Oracle Autonomous Database? (Choose all correct answers)
Options are :
Exadata
Muttitenant
Active Data Guard
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
Transparent Data Encryption (TDE) - answer>>>Exadata (Correct)
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
(Correct)
,Which three Oracle Cloud Infrastructure (OCI) resources do you need to
configure before provisioning your Autonomous Database with Private
Endpoint? (Choose all correct answers)
Options are :
Subnet
Route Table
VCN
Network Security Group
Security List - answer>>>Subnet
VCN (Correct)
Network Security Group (Correct)
In the Autonomous Database on Dedicated Infrastructure service, what does
the fleet administrator use to control OCPU utilization?
Options are :
SQL Develope Web Console
Compartment quotas
Resource Manager settings
Oracle Machine Learning notebook - answer>>>Compartment quotas
(Correct)
Autonomous Database's auto scaling feature allows your databa base
number of OCPU cores at any time. As demand increases, auto number of
,cores in use. Likewise, as demand drops, auto scaling automatically cores in
use. Which statement is FALSE regarding the auto scaling feature?
Options are :
The base number of OCPU cores allocated to a database is not guaranteed.
For databases on dedicated Exadata infrastructure, the maximum number of
cores is limited by the number of free cores that aren't being used by other
auto scaling databases to meet high-load demands.
Auto scaling is enabled by default and can be enabled or disabled at any
time.
For databases on dedicated Exadata infrastructure, the maximum number of
cores available to a database depends on the total number of cores available
in the Exadata infrastructure instance. - answer>>>The base number of
OCPU cores allocated to a database is not guaranteed. (Correct)
During the provisioning of an Autonomous Database on dedicated hardware,
what does the database administrator need to select to determine where
the Autonomous Database is created on the dedicated infrastructure?
Options are :
The Listener endpoint where the Autonomous Database should register on
The container database in which the Autonomous instance should run
The compartment of the dedicated infrastructure because each
compartment only runs one dedicated environment
The Client Credentials wallet, which is used to connect to the Autonomous
Database - answer>>>The container database in which the Autonomous
instance should run (Correct)
, Which three are Oracle-recommended best practices for Autonomous
Database alarms? (Choose all correct answers)
Options are :
Create a single alarm for each metric.
Routinely tune your alarms.
Use a single interval for all alarms.
Select the correct alarm interval for your metric.
Create multiple alarm metrics.
Suppress alarms during investigations. - answer>>>Create a single alarm for
each metric. (Correct)
Select the correct alarm interval for your metric. (Correct)
Suppress alarms during investigations. (Correct)
You need to set up a notification for a scheduled shutdown of an
Autonomous Database instance. What should you do?
Options are :
Create an Oracle Cloud Infrastructure Alarm for Shutdown metric.
Add a "BEFORE SHUTDOWN ON DATABASE" trigger within the database.
Create a rule for the Oracle Cloud Infrastructure Event for "Autonomous
Database STOP END."
Create a notification alert using DBMS_SNMP package - answer>>>Create a
notification alert using DBMS_SNMP package
Which statement is FALSE about Oracle Autonomous JSON Database?
Options are :
