SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

What is the use of Session Control Statement(SCS) in SQL?


 

 

 

 



C


Solution:-

Session Control Statement (SCS)
Session control statements are managed properties dynamically of a user session. ALTER SESSION statement to modify conditions or parameters that are affected database connection. SET ROLE statement to enable or disable the roles that are currently enabled for the session.

PL/SQL does not support session control statements. The session control statements are:

  1. ALTER SESSION
  2. SET ROLE



Next 5 multiple choice(s)

1

What is the use of the Transaction Control Statement(TCS) in SQL?

2

What is the use of Data Control Language(DCL) in SQL?

3

What is the use of Data Definition Language(DDL) in SQL?

4

What is the use of Data manipulation Language(DML) in SQL?

5

Among the below commands, Which is not SCS command?

Comments