1Z0-116 practice question 4 of 15

For which two reasons would you define Network ACLs?

Full set: 90 questions
Answer options
A: for configuring fine-grained access control for users and roles that need to access external network services from the database Correct answer
B: for configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication Correct answer
C: to create auditing policies regarding the usage of network services from the database
D: to block network attacks or denial of service attacks directed at the database
E: to Improve the performance of the database applications that require access to remote network services
Correct Answer:
A. for configuring fine-grained access control for users and roles that need to access external network services from the database; B. for configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication
Explanation

Network Access Control Lists (ACLs) are a security feature for controlling outbound network traffic initiated from the database via PL/SQL packages like UTLTCP and UTLHTTP. Their primary purpose is to provide fine-grained access control, specifying which database users (principals) can connect to which external network hosts and ports (A). For secure connections like HTTPS, an Oracle Wallet containing certificates is required. While the ACL does not control access to the wallet itself, it is a mandatory prerequisite for enabling the HTTP request that uses the wallet. Therefore, defining an ACL is a necessary step in the configuration process for such requests (B).

Why Incorrect

C. Auditing is a separate function. While you can audit network access, ACLs are the control mechanism, not the audit policy itself.
D. ACLs control outbound connections initiated from the database, not inbound attacks directed at the database, which is the role of a firewall.
E. ACLs are a security feature that adds a permission check; they do not inherently improve the performance of network operations.

References

- Oracle Database Security Guide 21c, Chapter 10, "Configuring Fine-Grained Access to External Network Services". It states, "You can use access control lists (ACLs) to provide fine-grained control over access by database users to external network services."

- Oracle Database PL/SQL Packages and Types Reference 21c, "UTLHTTP". The documentation specifies that before using the package, "an entry must be created in the database's network access control list (ACL)." It also notes for HTTPS, a wallet is required.

Scroll to Top