← Back to exam page

1z0-116 – Oracle Database Advanced Security Administration

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.

Examine these requirements:

1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.

2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.

3. Audit records are to be collected for every evaluation of the rule set.

Which two options are true when creating the rule set?

Select all that apply, then click Submit answer.

  • ○

    One rule set contains two rules OR'ed together.
  • ○

    The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
  • ○

    The rule set must be defined as is_static.
  • ○

    The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.
  • ○

    The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.
Question 5

Which two statements are true about column-level transparent data encryption?

Select all that apply, then click Submit answer.

  • ○

    It can bo used for tables in encrypted tablcspaces.
  • ○

    encrypted columns cannot have an Index.
  • ○

    All encrypted columns of a table use the same encryption key.
  • ○

    Column level encrypted data remains encrypted in the buffer cache.
  • ○

    Column-level encryption keys are not encrypted by the master key.
Question 6

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

Select an option, then click Submit answer.

  • ○

    orapki
  • ○

    netca
  • ○

    dbca
  • ○

    netmgr
  • ○

    mkstore
  • ○

    owm