Oracle ADB (Autonomous Database)
Certification Exam (Latest Update
) Questions and Answers
| Grade A | 100% Correct
Question:
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 :
a) Data Load
b) Catalog
c) Data Insights
d) JOSN
Answer:
Catalog (Correct)
,Question:
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 :
a) Exadata
b) Muttitenant
c) Active Data Guard
d) Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
e) Transparent Data Encryption (TDE)
Answer:
Exadata (Correct)
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
(Correct)
Question:
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 :
a) Subnet
b) Route Table
c) VCN
d) Network Security Group
,e) Security List
Answer:
Subnet
VCN (Correct)
Network Security Group (Correct)
Question:
In the Autonomous Database on Dedicated Infrastructure service, what does
the fleet administrator use to control OCPU utilization?
Options are :
a) SQL Develope Web Console
b) Compartment quotas
c) Resource Manager settings
d) Oracle Machine Learning notebook
Answer:
Compartment quotas (Correct)
Question:
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 :
a) The base number of OCPU cores allocated to a database is not guaranteed.
b) 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.
c) Auto scaling is enabled by default and can be enabled or disabled at any
time.
d) 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)
Question:
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 :
a) The Listener endpoint where the Autonomous Database should register on
b) The container database in which the Autonomous instance should run
c) The compartment of the dedicated infrastructure because each
compartment only runs one dedicated environment
d) The Client Credentials wallet, which is used to connect to the Autonomous
Database
Certification Exam (Latest Update
) Questions and Answers
| Grade A | 100% Correct
Question:
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 :
a) Data Load
b) Catalog
c) Data Insights
d) JOSN
Answer:
Catalog (Correct)
,Question:
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 :
a) Exadata
b) Muttitenant
c) Active Data Guard
d) Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
e) Transparent Data Encryption (TDE)
Answer:
Exadata (Correct)
Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs
(Correct)
Question:
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 :
a) Subnet
b) Route Table
c) VCN
d) Network Security Group
,e) Security List
Answer:
Subnet
VCN (Correct)
Network Security Group (Correct)
Question:
In the Autonomous Database on Dedicated Infrastructure service, what does
the fleet administrator use to control OCPU utilization?
Options are :
a) SQL Develope Web Console
b) Compartment quotas
c) Resource Manager settings
d) Oracle Machine Learning notebook
Answer:
Compartment quotas (Correct)
Question:
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 :
a) The base number of OCPU cores allocated to a database is not guaranteed.
b) 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.
c) Auto scaling is enabled by default and can be enabled or disabled at any
time.
d) 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)
Question:
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 :
a) The Listener endpoint where the Autonomous Database should register on
b) The container database in which the Autonomous instance should run
c) The compartment of the dedicated infrastructure because each
compartment only runs one dedicated environment
d) The Client Credentials wallet, which is used to connect to the Autonomous
Database
