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
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
