Free Oracle 1z0-116 Exam Questions (page: 3)

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.
Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

  1. PARAMETER_NAM£=>'CHECKPOINT'
  2. OBJECT_OWNER=>'SYS
  3. CLAUSE_NAME=>'CHECKPOINT'
  4. CLAUSE_NAME=>'SYSTEM'
  5. COMMANI>=>' ALTER SYSTEM'
  6. OBJECT_NAME=>'CHECKPOINT'
  7. COMMAND=>'ALTER'

Answer(s): C,D



If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?

  1. none of the columns
  2. foreign key columns only
  3. the primary and foreign key columns
  4. columns with any type of constraint
  5. the primary key column only

Answer(s): C



Which three are part of an access control list (ACL) when using Real Application Security?

  1. privileges
  2. schemas
  3. data realms
  4. column constraints
  5. policies
  6. data realm constraints
  7. roles

Answer(s): A,D,F



Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.
You are connected as sysdba.
Which statement(s) achieve this?

A)


B)



C)



D)



E)

  1. Option A
  2. Option B
  3. Option C
  4. Option D
  5. Option E

Answer(s): A






Post your Comments and Discuss Oracle 1z0-116 exam prep with other Community members:

1z0-116 Exam Discussions & Posts