ADB Certification Questions and Answers 100% Verified
7 views 0 purchase
Course
ADB Certification
Institution
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 ...
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 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ACADEMICMATERIALS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
