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.

相关问题推荐

• Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）

  A

   SET_ATTRIBUTE_NULL

  B

   ALTER_JOB

  C

   ALTER_JOB_PARAMETERS

  D

   ALTER

  E

   SET_ATTRIBUTE

  查看答案

• Your database is running in ARCHIVELOG mode. One of the data files， USERDATA01.dbf， in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

  A

   Redo logs 

  B

   Control file

  C

   The latest backup of only the damaged data file

  D

   The latest backup of all the data file in the USERS tablespace

  E

   Temporary files of temporary tablespace

  F

   Archive Logs since the latest backup to point of failure

  查看答案

• Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

  A

   Database datafiles

  B

   Control files

  C

   Archived redo logs

  D

   Online redo logs

  E

   Flashback logs

  查看答案

• In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?（） (Choose two.)

  A

  2, 6, 4, 5, 3

  B

  1, 2, 4, 5, 3, 6

  C

  1, 2, 4, 6, 3

  D

  1, 2, 7, 5, 3, 6

  查看答案

• The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?（）

  A、The Oracle database will perform block checking for the index blocks only

  B、The Oracle database will not perform block checking for any of the data blocks

  C、The Oracle database will perform block checking for the default permanent tablespace only

  D、The Oracle database will perform block checking for the data blocks in all user tablespaces

  E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

  查看答案