Session Control Statement Use - Manage User Session Properties Dynamically

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

A) To define the database structure or table

B) For managing data within table object

C) Manage properties dynamically of a user session

D) To apply the changes permanently save into database

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:

ALTER SESSION
SET ROLE

Next Others

Next 5 multiple choice(s)

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

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

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

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

Among the below commands, Which is not SCS command?

SQL Multiple choices

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

Next 5 multiple choice(s)

Comments