What is the outcome of the above code?

Evaluate the following block of code: BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl =>
‘mycompany-com-permissions.xml’, principal => ‘ACCT_MGR’, is_grant => TRUE, privilege
=> ‘connect’); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl =>
‘mycompany-com-permissions.xml’, host => ‘*.mycompany.com’); END; What is the
outcome of the above code?

Evaluate the following block of code: BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl =>
‘mycompany-com-permissions.xml’, principal => ‘ACCT_MGR’, is_grant => TRUE, privilege
=> ‘connect’); DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl =>
‘mycompany-com-permissions.xml’, host => ‘*.mycompany.com’); END; What is the
outcome of the above code?

A.
It creates an access control list (ACL) with the user ACCT_MGR who gets the
CONNECT and RESOLVE privileges.

B.
It creates an access control list (ACL) with the user ACCT_MGR who gets the
CONNECT privilege but not the RESOLVE privilege.

C.
It produces an error because the range of ports associated with the hosts has not been
specified.

D.
It produces an error because a fully qualified host name needs to be specified.



Leave a Reply 0

Your email address will not be published. Required fields are marked *