Exhibit below: Which three statements are true about terminating a session?

Question

Options

• AWithout any error, you can terminate the active session by executing:
• BYou can terminate the active session by executing:
• CYou cannot terminate the active session.
• DWithout any error, you can terminate the inactive session by executing:
• EWhen an inactive session is killed, the status of that session remains visible in VSSESSION with
• FYou cannot terminate the inactive session.

• A
  8% (2)
• B
  77% (20)
• C
  4% (1)
• F
  12% (3)

Explanation

Terminating an Active Session You can terminate the current session using the sql statement - ALTER SYSTEM KILL SESSION; If a user session is processing a transaction (ACTIVE) when you terminate the session, the transaction is rolled back and the user immediately receives the following message: ORA-00028: your session has been killed Terminating an Inactive Session If the session is not making a SQL call to Oracle Database (INACTIVE) when it is terminated, the ORA-00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session. When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from V$SESSION after the user attempts to use the session again and receives the ORA-00028 message.

No community discussion yet for this question.