1Z0-184-25 Question 139
Single answerYou have developed a Red-Amber-Green (RAG) performance-tracking application in PL/SQL that runs on an Autonomous Database in Oracle Cloud Infrastructure. The PL/SQL code evaluates runtime metrics and assigns a color-coded status (Red, Amber, or Green) for different service components. You need to make this status available to external applications in realtime, while following recommended practices for minimal overhead and secure access. Which approach should you use?
- A
Embed DBMS_OUTPUT statements in the PL/SQL procedure and parse the output via a database listener on the external side.
- B
Expose the PL/SQL procedure through Oracle REST Data Services (ORDS) on the Autonomous Database and secure it with an OAuth token to allow external calls.
- C
Schedule a database job to write RAG statuses to files on an OCI Object Storage bucket and grant external systems read access to the bucket.
- D
Invoke the PL/SQL procedure through a local PL/SQL gateway on a separate on-premises Oracle Database and replicate data back to OCI.
Show answer and explanation
Correct answer: B
Explanation
The recommended approach for real-time, secure integration of PL/SQL logic in an Oracle Autonomous Database environment is to use Oracle REST Data Services (ORDS). This allows you to publish a PL/SQL procedure as a REST endpoint with appropriate authentication (for example, OAuth), balancing ease of external consumption with security. Refer to Oracle REST Data Services documentation (https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/index.html) for details on enabling REST endpoints in an Autonomous Database.
- A. Incorrect.
Incorrect. Using DBMS_OUTPUT is suitable for debugging or internal logs, not for stable, real-time integration. Relying on a listener to parse output is not a recommended or secure practice for external consumption.
- B. Correct.
Correct. Oracle REST Data Services (ORDS) lets you REST-enable your PL/SQL procedures in an Autonomous Database. By securing the endpoint with OAuth tokens, you ensure both ease of access for external systems and proper security controls.
- C. Incorrect.
Incorrect. Writing files to Object Storage for each update adds overhead and isn�t designed for real-time interactive calls. It also complicates security and data freshness.
- D. Incorrect.
Incorrect. Using a separate on-premises gateway involves unnecessary replication and complexity. Real-time retrieval depends on direct connectivity to the Autonomous Database rather than a third-party replication process.