ADB Certification Practice Questions and Answers New (2024/2025) Solved 100% Correct

ADB Certification Practice Questions
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 - - Database name

- Workload type

- Number of CPUs



From where can you create Oracle Machine Learning users?

- From the Admin Password tab from the Details tab

- From the Administration tab in the Service Console

- From the Activity tab in the Service tab

- From the Overview tab in the Service Console - From the Administration tab in the Service
Console



From which cloud services can Oracle Data Pump import data from dump files to ADB? (Choose three)

- AWS S3

- OCI Object Storage Classic

- OCI Object Storage

- IBM Spectrum Storage

- Dell EMC Elastic Cloud Storage

- Azure Blob Storage - - AWS S3

- OCI Object Storage Classic

- OCI Object Storage

,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 - - Amazon S3

- OCI Object Storage Classic

- OCI Object Storage



How does data pump load and unload table data?

- Direct path

- External tables

- Both - Both



How many CPU shares can be used by a SQL statement in a Low database service?

-4

-3

-2

-1- 1



How many SQL statements can a paragraph contain?

-1

-5

- 10

-2 - 1

, In Oracle Machine Learning, in which file format can SQL Scripts be saved?

- SQL

- ORC

- AVRO

- JSON - JSON



In Oracle Machine Learning, when you access the Compute Resources page as the Administrator user,
which connection details do you get to see? (Choose three)

- Comment

- Service Name

- Host

- Name - - Comment

- Host

- Name



In Oracle OAC, from which of the following can you create a data set?

- Connection

- File

- all of the above

- Subject Area - All of the above



In which Oracle client credentials' file (wallet file) can we find the port number?

- ojdbc.properties

- truststore.jks

- sqlnet.ora

- tnsnames.ora

- listener.ora - tnsnames.ora