Oracle
1Z0-050 · Question #6
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')…
The correct answer is C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and. See the full explanation below for the reasoning.
Question
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?
Options
- AIt produces an error because a fully qualified host name needs to be specified.
- BIt produces an error because the range of ports associated with the hosts has not been specified.
- CIt creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and
- DIt creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege
How the community answered
(36 responses)- A3% (1)
- B8% (3)
- C78% (28)
- D11% (4)
Community Discussion
No community discussion yet for this question.