ADB Certification Practice
Questions with Correct Verified
Answers 2024/2025
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 - ANS ✔- Database name
- Workload type
- Number of CPUs
What is the default port number for ATP?
- 1525
- 1521
- 1527
ADB Certification Practice Questions with Correct Verified Answers 2024/2025 2
- 1522 - ANS ✔1522
How many CPU shares can be used by a SQL statement in a Low database service?
- 4
- 3
- 2
- 1 - ANS ✔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 - ANS ✔- Instant scaling of storage
- Built-in AI and ML helps find patterns that could identify undiscovered anomalies
- Provisions data warehouse in seconds
ADB Certification Practice Questions with Correct Verified Answers 2024/2025 3
In which Oracle client credentials' file (wallet file) can we find the port number?
- ojdbc.properties
- truststore.jks
- sqlnet.ora
- tnsnames.ora
- listener.ora - ANS ✔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 - ANS ✔- Reduces data management costs
- Reduces the administration costs with complete automation of operations and tuning
Which statements are true about OCI compartments? (Choose two)
ADB Certification Practice Questions with Correct Verified Answers 2024/2025