Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Oracle Database Security Administration

Last Update 23 hours ago Total Questions : 90

The Oracle Database Security Administration content is now fully updated, with all current exam questions added 23 hours ago. Deciding to include 1z0-116 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our 1z0-116 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these 1z0-116 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Oracle Database Security Administration practice test comfortably within the allotted time.

Question # 21

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?

A.

One rule set contains two rules OR ' ed together.

B.

The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

C.

The rule set must be defined as is_static.

D.

The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

E.

The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

Question # 22

Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R.

You must also prevent access to realm r protected tables by user FIN. Which achieves this?

A.

Revoke the select any table privilege from user FIN.

B.

Make realm R a mandatory realm.

C.

Remove the owner authorization of user fin in realm R.

D.

Make user FIN participant In realm r. Instead of owner.

Question # 23

Examine this command:

Which two statements are true?

A.

Opening the software keystore from remote computers is possible.

B.

Opening the software keystore from the local computer Is possible.

C.

Opening the software keystore from remote computers is not possible.

D.

Opening the software keystore must always be done manually on the local computer.

E.

Opening the software keystore from the local computer is not possible.

Question # 24

Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?

A.

timing attack

B.

Inference attack

C.

data remanence attack

D.

cache attack

E.

side-channel attack

F.

known-plaintext attack

Question # 25

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.

Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

A.

PARAMETER_NAMĀ£= > ' CHECKPOINT '

B.

OBJECT_OWNER= > ' SYS

C.

CLAUSE_NAME= > ' CHECKPOINT '

D.

CLAUSE_NAME= > ' SYSTEM '

E.

COMMANI > = > ' ALTER SYSTEM '

F.

OBJECT_NAME= > ' CHECKPOINT '

G.

COMMAND= > ' ALTER '

Question # 26

Which type of masking directly masks and subsets data In a nonproduction database with minimal or no Impact on production environments?

A.

conditional format

B.

heterogeneous

C.

in-database

D.

deterministic

E.

In-export

Question # 27

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 locally

B.

to authenticate nonprivllegcd database users locally

C.

to authenticate administrative privileged users remotely

D.

to authenticate externally Identified users remotely

E.

to authenticate nonprivileged database users remotely

F.

to authenticate administrative privileged users locally

Go to page: