ADB Certification Practice Questions With Correct & Verified Answers Latest 2026/2027 Graded A+.

ADB Certification Practice Questions With Correct & Verified Answers Latest 2026/2027 Graded A+. 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 - 1522 - ANS 1522 2 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 How many CPU shares can be used by a SQL statement in a Low database service? - 4 - 3 - 2 - 1 - ANS 1 What is the number of concurrent queries supported by the medium database service with 16 OCPUs? 3 - 3 - 40 - 32 - 20 - ANS 20 In which Oracle client credentials' file (wallet file) can we find the port number? - rties - - - - - ANS Which statements are true about ADB? (Choose two) - Instant scaling available for CPUs only - Provisioning takes a long time - Reduces data management costs 4 - 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) - 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 - ANS - Compartments are used to organize resources and make it easy to control access - An administrator can create more compartments in the root compartment 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