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: Mar 28, 2025

Add To Cart

Question 1

A database link must be created to connect a source Autonomous Database to target on premises database.

Examine this command:

Which two options are true?

A : target database wallet can be uploaded to the data_pctmp_dtr directory.

B : db_link_cred parameter stores the password in a wallet.

C : db__link__cred references the credential for the username and password for the target database.

D : credential_nam£ parameter automatically creates the credential object store.

E : database link port Is not correct because It must be restricted to 1521.

F : ly data_pump_dir directory can be used to store credential wallets.

Answer: B,D

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 Risk

Matrix.

Which one is not a supported method to address this CVE?

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

B : plement a workaround recommended by Oracle Support.

C : grade to a new Release.

D : tall a new Release Update.

E : Install a new Release Update Revision.

Answer: A

Question 3

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 4

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 5

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

Page: 1 / 18

Total 90 Questions | Updated On: Mar 28, 2025

Add To Cart