1Z0-116 practice question 3 of 15

What is true about the client identifier?

Full set: 90 questions

Answer options

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

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.

Correct Answer:

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

Explanation

The client identifier, when set using DBMSSESSION.SETIDENTIFIER, is automatically captured in audit trail records. This allows DBAs to track database activities by actual application users rather than just database usernames. The client identifier is not automatically set by SQLNet - it must be explicitly set by the application. A session can have only one client identifier value at a time, and it can be changed multiple times during a session using DBMSSESSION procedures.

Why Incorrect

B. SQLNet does not automatically set client identifier; applications must explicitly set it using DBMSSESSION.SETIDENTIFIER.
C. Only one client identifier value can be active per session at any given time.
D. Client identifier can be changed during a session using DBMSSESSION.SETIDENTIFIER or CLEARIDENTIFIER procedures.

References

1. Oracle Database Security Guide 19c, Chapter 23 "Managing Security for Application Developers", Section "Using Application Context", Doc ID E96279-05

2. Oracle Database PL/SQL Packages and Types Reference 19c, "DBMSSESSION" package documentation, procedures SETIDENTIFIER and CLEARIDENTIFIER

3. Oracle Database Administrator's Guide 19c, Chapter 28 "Monitoring Database Activity with Auditing", Section "Audit Trail Contents"

Keep practicing

Take the free 1Z0-116 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test