ADB Certification Exam UPDATED
QUESTIONS AND CORRECT ANSWERS
You see a clock icon in the Status column on the SQL Monitoring tabof the Performance
Hub. What does it indicate? - CORRECT ANSWER The SQL statement is queued
Which three event types are supported for Autonomous Database?(Choose all correct
answers) - CORRECT ANSWER Maintenance BeginTerminate EndChange
Compartment Begin
You have a requirement to create an Autonomous TransactionProcessing database that can
support up. to 300 concurrentstatements per OCPU as well as parallelism. Which service will
youneed to connect to? - CORRECT ANSWER TPURGENT
Which two actions are available to perform when an AutonomousDatabase is stopped?
(Choose all correct answers) - CORRECT ANSWER - Start
- Update License Type
When cloning from a backup, what is the earliest timestamp of the backup allowed? -
CORRECT ANSWER 2 hours
Which set of Oracle Cloud Infrastructure metrics is available only forAutonomous Database
on Dedicated Infrastructure? - CORRECT ANSWER IOPS, Storage Space Used By
Tablespace, Apply and Transport Lag Dedicated
Which three tools can be used to monitor the usage and activities of Autonomous Database
on Infrastructure? (Choose all correct answers) - CORRECT ANSWER Performance
Hub
OCI metrics
Enterprise Manager Cloud Control
, 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? -
CORRECT ANSWER Catalog
Which two license types does a customer need to benefit from Bring Your Own License
(BYOL) when leveraging on-premises EnterpriseDatabase licenses in Oracle Autonomous
Database? (Choose all correct answers) - CORRECT ANSWER Multitenant
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
Which three Oracle Cloud Infrastructure (OCI) resources do youneed to configure before
provisioning your Autonomous Database with Private Endpoint? (Choose all correct answers)
- CORRECT ANSWER Subnet
VCN
Network Security Group
In the Autonomous Database on Dedicated Infrastructure service,what does the fleet
administrator use to control OCPU utilization? - CORRECT ANSWER Compartment
quotas
Autonomous Database's auto scaling feature allows your database number of OCPU cores at
any time. As demand increases, autonumber of cores in use. Likewise, as demand drops, auto
scaling automatically cores in use. Which statement is FALSE regarding theauto scaling
feature? - CORRECT ANSWER 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.
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? - CORRECT ANSWER The container database in
which the Autonomous instance should run
Which three are Oracle-recommended best practices for Autonomous Database alarms?
(Choose all correct answers) - CORRECT ANSWER Routinely tune you alarms
Select the correct alarm interval for your metric
QUESTIONS AND CORRECT ANSWERS
You see a clock icon in the Status column on the SQL Monitoring tabof the Performance
Hub. What does it indicate? - CORRECT ANSWER The SQL statement is queued
Which three event types are supported for Autonomous Database?(Choose all correct
answers) - CORRECT ANSWER Maintenance BeginTerminate EndChange
Compartment Begin
You have a requirement to create an Autonomous TransactionProcessing database that can
support up. to 300 concurrentstatements per OCPU as well as parallelism. Which service will
youneed to connect to? - CORRECT ANSWER TPURGENT
Which two actions are available to perform when an AutonomousDatabase is stopped?
(Choose all correct answers) - CORRECT ANSWER - Start
- Update License Type
When cloning from a backup, what is the earliest timestamp of the backup allowed? -
CORRECT ANSWER 2 hours
Which set of Oracle Cloud Infrastructure metrics is available only forAutonomous Database
on Dedicated Infrastructure? - CORRECT ANSWER IOPS, Storage Space Used By
Tablespace, Apply and Transport Lag Dedicated
Which three tools can be used to monitor the usage and activities of Autonomous Database
on Infrastructure? (Choose all correct answers) - CORRECT ANSWER Performance
Hub
OCI metrics
Enterprise Manager Cloud Control
, 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? -
CORRECT ANSWER Catalog
Which two license types does a customer need to benefit from Bring Your Own License
(BYOL) when leveraging on-premises EnterpriseDatabase licenses in Oracle Autonomous
Database? (Choose all correct answers) - CORRECT ANSWER Multitenant
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
Which three Oracle Cloud Infrastructure (OCI) resources do youneed to configure before
provisioning your Autonomous Database with Private Endpoint? (Choose all correct answers)
- CORRECT ANSWER Subnet
VCN
Network Security Group
In the Autonomous Database on Dedicated Infrastructure service,what does the fleet
administrator use to control OCPU utilization? - CORRECT ANSWER Compartment
quotas
Autonomous Database's auto scaling feature allows your database number of OCPU cores at
any time. As demand increases, autonumber of cores in use. Likewise, as demand drops, auto
scaling automatically cores in use. Which statement is FALSE regarding theauto scaling
feature? - CORRECT ANSWER 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.
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? - CORRECT ANSWER The container database in
which the Autonomous instance should run
Which three are Oracle-recommended best practices for Autonomous Database alarms?
(Choose all correct answers) - CORRECT ANSWER Routinely tune you alarms
Select the correct alarm interval for your metric
