1Z0-116Preview

Which module of the Oracle Data Masking and Subsetting pack simplifies sensitive data discovery by providing automated discovery procedures and sensitive column types?

You perform sensitive data discovery using the Data Masking and Subsetting feature of Enterprise Manager.
Which two statements are true? (Choose two.)

Which three are valid settings to implement Listener Valid Node Checking for Registration (VNCR)? (Choose three.)

Examine this statement executed in a SQL*Plus session:
ALTER SESSION SET EVENTS 'clientid_overwrite';
Which statement is true?

You have implemented Oracle Database Vault. Now DBAs report that they can no longer create users.
What expected behavior implemented by Database Vault has caused this?

You connect to the database instance over a network to change the password of user SCOTT.
Which two methods avoid the new password for user SCOTT from being compromised by network sniffing? (Choose two.)

Which command avoids displaying the password on the command line or spooling it to a spool file?

You are moving to a Bare Metal Instance on the Oracle Cloud.
Which two define how instance isolation is managed? (Choose two.)

You want to create a test database which must contain a subset of production data and also must not contain real values.
You have to decide to use either Datapump export/import or Recovery Manager (RMAN) to make a copy of the database.
Which statement is true about creating a copy of the database given this requirement?

Examine these commands:

Which statement is true about newly recorded values in DBA_WALLET_ACLS?

Identify two situations either one of which makes use of password files. (Choose two.)

You set up Enterprise User Security (EUS) with a third-party LDAP-compliant directory.
Which two products can you use to integrate the EUS-enabled database with the LDAP directory? (Choose two.)

You must disable OS authentication for database administrative users on a RAC database.
Which option must you use to do this?

You grant user BOB the SYSBACKUP administrative privilege.
BOB has connected as SYSBACKUP.
Which statement is true?

Examine these commands that execute successfully:

Examine the execution plan generated for this query:

What must be done to allow the index to be used?

Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?

Examine the Real Application Security code and output:

Which two statements are true? (Choose two.)

To enhance password security you must enforce the use of mixed-case passwords for open database accounts immediately.
Which two steps must be executed? (Choose two.)

You check the Risk Matrix of the latest Critical Patch Update (CPU).
One of the "Common Vulnerability and Exposure" reports (CVEs) has Base Score that is above 9 in the Risk Matrix.
Which one is not a supported method to address this CVE?

As the security administrator, you are tasked to protect the hr_admin role with these requirements:

1. HR admin users must be working on-site defined by the workstation IP in the range 192.0.2.10 192.0.2.20.
2. HR admin users cannot be working outside of normal work hours (8 AM 5 PM.
   You decide to create a secure application role.
   Examine this code:

Which three statements are true about Data Reduction? (Choose three.)

You issue this statement as user SYS:
audit context namespace kilimanjaro attributes a, b;
Which is true?

You must implement Fine Grained Access Control using procedure DBMS_RLS.ADD_POLICY whose predicate function returns an unspecified number of conditions.
The predicate may be affected by any system or session environment variable at any time.
Which value must be used for parameter POLICY_TYPE?

The database has Database Vault configured and enabled.
Database users have executed these commands with the appropriate roles.

Examine this command and output:

Why does this error occur?