Question 1

Which three are true concerning command rules?

Options :

A : System privileges override command rules.

B :

If a command rule-s associated rule set evaluation results In an error, the command is not allowed to execute.

C : A command can have only one command rule that applies to it.

D : For DML statement command rules, you can specify a wildcard for the object owner.

E : If a command rule-s associated rule set Is disabled, then the rule set evaluates to true.

F : For DML statement command rules, you can specify a wildcard for the object name.

G : Object privileges override command rules.

Answer: B,D,F

Question 2

Examine this parameter In sqinet.ora:

SQLNET.ADTHENTICATION_SEBVICES=(NONE)

For which two cases do you need a password file?

Options :

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 externally Identified users remotely

F :

to authenticate administrative privileged users locally

Answer: A,C

Question 3

Database Vault is not used in your installation.

Why is a conventional secure application role more secure than a normal role?

Options :

A : It Is In effect only when configured as a default role for the user.

B : It requires a password to be set.

C : It can be set only by a package or procedure that is created with deflner-s rights.

D : It can be set only by users with the grant any bole privilege.

E : It can be set only by a package or procedure associated with the role definition.

Answer: D

Question 4

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.

Answer: B

Question 5

Which three authentication methods are available with Centrally Managed Users (CMU)?

Options :

A : remote Access Services authentication

B : smart key authentication

C : public key Infrastructure (PKT) authentication

D : kerberos authentication

E : username/password authentication

F : SSH authentication

Answer: C,D,F

Higher Test Marks with Free Online 1Z0-116 Exam Practice

Buying Options: