Oracle Autonomous Database Cloud 2025 Professional Free Sample Questions

A Private Endpoint creates a private IP address for the Autonomous Database within a private subnet of your VCN. This allows traffic to the database to stay entirely within the OCI network backbone, fulfilling the requirement of not traversing the public internet. An ACL only filters public IP addresses and does not prevent traffic from using the public endpoint. A Service Gateway is for accessing public OCI services from a private subnet, and a NAT Gateway provides outbound internet access, neither of which secures the inbound connection to the database.

Select AI is the specific feature in Autonomous Database designed to translate natural language questions into SQL queries using Generative AI and Large Language Models (LLMs). This allows users without SQL expertise to interact with and analyze data. OML is for building machine learning models, APEX is for building applications, and Oracle Text is for full-text search, none of which provide this natural language-to-SQL capability.

When auto-scaling is enabled for an Autonomous Database on Shared Infrastructure, the system can automatically use up to three times the base number of OCPUs allocated during provisioning. This provides elasticity to handle workload spikes without requiring manual intervention or permanent overprovisioning.

Centrality analysis (e.g., betweenness centrality, degree centrality) is specifically designed to identify the most important or influential nodes within a graph. In a supply chain context, a hub with high centrality is critical because many routes pass through it, and its disruption would have a widespread impact. Pathfinding finds optimal routes but doesn't measure node importance. Community detection groups nodes but doesn't rank them by criticality.

The Autonomous Database needs credentials to authenticate with the Object Storage service. This is done by creating a credential object using the DBMS_CLOUD.CREATE_CREDENTIAL procedure.

Even after creating the credential, the database user performing the query must be explicitly granted READ access on the directory object that points to the Object Storage location. This is a standard Oracle security requirement.

False. Even on Dedicated Infrastructure, Oracle manages the patching and updates as part of the autonomous service. However, unlike on Shared Infrastructure, you have control over the maintenance schedule and can define a specific window for these operations to occur.

Autonomous Data Guard is Oracle's premier disaster recovery solution. It maintains a synchronized physical standby database, providing the lowest RPO (near-zero data loss) and RTO (fast failover). This is the standard for mission-critical applications requiring high availability. Backups and clones are for recovery but do not offer the same near-instantaneous failover capabilities.

When using Data Pump to export or import files directly to or from OCI Object Storage, the CREDENTIAL parameter is mandatory. This parameter specifies the name of the pre-configured database credential object (created with DBMS_CLOUD.CREATE_CREDENTIAL) that allows Data Pump to authenticate with the Object Storage service. DUMPFILE specifies the file URI, but CREDENTIAL provides the necessary access rights.

The Oracle REST Data Services (ORDS) module within Database Actions is the dedicated tool for creating and managing REST APIs based on database objects like tables, views, and PL/SQL procedures. It provides a user-friendly interface to REST-enable database assets. The SQL Worksheet is for running queries, the Data Modeler is for designing schemas, and the JSON workshop is for managing JSON collections.

Autonomous JSON Database is specifically tailored for developers building JSON-centric applications. It provides all the autonomous features but is optimized for storing, indexing, and querying JSON documents using native SODA APIs. While ATP can also handle JSON, AJD is the purpose-built and most cost-effective solution for this specific NoSQL-style workload.