Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Oracle Database Security 1z0-116 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam 1z0-116 Premium Access

View all detail and faqs for the 1z0-116 exam

Go to Exam

513 Students Passed

93% Average Score

97% Same Questions
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which two statements are true about column-level transparent data encryption?

Options:

A.

It can bo used for tables in encrypted tablcspaces.

B.

encrypted columns cannot have an Index.

C.

All encrypted columns of a table use the same encryption key.

D.

Column level encrypted data remains encrypted in the buffer cache.

E.

Column-level encryption keys are not encrypted by the master key.

Questions # 2:

You are connected to an Oracle database Instance as a user with privileges to query the hr.employees table.

You are not exempt from any reduction policies.

Examine this query and result:

Question # 2

You implement this Data Redaction policy:

Question # 2

You re-execute the select statement.

What is the result?

A)

Question # 2

B)

Question # 2

C)

Question # 2

D)

Question # 2

E)

Question # 2

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

Questions # 3:

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?

Options:

A.

Shuffle

B.

Auto Mask

C.

Array List

D.

Substitute

E.

Random Strings

Questions # 4:

You must disable OS authentication for database administrative users on a RAC database.

Which option must you use to do this?

Options:

A.

Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.

B.

Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.

C.

Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.

D.

Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.

Questions # 5:

Database Vault Is configured and enabled In the Oracle database.

Three users are granted the dba, dv_omneb, and dv_acctmgb roles.

There is a requirement to create a user who can:

1. Connect to the database Instance

2. Select from dictionary views

Which users can complete the operation to meet the requirement?

Options:

A.

users granted DV_ACCTMGR and DV_OWNER roles

B.

users granted DV_OWNER role

C.

users granted DBA and DV_OWNER roles

D.

users granted DV_ACCTMGR and DBA roles

Questions # 6:

An audit administrator wants to log Client Context variables In the audit trail.

Examine this query and the output:

Question # 6

Options:

A.

AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

B.

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES

current:_user( db_name BY hr;

C.

CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

D.

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

E.

AUDIT POLICY hr_emp_pol BY hr;

F.

CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

G.

AUDIT POLICY hr_emp_pol EXCEPT hr;

Questions # 7:

Examine this list of capabilities:

1. You can automatically restrict common users from accessing pluggable database (PDB).

2. Enabling Database Vault Operations Control In cdbsroot does not automatically enable It In PDBs.

3. Any common user granted the dv_admin role can enable Database Vault Operations Control.

4. To enable Database Vault Operations Control, use the dbms_macadm.enable_app_protection.

5. Common users' and Invokers' right procedures that must access PDB local data can be added to an exception list.

6. To disable Database Vault Operations Control, use the dbms_macadm.disable_app_protection.

Which statements describe Database Vault Operations Control?

Options:

A.

3, 5, 6

B.

2, 3. 6

C.

2, 4, 6

D.

1, 4, 6

E.

1, 2, 3, 5

Questions # 8:

What is true about the client identifier?

Options:

A.

The client Identifier is automatically included In the audit trail.

B.

The client Identifier is automatically set by the SQL-Net layer.

C.

A session can have multiple client Identifier values set simultaneously.

D.

The client Identifier cannot be changed during the session.

Questions # 9:

The sqinet.oia file on the client contains this parameter setting:

SQLNET.ENCRYPTION_CLIEKT = REQUESTED

What value for the parameter sQLNET.ENCRYPTION _server In the sqlnet.ora file on the server will disable Encryption and Data Negotiation?

Options:

A.

REQUESTED

B.

ACCEPTED

C.

REQUIRED

D.

REJECTED

Questions # 10:

Which three are part of an access control list (ACL) when using Real Application Security?

Options:

A.

privileges

B.

schemas

C.

data realms

D.

column constraints

E.

policies

F.

data realm constraints

G.

roles

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25
ADM-201
Agentforce-Specialist
CMMC-CCP
Data-Cloud-Consultant
PCNSE
PDI
PSE-Strata-Pro-24
Secure-Software-Design
Sharing-and-Visibility-Architect
Workday-Pro-Integrations
ZDTA