ADB Certification Questions and Answers 100% Verified

ADB Certification
A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck
is in the storage I/Os of their environment. What should they do to remove this bottleneck?

Options are :

Run the PBMS_CLOUD. INCREASE_THROUGHPUT procedure.

Ask Support to migrate their setup to a node without noisy neighbors.

Increase the number of OCPUs allocated to the database.

Remove any non-JSON data from the database. - Increase the number of OCPUs allocated to the
database. (Correct)



A new Python developer has joined your team and needs to access the Autonomous Database (ADB)
data. How does the developer connect to and interact with ADB from Python?

Options are :

Using JDBC Driver

Using SQL Developer

Using the Oracle Client and the cx_Oracle interface - Using the Oracle Client and the cx_Oracle
interface (Correct)



An Autonomous Database (ADB) user with an instance wallet has left the company. The user had shared
a database user ID with other users when accessing ADB. Other than changing the shared user
password, what can an administrator do to protect the instance?

Options are :

Delete the user.

Trust the user who left to not access the database.

Rotate the instance wallet and share the new wallet with the remaining users.

Shut down and restart the instance. - Rotate the instance wallet and share the new wallet with
the remaining user

,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. -
The base number of OCPU cores allocated to a database is not guaranteed. (Correct)



Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary
database indicates that it is Stopped. Which statement is true?

-Failover is automatically initiated.

-The standby database is also stopped.

-The standby database is terminated.

-Switchover is automatically initiated. - The standby database is also stopped



DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backup of
this database periodically. What must be the name of the bucket that will be used to store manual
backups?

Options are :

BACKUP_DBSRV1

BACKUP_PRODDB

backup_proddb

backup_dbsrv1 - backup_dbsrv1 (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 - The
container database in which the Autonomous instance should run (Correct)



For which resource consumption will you be charged when your Autonomous Database is stopped
temporarily?

Options are :

data security

allocated number of OCPUs

allocated storage

network consumption - allocated storage (Correct)



How do you change the tablespace quota for user mrizo on Autonomous Database on Shared
Infrastructure?

Options are :

Execute alter database for user MTHEO tablespace DATA quota = 10G;

Execute alter user MTHEO quota unlimited on tablespace DATA;

Execute nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO�, tablespace quota
~> "UNLIMITED') ;

Execute alter tablespace DATA set quota = 10G; - Execute
nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO�, tablespace quota ~>
"UNLIMITED') ; (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