Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-116

Free Oracle 1z0-116 Exam Braindumps (page: 2)

Page 2 of 23
PDF with 90 Questions

What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

  1. data redaction policies
  2. data masking transformations
  3. parent/child relationships between the columns holding sensitive information
  4. encrypted columns

Answer(s): C

Explanation:

Create an Application Data Model -- To begin using Oracle Data Masking and Subsetting, you must create an Application Data Model (ADM). ADMs capture application metadata, referential relationships, and discover sensitive data from the source database. https://docs.oracle.com/database/121/DMKSB/intro.htm#:~:text=Create%20an%20Application%20 Data%20Model,data%20from%20the%20source%20database.



Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.
Examine these requirements:
1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.
2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.
3. Audit records are to be collected for every evaluation of the rule set.

Which two options are true when creating the rule set?

  1. One rule set contains two rules OR'ed together.
  2. The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
  3. The rule set must be defined as is_static.
  4. The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.
  5. The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

Answer(s): C,D



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.

  1. 2,1,3,4
  2. 1,2,5,4
  3. 1,2,3,6,4
  4. 1,2,6,3,5
  5. 2,3,6,4
  6. 1,2,3,4

Answer(s): D



Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.

Which three options together satisfy these requirements?

  1. Grant become user to dbai.
  2. Grant sysoper to both users.
  3. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
  4. Grant imp_full_database and exp_full_database to dbai and dba2.
  5. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
  6. Grant become user to dba2.
  7. Grant sysdba to both users.

Answer(s): A,C,E






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

1z0-116 Exam Discussions & Posts