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: Feb 18, 2025

Add To Cart

Question 1

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

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

What is true about the client identifier?

A : client Identifier is automatically included In the audit trail.

B : client Identifier is automatically set by the SQL-Net layer.

C : ession can have multiple client Identifier values set simultaneously.

D : client Identifier cannot be changed during the session.

Answer: B

Question 4

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

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

Question 5

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

Page: 1 / 18

Total 90 Questions | Updated On: Feb 18, 2025

Add To Cart