Users and applications must be able to access a web server of type https using database package UTL_HTTP. Which three are part of the configuration to make this possible?

Question

Options

• AConfigure liscener.oia with an endpolnt for tcps
• BConfigure sqinet.ora with parameter sq.lnet.encrypt70N_server
• CDownload the root certificate from the Certificate Authority In Base64 format
• DConfigure sqlnet. ora with parameter tcp . invited_nodes
• EDownload the trusted certificate of the web server in Base64 format a
• FConfigure an Oracle wallet using mkstore or Wallet Manager
• GConfigure access control lists using DBMS_NETWORK_ACL._ADMIN

• A
  3% (1)
• B
  69% (20)
• C
  7% (2)
• E
  3% (1)
• G
  17% (5)

Explanation

Note: The stated correct answer (B, D, F) appears to be incorrect for this scenario. The actual correct answers for configuring UTL_HTTP to access HTTPS web servers are most likely C, F, and G (or E, F, G depending on the exam's intent). Here's why:

Why C, F, and G are correct:

• F (Oracle Wallet) is essential - it stores the SSL/TLS certificates Oracle needs to establish a trusted HTTPS connection via UTL_HTTP.
• C or E (Download certificate in Base64) is required because you must import the web server's trusted certificate (or its root CA certificate) into the wallet so Oracle can verify the server's identity.
• G (DBMS_NETWORK_ACL_ADMIN) is mandatory - Oracle requires ACLs to grant database users permission to make outbound network calls; without this, UTL_HTTP will raise an "insufficient privileges" error.

Why the other options are wrong:

• A - listener.ora with tcps governs inbound encrypted connections to the Oracle database, not outbound UTL_HTTP calls.
• B - SQLNET.ENCRYPTION_SERVER encrypts Oracle Net client-to-server connections, unrelated to UTL_HTTP HTTPS traffic.
• D - tcp.invited_nodes restricts which hosts can connect to the Oracle listener - irrelevant to outbound HTTPS.

Memory tip: Think "W-A-C" - Wallet (store certs), ACL (grant access), Certificate (trust the server). If you can't trust the server and can't get permission to call out, HTTPS will never work.

If this question is from a specific Oracle certification exam, I'd recommend double-checking the answer key - B and D do not align with UTL_HTTP HTTPS configuration in any standard Oracle documentation.

No community discussion yet for this question.