1Z0-931-25 practice question 23 of 25

Which two statements are true about accessing the Autonomous Database Tools?

Full set: 149 questions
Answer options
A: Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking. Correct answer
B: Oracle APEX can be accessed only from the Developer menu in the Service Console.
C: Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
D: Access to Database Actions is available for all users of Autonomous Database. Correct answer
E: SQL Developer Web is exclusive to Autonomous Database, not traditional Oracle databases.
Correct Answer:
A. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.; D. Access to Database Actions is available for all users of Autonomous Database.
Explanation

A. When an Autonomous Database is configured with a private endpoint, it receives a private IP address within a subnet of your Virtual Cloud Network (VCN). Consequently, all connections to the database and its associated tools, such as Database Actions, must originate from within that VCN or a network connected to it (e.g., via peering or VPN). This ensures secure, private access.
D. Access to Database Actions is a feature that can be enabled for any database user (schema). While only the ADMIN user has this access by default, an administrator can grant access to any other user by running the ORDS.ENABLESCHEMA procedure. Therefore, the capability is "available for" all users, even if not enabled by default.

Why Incorrect

B. Oracle APEX can be accessed directly via its URL. The Service Console provides a convenient link but is not the exclusive method of access.
C. Oracle Machine Learning (OML) is a feature available with all Autonomous Database workload types, including both Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP).
E. SQL Developer Web is a component of Oracle REST Data Services (ORDS), which can be installed and configured for use with traditional on-premises or cloud Oracle Databases.

References

1. Correctness of A: Oracle Cloud Infrastructure Documentation, Connect to Autonomous Database with a Private Endpoint. This document states, "To connect to an Autonomous Database that has a private endpoint, your client or application must be in the same VCN as the Autonomous Database...". This principle applies to tool access as well.

2. Correctness of D: Oracle Cloud Infrastructure Documentation, Manage User Access to Database Actions. The documentation specifies, "By default, the ADMIN database user has access to Database Actions. For other database users... you must enable access." It then details using ORDS.ENABLESCHEMA to enable access for any schema, confirming the feature is available to be granted to any user.

3. Incorrectness of B: Oracle Cloud Infrastructure Documentation, Access Oracle APEX. This guide shows how to access APEX from the console and also notes, "You can also access Oracle APEX directly through the URL for your database's APEX instance."

4. Incorrectness of C: Oracle Cloud Infrastructure Documentation, About Oracle Machine Learning on Autonomous Database. The documentation introduces OML as "a feature of Oracle Autonomous Database," without restricting it to a specific workload type like ADW.

5. Incorrectness of E: Oracle REST Data Services Documentation, About SQL Developer Web. This document describes SQL Developer Web as a browser-based interface included with Oracle REST Data Services, which can be deployed with Oracle Database 11g Release 2 or later.

Scroll to Top