Question 1

You export and Import a table's data using Data Pump connected as a user who Is assigned DBA role withdefault privileges.There is a data redaction policy on the table.Which two statements are true about the redaction policy?

Options :

A : The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.

B : The policy Is not Included In export and Import operation.

C : The actual data in the tables is copied to the Data Pump target system without being redacted.

D : The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.

E : The policy is included in the export and import operation and applied by default to the objects in the target system.

Answer: B,C

Question 2

You check the Risk Matrix of the latest Critical Patch Update (CPU).One of the " Common Vulnerability and Exposure’’ reports (CVEs) has Base Score that is above 9 in the RiskMatrix.Which one is not a supported method to address this CVE?

Options :

A : Request a one off patch exception from Oracle Support.

B : Implement a workaround recommended by Oracle Support.

C : Upgrade to a new Release.

D : Install a new Release Update.

E : Install a new Release Update Revision.

Answer: A

Question 3

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 4

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 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

Smartly Prepare Exam with Free Online 1Z0-116 Practice Test

Buying Options: