Close database link connection in user session - ALTER SESSION system privilege

Q.  To close a database link connection in your user session, you must have the ALTER SESSION system privilege.
- Published on 27 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - Use the ALTER SESSION statement to set or modify any of the conditions or parameters that affect your connection to the database.

    - The statement stays in effect until you disconnect from the database.

    - To enable and disable the SQL trace facility, you must have ALTER SESSION system privilege.

    - To enable or disable resumable space allocation, you must have the RESUMABLE system privilege.

    - You do not need any privileges to perform the other operations of this statement unless otherwise indicated.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)