Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Close database link connection in user session - ALTER SESSION system privilege
Home
>>
Category
>>
Oracle (MCQ) questions and answers
>>
Oracle Distributed Database concepts
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
Related Content
Oracle DBA (
67
)
Oracle Replication (
19
)
Oracle Architecture (
20
)
Oracle Transaction (
40
)
Administering and Managing an Oracle Database (
25
)
Managing Oracle Database Processes (
8
)
Oracle Control Files (
27
)
Oracle Redo Log (
23
)
Oracle Tablespaces (
24
)
Oracle Datafiles and Tempfiles (
13
)
Oracle Managed Files (
11
)
Oracle Schema (
26
)
Oracle Tables (
13
)
Oracle Indexes and Partitioned Tables (
24
)
Oracle Clusters (
24
)
Oracle Views, Sequences, and Synonyms (
15
)
Oracle Distributed Database concepts (
28
)
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
Required!
Required!
Invalid Email Id!
Required!
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
MCQs
English
Tutorials
Download
▲