Oracle 11G OCP 1Z0-053 483

(483)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 produces an error because a fully qualified host name needs to be specified.

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

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

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

答案:(D)

请使用浏览器的分享功能分享到微信等