OCI FOUNDATIONS EXAMS SET 2025/2026 QUESTIONS
WITH ANSWERS RATED A+
✔✔1. Which statement about the working of autoscaling in an instance pool is true?
a. It can perform only schedule-based autoscaling.
b. It can perform only metric-based autoscaling.
c. It automatically provisions and removes instances in an instance pool.
d. It automatically changes the shape of the compute instance to increase the number
of OCPU count and memory. - ✔✔It automatically provisions and removes instances in
an instance pool.
✔✔1. Which two parameters can be customized when creating a flexible shape
compute instance?
a. Number of OCPUs
b. Number of physical NICs
c. Amount of memory
d. Number of virtual NICs - ✔✔Number of OCPUs, Amount of memory
✔✔1. What type of storage is associated with instances in the OCI Compute services?
a. Archive Storage
b. Object Storage
c. File Storage
d. Block Storage - ✔✔Block Storage
✔✔1. What feature of the Oracle Cloud Infrastructure Block Volume service ensure data
durability and protection against hardware failure?
a. Deduplication
b. Replication
c. Compression
d. Encryption - ✔✔Replication
✔✔1. You have created an Object Storage bucket of Archive tier. Which statement is
NOT valid for Archive Storage tier?
a. From the time a restore request is made, it takes at most an hour to read the data.
b. The minimum duration to store objects is 90 days.
c. The default time available to download an object after restoration is 24 hours.
d. The Archive storage bucket can be upgraded to Standard storage. - ✔✔The Archive
storage bucket can be upgraded to Standard storage.
✔✔1. You have an extremely high performance database workload that requires at
least 90 IOPS/GB and 90,000 IOPS per volume. Which OCI Block Volume performance
level can be used to meet this requirement?
a. Ultra High Performance
b. High Performance
c. Lower Cost
, d. Balanced - ✔✔Ultra High Performance
✔✔1. In the Oracle Cloud Infrastructure Object Storage Service, what is the primary
purpose of a pre-authenticated request URL?
a. To track and monitor object access and usage.
b. To enable automatic transition of objects between storage tiers
c. To enable public read access to specific object
d. To provide temporary and secure access to a specific object - ✔✔To provide
temporary and secure access to a specific object
✔✔1. You want to store the backup of a database in cloud storage for an extended
period at the lowest storage cost. Which object storage tier would you use for storing
these backup files?
a. Infrequent Access
b. Archive
c. Standard
d. Premium - ✔✔Archive
✔✔1. Which type of processing does MySQL HeatWave primarily enable MySQL to
handle efficiently?
a. Online Transaction Processing (OLTP)
b. Data lake processing
c. Data warehouse processing
d. Online Analytical Processing (OLAP) - ✔✔Online Analytical Processing (OLAP)
✔✔1. Which feature of Oracle Autonomous Database enable automatic database
optimization without manual intervention?
a. Self-repairing
b. Autoscaling
c. Self-Driving
d. Self-Securing - ✔✔Self-Driving
✔✔1. Which is NOT a supported workload type for Oracle Autonomous Database?
a. MySQL
b. Transaction Processing
c. JSON
d. Data Warehouse - ✔✔MySQL
✔✔1. How does MySQL HeatWave enable accelerated query performance?
a. By using in-memory data storage
b. By partitioning the into smaller subsets
c. By compressing the data for faster retrieval
d. By replicating data across multiple databases - ✔✔By using in-memory data storage
WITH ANSWERS RATED A+
✔✔1. Which statement about the working of autoscaling in an instance pool is true?
a. It can perform only schedule-based autoscaling.
b. It can perform only metric-based autoscaling.
c. It automatically provisions and removes instances in an instance pool.
d. It automatically changes the shape of the compute instance to increase the number
of OCPU count and memory. - ✔✔It automatically provisions and removes instances in
an instance pool.
✔✔1. Which two parameters can be customized when creating a flexible shape
compute instance?
a. Number of OCPUs
b. Number of physical NICs
c. Amount of memory
d. Number of virtual NICs - ✔✔Number of OCPUs, Amount of memory
✔✔1. What type of storage is associated with instances in the OCI Compute services?
a. Archive Storage
b. Object Storage
c. File Storage
d. Block Storage - ✔✔Block Storage
✔✔1. What feature of the Oracle Cloud Infrastructure Block Volume service ensure data
durability and protection against hardware failure?
a. Deduplication
b. Replication
c. Compression
d. Encryption - ✔✔Replication
✔✔1. You have created an Object Storage bucket of Archive tier. Which statement is
NOT valid for Archive Storage tier?
a. From the time a restore request is made, it takes at most an hour to read the data.
b. The minimum duration to store objects is 90 days.
c. The default time available to download an object after restoration is 24 hours.
d. The Archive storage bucket can be upgraded to Standard storage. - ✔✔The Archive
storage bucket can be upgraded to Standard storage.
✔✔1. You have an extremely high performance database workload that requires at
least 90 IOPS/GB and 90,000 IOPS per volume. Which OCI Block Volume performance
level can be used to meet this requirement?
a. Ultra High Performance
b. High Performance
c. Lower Cost
, d. Balanced - ✔✔Ultra High Performance
✔✔1. In the Oracle Cloud Infrastructure Object Storage Service, what is the primary
purpose of a pre-authenticated request URL?
a. To track and monitor object access and usage.
b. To enable automatic transition of objects between storage tiers
c. To enable public read access to specific object
d. To provide temporary and secure access to a specific object - ✔✔To provide
temporary and secure access to a specific object
✔✔1. You want to store the backup of a database in cloud storage for an extended
period at the lowest storage cost. Which object storage tier would you use for storing
these backup files?
a. Infrequent Access
b. Archive
c. Standard
d. Premium - ✔✔Archive
✔✔1. Which type of processing does MySQL HeatWave primarily enable MySQL to
handle efficiently?
a. Online Transaction Processing (OLTP)
b. Data lake processing
c. Data warehouse processing
d. Online Analytical Processing (OLAP) - ✔✔Online Analytical Processing (OLAP)
✔✔1. Which feature of Oracle Autonomous Database enable automatic database
optimization without manual intervention?
a. Self-repairing
b. Autoscaling
c. Self-Driving
d. Self-Securing - ✔✔Self-Driving
✔✔1. Which is NOT a supported workload type for Oracle Autonomous Database?
a. MySQL
b. Transaction Processing
c. JSON
d. Data Warehouse - ✔✔MySQL
✔✔1. How does MySQL HeatWave enable accelerated query performance?
a. By using in-memory data storage
b. By partitioning the into smaller subsets
c. By compressing the data for faster retrieval
d. By replicating data across multiple databases - ✔✔By using in-memory data storage
