What is the outcome of the above code?

GuanYing Wu

I also think D is the correct answer.
I did a test case on Oracle 11g.
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => ‘test.xml’,
description => ‘for test’, — Must include this parameter
principal => ‘HR’,
is_grant => TRUE,
privilege => ‘connect’
);
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ‘test.xml’,
host => ‘*.oracletest.com’);
END;

select ACL,PRINCIPAL,PRIVILEGE from DBA_NETWORK_ACL_PRIVILEGES;
ACL PRINCIPAL PRIVILEGE
—————————— —————————— ————–
/sys/acls/test.xml HR connect

If want to add the resolve privilege, need run following script
BEGIN
dbms_network_acl_admin.add_privilege (
acl => ‘test.xml’,
principal => ‘HR’,
is_grant => TRUE,
privilege => ‘resolve’);
END;

select ACL,PRINCIPAL,PRIVILEGE from DBA_NETWORK_ACL_PRIVILEGES;

ACL PRINCIPAL PRIVILEGE
—————————— —————————— ————–
/sys/acls/test.xml HR connect
/sys/acls/test.xml HR resolve