Exhibit below:
Which three statements are true about terminating a session?
A.
Without any error, you can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSIOU ‘7, 15’;
B.
You can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSIOM “7, 15′;
But you also get the error message:
ORA-00028: your session has been killed
C.
You cannot terminate the active session. You have to wait until that session becomes inactive.
D.
Without any error, you can terminate the inactive session by executing:
SQL> ALTER SYSTEM KILL SESSION ’12, 63′;
E.
When an inactive session is killed, the status of that session remains visible in VSSESSION
with status KILLED. The rowf the terminated session is removed from VSSESSION after the user
attempts to use the session again.
F.
You cannot terminate the inactive session. You have to wait until that session becomes active
again.
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192
Correct B,D,E
I would say A,D,E
Why A not B:
If I’m SYS or SYSTEM and I’m going to kill SCOTT’s session with ALTER SYSTEM KILL SESSION … I will receive no error. Instead SCOTT reveives the ORA-00028.
When you try to kill your own session, you will get an ORA-00027: cannot kill current session
http://ora-00027.ora-code.com/
Correct B,D,E.
Why B (Not A) :
If a user session is processing a transaction (ACTIVE status) 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
D :
If the session is not making a SQL call to Oracle Database (is 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.
E:
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.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm