nerdexam
Oracle

1Z0-116 · Question #78

The sqinet.oia file on the client contains this parameter setting: SQLNET.ENCRYPTION_CLIEKT = REQUESTED What value for the parameter sQLNET.ENCRYPTION _server in the sqlnet.ora file on the server…

The correct answer is D. REJECTED. D (REJECTED) is correct because Oracle Net negotiates encryption by pairing both sides' settings. When the client is set to REQUESTED (meaning "I prefer encryption but won't insist"), a server value of REJECTED causes the server to refuse encryption outright - and since the…

Implementing Encryption

Question

The sqinet.oia file on the client contains this parameter setting:

SQLNET.ENCRYPTION_CLIEKT = REQUESTED What value for the parameter sQLNET.ENCRYPTION _server in the sqlnet.ora file on the server will disable Encryption and Data Negotiation?

Options

  • AREQUESTED
  • BACCEPTED
  • CREQUIRED
  • DREJECTED

How the community answered

(31 responses)
  • A
    10% (3)
  • B
    3% (1)
  • C
    3% (1)
  • D
    84% (26)

Explanation

D (REJECTED) is correct because Oracle Net negotiates encryption by pairing both sides' settings. When the client is set to REQUESTED (meaning "I prefer encryption but won't insist"), a server value of REJECTED causes the server to refuse encryption outright - and since the client isn't requiring it, the connection proceeds unencrypted rather than failing.

Why the distractors fail:

  • A (REQUESTED): When both sides request encryption, Oracle honors both preferences and encryption is enabled.
  • B (ACCEPTED): ACCEPTED means the server will use encryption if the other side asks - and since the client is REQUESTED, encryption gets enabled.
  • C (REQUIRED): The server mandates encryption regardless of what the client wants, so encryption is enforced.

Memory tip: Think of the negotiation as a handshake where the client is "politely asking." REQUESTED = "Please encrypt?" - REJECTED = "No." Since the client was only asking and not demanding, the connection still happens, just without encryption. Any server value that agrees (ACCEPTED, REQUESTED) or demands (REQUIRED) will result in encryption being used.

Topics

#SQL*Net encryption#Encryption negotiation#ENCRYPTION_SERVER parameter#encryption modes

Community Discussion

No community discussion yet for this question.

Full 1Z0-116 Practice