Free Oracle 1Z0-116 Exam Questions

Become Oracle Certified with updated 1Z0-116 exam questions and correct answers

Page: 1 / 18

Total 90 Questions | Updated On: Jan 08, 2025

Add To Cart

Question 1

Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.

You are connected as sysdba.

Which statement(s) achieve this?

A :

B :

C :

D :

E :

Answer: A

Question 2

You export and Import a table's data using Data Pump connected as a user who Is assigned DBA role with

default privileges.

There is a data redaction policy on the table.

Which two statements are true about the redaction policy?

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

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

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

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

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

Answer: B,C

Question 3

Database Vault is not used in your installation.

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

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

B : requires a password to be set.

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

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

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

Answer: D

Question 4

Which three are true concerning command rules?

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

Examine this parameter In sqinet.ora:

SQLNET.ADTHENTICATION_SEBVICES=(NONE)

For which two cases do you need a password file?

A : authenticate externally Identified users locally

B : authenticate nonprivllegcd database users locally

C : authenticate administrative privileged users remotely

D : authenticate externally Identified users remotely

E : to authenticate externally Identified users remotely

F : to authenticate administrative privileged users locally

Answer: A,C

Page: 1 / 18

Total 90 Questions | Updated On: Jan 08, 2025

Add To Cart