ADB CERTIFICATION PRACTICE QUESTIONS &
ANSWERS VERIFIED 100% CORRECT!!
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 Answer - - Database name
- Workload type
- Number of CPUs
What is the default port number for ATP?
- 1525
- 1521
- 1527
- 1522 Answer - 1522
How many CPU shares can be used by a SQL statement in a Low database
service?
-4
-3
-2
- 1 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 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 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 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 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 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 Answer - - Amazon S3
- OCI Object Storage Classic
- OCI Object Storage
ANSWERS VERIFIED 100% CORRECT!!
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 Answer - - Database name
- Workload type
- Number of CPUs
What is the default port number for ATP?
- 1525
- 1521
- 1527
- 1522 Answer - 1522
How many CPU shares can be used by a SQL statement in a Low database
service?
-4
-3
-2
- 1 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 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 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 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 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 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 Answer - - Amazon S3
- OCI Object Storage Classic
- OCI Object Storage
