Oracle Database Security Administration - 1z1-116 FREE EXAM DUMPS QUESTIONS & ANSWERS

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

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

A. The master key has been corrupted. B. This is expected behavior for this view. C. You do not have select privileges on this database view. D. The master key has not been created. E. The key store is not open.

A. Create a SQL baseline to preserve the execution plan from before the encryption. B. Use tublespace encryption instead of column encryption. C. Enable encryption hardware acceleration on the CPUs of the machine. D. Add the first_name column to the ix_employee Index to Improve its selectivity.

A. The query will be executed, an entry will be created in the unified audit trail, and the mail will be sent. B. The query will be executed, but no audit entry will be created nor any mail sent. C. The query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent. D. The query will be executed, no audit entry will be created but the mall will be sent.

A. enabling salt tor an encrypted column B. collecting sensitive data Information with Database Security Assessment Tool (DBSAT) C. enforcing row-level security at the table level D. setting the SQL92_SECURITy initialization parameter to false E. creating a procedure that defines the VPD restrictions in a VPD policy F. enforcing row-level security at the database level

A. The upper_port may be null but the lower_port must specify a value. B. Both lower_port and upper_port must not be NULL C. The port range may not include values larger than or equal to 1024. D. The port range must not overlap with any other port ranges for host01. E. The lower_port may be null but the upper_port must specify a value. F. upper_port must be greater than or equal to lower_port.

A. Add or remove owners to or from the realm. B. Grant or revoke privileges on realm-protected objects to or from other users. C. Grant or revoke system privileges to access objects protected by the realm. D. Add or remove participants to or from the realm. E. Add or remove realm-protected objects to or from the reaim. F. Add or remove realm-secured database roles to or from the realm. G. Grant or revoke realm-secured database roles.

A. It cannot be used to capture the privileges that have been exercised on precompiled database objects. B. Privilege analysis data for dropped objects are kept. C. It can be used after you install the Oracle Database without any additional database configuration steps. D. If a privilege is captured during run time, it is saved under the run-time capture name. E. It shows the grant paths to the privileges and suggests which grant path to keep. F. It must have the Database Vault option enabled.

A. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY; B. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY; C. CREATE CONTEXT global_hr USING hr_pkg; D. CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;