1z0-116

1z0-116 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Database Vault is configured and enabled. You want to restrict connections by users HR and FIN from the SQLPLUS client program. You are preparing the CLIENT_CHECK rule set to be used in a CONNECT command rule. Examine this list of steps: 1. Create a factor named CLIENT_PROG_NAME. 2. Set the CLIENT_PROG_NAME factor to have IDENTIFY_BY=DBMS_MACUTL.G_IDENTIFY_BY_CONSTANT. 3. Set the CLIENT_PROG_NAME factor to have EVAL_OPTIONS=DBMS_MACUTL.G_EVAL_ON_STARTUP. 4. Create a NOT_SQLPLUS rule that evaluates to true when the CLIENT_PROG_NAME factor does not evaluate to 'SQLPLUS' and the user is either HR or FIN. 5. Create a NOT_APPS rule that evaluates to true only when the user is neither HR nor FIN. 6. Create a CONNECT factor that references the CLIENT_PROG_NAME factor. 7. Create a CLIENT_CHECK rule set. 8. Add the NOT_APPS and the NOT_SQLPLUS rules to the CLIENT_CHECK rule set. 9. Set the CLIENT_CHECK rule set EVAL_OPTIONS=DBMS_MACUTL.G_RULESET_EVAL_ALL. 10. Set the CLIENT_CHECK rule set EVAL_OPTIONS=DBMS_MACUTL.G_RULESET_EVAL_ANY. Identify the minimum number of steps in the correct order to create the rule set.

  1. 1, 2, 4, 5, 7, 8, 10
  2. 1, 4, 5, 7, 8, 9
  3. 1, 4, 5, 7, 8, 10
  4. 1, 3, 4, 5, 7, 8, 9
  5. 1, 3, 4, 5, 7, 8

Question 12

You must redact the SALARY column of the HR.EMPLOYEES table to display only the number 0. Examine this syntax: 1. SQL> BEGIN 2. DBMS_REDACT.ADD_POLICY 3. (object_schema => 'HR', 4. object_name => 'EMPLOYEES', 5. policy_name => 'EMPSAL_POLICY', 6. column_name -> 'SALARY', 7. function_type => 8. expression -> '1-1'); 9. END; Which function type must be inserted at the end of line #7?

  1. DBMS_REDACT.REGEXP
  2. DBMS_REDACT.FULL
  3. DBMS_REDACT.RANDOM
  4. DBMS_REDACT.NONE
  5. DBMS_REDACT.PARTIAL

Question 13

Examine this command: Which two statements are true? (Choose two.)

  1. The output options cannot be determined from the command as shown.
  2. Credentials must be specified in PWD_FILE.
  3. A masking script will be created and applied to the data specified in PWD_FILE.
  4. By default, the output will be in a readable format not intended to be parsed by scripts.
  5. The parameters filename is retrieved from the PWD_FILE environment variable.

Question 14

You are implementing a security policy that makes use of the USERENV namespace. Which USERENV value does not change for the duration of a session?

  1. CURRENT_SCHEMA
  2. CLIENT_INFO
  3. SESSION_ USER
  4. CURRENT_USER