1Z0-116 Question #1: Real Exam Question with Answer & Explanation

The correct answer is A. The lower_port may be null but the upper_port must specify a value. C. upper_port must be greater than or equal to lower_port. D. The port range may not include values larger than or equal to 1024.. When configuring port ranges via DBMS_NETWORK_ACL_ADMIN in Oracle, A is correct because lower_port can be NULL to indicate "no lower bound," but upper_port must always carry a value to define where the range ends - an unbounded upper limit is not permitted. C is correct because a

Implementing Basic Database Security

Question

The utl_http package is used to invoke REST API's to manage Oracle GoldenGate Microservlces Architecture components on host1. You must use dbms__network_acl_admin to specify a range of ports to be used when connecting to host01. What three requirements must you consider?

Options

AThe lower_port may be null but the upper_port must specify a value.
BThe port range must not overlap with any other port ranges for host01.
Cupper_port must be greater than or equal to lower_port.
DThe port range may not include values larger than or equal to 1024.
EBoth lower_port and upper_port must not be NULL
FThe upper_port may be null but the lower_port must specify a value.

Explanation

When configuring port ranges via DBMS_NETWORK_ACL_ADMIN in Oracle, A is correct because lower_port can be NULL to indicate "no lower bound," but upper_port must always carry a value to define where the range ends - an unbounded upper limit is not permitted. C is correct because a range where upper_port < lower_port is logically invalid; the upper boundary must be at or above the lower. D is correct because Oracle's ACL port range implementation restricts valid values to the well-known/privileged port range (0–1023); specifying ports ≥ 1024 is not permitted in this context.

B is wrong because Oracle ACL port ranges can overlap for the same host - overlap is not forbidden, so it is not a requirement to avoid it. E is wrong because it directly contradicts the correct answer A: lower_port is explicitly allowed to be NULL. F is the mirror-image trap of A - it reverses which parameter can be NULL; upper_port cannot be NULL, lower_port can.

Memory tip: Think "LUN" - Lower is Unbounded (Null-able), Upper is Needed. That locks in A and immediately rules out E and F. Then remember the two sanity checks: upper ≥ lower (C), and stay below 1024 (D).

Topics

#Network ACLs#dbms_network_acl_admin#Port range constraints#utl_http

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice