ADB Certification Exam Questions with accurate solutions

$15.99

Preview 3 out of 21 pages

Exam (elaborations)

ADB Certification Exam Questions with accurate solutions

0.0

(0 reviews)

- sold

21 pages

2025/2026

Institution ADB

Course ADB

Preview 3 out of 21 pages

ADB Certification Exam Questions with accurate solutions

Content preview

ADB Certification Exam Questions with accurate
|!| |!| |!| |!| |!| |!|

solutions

Which are the things required for provisioning an ADB instance? (Choose
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

three)

- FRA Size
|!| |!|

- Database name
|!| |!|

- Workload type
|!| |!|

- Backup location
|!| |!|

- Number of tablespaces
|!| |!| |!|

- Number of CPUs - correct answer✔✔- Database name
|!| |!| |!| |!| |!| |!| |!| |!|

- Workload type
|!| |!|

- Number of CPUs
|!| |!| |!|

What is the default port number for ATP?
|!| |!| |!| |!| |!| |!| |!|

- 1525|!|

- 1521|!|

- 1527|!|

- 1522 - correct answer✔✔1522
|!| |!| |!| |!|

How many CPU shares can be used by a SQL statement in a Low database
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

service?
|!|

- 4 |!|

- 3 |!|

- 2 |!|

- 1 - correct answer✔✔1
|!| |!| |!| |!|

,Which are the capabilities of Oracle Autonomous Database that can
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

accelerate innovation? (Choose three) |!| |!| |!|

- Instant scaling of storage
|!| |!| |!| |!|

- Scaling of CPUs with very minimum downtime
|!| |!| |!| |!| |!| |!| |!|

- Built-in AI and ML helps find patterns that could identify undiscovered
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

anomalies

- Provisions data warehouse in seconds - correct answer✔✔- Instant scaling
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

of storage
|!| |!|

- Built-in AI and ML helps find patterns that could identify undiscovered
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

anomalies

- Provisions data warehouse in seconds
|!| |!| |!| |!| |!|

In which Oracle client credentials' file (wallet file) can we find the port
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

number?

- ojdbc.properties
|!|

- truststore.jks
|!|

- sqlnet.ora
|!|

- tnsnames.ora
|!|

- listener.ora - correct answer✔✔tnsnames.ora
|!| |!| |!| |!|

Which statements are true about ADB? (Choose two)
|!| |!| |!| |!| |!| |!| |!|

- Instant scaling available for CPUs only
|!| |!| |!| |!| |!| |!|

- Provisioning takes a long time
|!| |!| |!| |!| |!|

- Reduces data management costs
|!| |!| |!| |!|

- Reduces the administration costs with complete automation of operations
|!| |!| |!| |!| |!| |!| |!| |!| |!|

and tuning
|!| |!|

- Scaling for storage needs a restart - correct answer✔✔- Reduces data
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

management costs |!|

, - Reduces the administration costs with complete automation of operations
|!| |!| |!| |!| |!| |!| |!| |!| |!|

and tuning
|!| |!|

Which statements are true about OCI compartments? (Choose two)
|!| |!| |!| |!| |!| |!| |!| |!|

- Compartments are used to organize resources and make it easy to
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

control access |!|

- An administrator can create more compartments in the root compartment
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

- A user should create the root compartment before provisioning the
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

instance

- A user can have only one compartment - correct answer✔✔-
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

Compartments are used to organize resources and make it easy to control |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

access

- An administrator can create more compartments in the root compartment
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

What is the number of concurrent queries supported by the medium
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

database service with 16 OCPUs? |!| |!| |!| |!|

- 3 |!|

- 40 |!|

- 32 |!|

- 20 - correct answer✔✔20
|!| |!| |!| |!|

From which cloud services does DBMS_CLOUD provide support for loading
|!| |!| |!| |!| |!| |!| |!| |!| |!| |!|

data from files to tables in ADB? (Choose three)
|!| |!| |!| |!| |!| |!| |!| |!|

- Dell EMC Elastic Cloud Storage
|!| |!| |!| |!| |!|

- Amazon AWS S3
|!| |!| |!|

- OCI Object Storage Classic
|!| |!| |!| |!|

- OCI Object Storage
|!| |!| |!|

- IBM Spectrum Storage - correct answer✔✔- Amazon S3
|!| |!| |!| |!| |!| |!| |!| |!|

- OCI Object Storage Classic
|!| |!| |!| |!|

Document information

Uploaded on: August 10, 2025
Number of pages: 21
Written in: 2025/2026
Type: Exam (elaborations)
Contains: Questions & answers

Report Copyright Violation

$15.99

Written by students who passed

Immediately available after payment

Read online or as PDF

Ruiz

3.2

(15)

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

Can't I just make this for free with AI?

AI tools give you vast, general information. They don't know your course, your professor, or what actually gets asked in your exam. This document was written by a fellow student who understood the nuances of exactly this course and passed it. You get focused, curated study material, not a generic starting point you still have to rework.

Is this document still relevant for my course?

Every document shows the academic year, the linked textbook, and the institution, so you can check upfront whether it matches your course. Take a look at the free preview too to see if it fits.

What if the document isn't what I hoped?

No worries! If you change your mind within 14 days of purchase and have not downloaded the document yet, you will get a refund. Your purchase is completely risk-free.

Who am I actually buying from?

Stuvia is a marketplace: you buy directly from the student who created the document. Stuvia handles payment securely and backs every purchase with the free exchange guarantee, so you never take on any risk.

Will I be stuck with a subscription?

No. You pay $15.99 once for this document and nothing more. No subscription, no auto-renewal, no fine print.

What do I get when I buy this document?

You get a PDF that is available immediately after payment. You can read the document online or download it, and it stays accessible through your profile indefinitely.

Why can I trust Stuvia?

4.6 stars on Google and Trustpilot from over 2,000 reviews. In the past 30 days 40417 documents were sold through Stuvia internationally. And we have been doing this for 16 years now. Every document also shows its rating and how many times it has been sold.

ADB Certification Exam Questions with accurate solutions

Content preview

Document information

More like this

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

Can't I just make this for free with AI?

Is this document still relevant for my course?

What if the document isn't what I hoped?

Who am I actually buying from?

Will I be stuck with a subscription?

What do I get when I buy this document?

Why can I trust Stuvia?

ADB Certification Exam Questions with accurate solutions

Content preview

Document information

Browse related subjects

Subjects

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Working on your references?

Frequently asked questions

Can't I just make this for free with AI?

Is this document still relevant for my course?

What if the document isn't what I hoped?

Who am I actually buying from?

Will I be stuck with a subscription?

What do I get when I buy this document?

Why can I trust Stuvia?