ADB Exam Questions and Answers New (2024/2025) Solved 100% Correct
4 views 0 purchase
Course
ADB
Institution
ADB
Which is a difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction
Processing (ATP) databases?
-Only ATP manages optimizer statistics
-Only ADW uses columnar compression by default
-Only ATP supports automatic backups
-Only ADW supports autoscaling - -Only ADW uses column...
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?
-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
You see a clock icon in the Status column on the SQL Monitoring tab of the Performance Hub. What does
it indicate?
-The SQL statement completed its execution
-The SQL statement is executing
-The SQL statement is queued
-The SQL statement did not complete due to an error - -The SQL statement is queued
, 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?
-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
How do you change the tablespace quota for user mrizo on autonomous database on shared
infrastructure?
-Execute alter database for user MTHEO tablespace DATA quota = 10G
-execute alter user MTHEO quota unlimited on tablespace DATA
Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
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.
