Tag Archives: autonomous

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).How can they achieve this? A. Change the Automatic Maintenance Schedule to ‘None’d. B. Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day. C. You cannot permanently disable scheduled Automatic Maintenance. D.… Read More »

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support? A. 900 B. 1800 C. 2700 D. 1500 Correct… Read More »

Which statement is FALSE about Oracle Autonomous JSON Database?

Which statement is FALSE about Oracle Autonomous JSON Database? A. JSON data is stored natively in the database B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing C. It supports NoSQL-style, document-centric application D. There is a 20 GB limit on JSON collection Correct Answer: D

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? A. Oracle Machine Learning notebook B. Compartment quotas C. Resource Manager settings D. SQL Developer Web Console Correct Answer: B https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? A. Parallelism is not enabled by default. B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default. C. Oracle Database Result Cache is enabled by default for all SQL statements. D. You have direct access to the… Read More »

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints B. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an… Read More »