Oracle 1Z0-116 Oracle Database Security Administration Exam Exam Practice Test Questions

• Question 1

  Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

  • It runs only on UNIX/Linux systems.
  • It must connect to the database using a SYSDBA connection.
  • It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.
  • It runs only on Windows systems.
  • It must be run on the server that contains the database.

  Show Answer Answer: C, D Next

• Question 2

  Examine this configuration and requirement:1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schemaIn the PDBl pluggable database.2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?

  • Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.
  • Grant other users access to the database link in the PDBI pluggable database.
  • Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.
  • Grant other users access to the database link In the PDB2 pluggable database.
  • Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

  Show Answer Answer: D, E Next

• Question 3

  Which three are true concerning command rules?

  • System privileges override command rules.
  • If a command rule's associated rule set evaluation results In an error, the command is not allowed to execute.
  • A command can have only one command rule that applies to it.
  • For DML statement command rules, you can specify a wildcard for the object owner.
  • If a command rule's associated rule set Is disabled, then the rule set evaluates to true.
  • For DML statement command rules, you can specify a wildcard for the object name.
  • Object privileges override command rules.

  Show Answer Answer: A, D, F Next

• Question 4

  Which two statements are true about Valid Node Checking for Registration (VNCR)?

  • It denies Instance registration through IPC.
  • It can only be used with Oracle RAC.
  • It enforces the Listener connectivity through TCPS.
  • It is a replacement for Class of Secure Transport (COST).
  • It restricts specific instances from registering with the Listener.

  Show Answer Answer: A, D Next

• Question 5

  You must mask data consistently In three database copies such that data relations across the databases remain In place.Which Data Masking Format allows this?

  • Shuffle
  • Auto Mask
  • Array List
  • Substitute
  • Random Strings

  Show Answer Answer: A Next