Online Access Free 1z1-116 Exam Questions

Examine these steps:
1. Run the DBSAT Collector
2. Run the DBSAT Discoverer
3. Run the DBSAT Reporter
Identify the minimum required steps for producing a report of schemas with sensitive data.

• A.2
• B.1,2,3
• C.1,2
• D.2,3

When creating labels using Oracle Label Security, which is required?

• A.group
• B.compartment
• C.level
• D.level and compartment
• E.compartment and group
• F.level, compartment, and group
• G.level and group

As the SYSKM user you must create the password-based keystore, which will be used for TDE. Examine this list:

Identify the sequence that Oracle uses to search for the keystore and its location.

• A.3,5,2,4,1
• B.1,4,5,2
• C.1,2,3,5
• D.1,2,5,4

To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = "/*tc/ORACLE/WALLETS/orcl/external_Btore" SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET 'password'
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_LOGIH KEYSTORE '/etc/0RACLE/WALLETS/orcl/extemal_store';
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_L0GIN KEYSTORE ' /etc/ORACLE/WALLETS/orcl/external_store' ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

• A.1,2,3,6,4
• B.1,2,3,4
• C.2,3,6,4
• D.1,2,5,4
• E.1,2,6,3,5
• F.2,1,3,4

Examine this parameter In sqinet.ora:
SQLNET.ADTHENTICATION_SEBVICES=(NONE)
For which two cases do you need a password file?

• A.to authenticate externally Identified users remotely
• B.to authenticate nonprivileged database users remotely
• C.to authenticate externally Identified users locally
• D.to authenticate administrative privileged users remotely
• E.to authenticate administrative privileged users locally
• F.to authenticate nonprivllegcd database users locally