Which is NOT a typical function provided by a NoSQL Database Cloud Service SDK related to data operations?

1. A. Automatically optimizing query execution plans for best performance.
2. B. Constructing requests to insert, update, or delete data records.
3. C. Serializing and deserializing data between application objects and database records.
4. D. Handling pagination of query results.

Correct Answer: A

While operating a MySQL HeatWave cluster, you need to resize the HeatWave cluster to accommodate an increased workload. Which method is the most efficient and recommended way to scale the HeatWave cluster?

1. A. Manually altering the innodb_buffer_pool_size and restarting the MySQL server.
2. B. Using the OCI CLI or Console to adjust the HeatWave cluster's shape and node count.
3. C. Modifying the underlying VM shapes of the MySQL Database System.
4. D. Recreating the HeatWave cluster with the desired size.
5. E. Performing a manual data export and import into a new, larger MySQL DatabaseSystem.

Correct Answer: B

If the provisioned read capacity units (RCUs) are consistently underutilized for a NoSQL Database Cloud Service table, what is the MOST direct consequence?

1. A. Improved query performance.
2. B. Increased storage efficiency.
3. C. Unnecessary cost expenditure.
4. D. Reduced data durability.

Correct Answer: C

Which two actions must you undertake when configuring the networking to provide network connectivity for a MySQL HeatWave DB System instance?

1. A. Ensure the subnet used has a Service Gateway to Oracle Services, such as Object Storage, so that patching can be applied.
2. B. Deploy the MySQL HeatWave DB System to a public subnet to allow external connectivity for users.
3. C. Create ingress security rules in the VCN security list or Network Security Groups (NSGs) to allow traffic to the MySQL HeatWave DB System.
4. D. Configure a dynamic routing gateway for inter-VCN connectivity.
5. E. Create egress security rules in the VCN security list or Network Security Groups (NSGs)to block access from the MySQL HeatWave DB System to any outside network.

Correct Answer: AC

Oracle NoSQL Database Cloud Service's key-value model is well-suited for certain types of
applications. Which of the following application scenarios would most directly benefit from the key-value data model's characteristics?

1. A. An application requiring complex analytical queries and joins across multiple related datasets.
2. B. A social media platform needing to store and retrieve individual user profiles and their associated data quickly.
3. C. A financial system requiring strict transactional integrity and complex relationships between accounts and transactions.
4. D. A content management system needing to enforce a rigid schema for all documents and their metadata.
5. E. An enterprise resource planning (ERP) system managing intricate relationships between various business entities.

Correct Answer: B