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: Jun 25, 2025

Add To Cart

Question 1

Database Vault is not used in your installation.

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

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

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 : The target database wallet can be uploaded to the data_pctmp_dtr directory.

B : The db_link_cred parameter stores the password in a wallet.

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

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

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

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

Answer: B,D

Question 4

What is true about the client identifier?

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

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

Page: 1 / 18

Total 90 Questions | Updated On: Jun 25, 2025

Add To Cart