SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

Among the below commands, Which is not SCS command?


 

 

 

 



C


Solution:-

Session Control Statement (SCS)
Session control statements are managed properties dynamically of a user session.

Statement

Description

ALTER SESSION

ALTER SESSION statement to modify conditions or parameters that are affected by your database connection.

SET ROLE

SET ROLE statement to enable or disable the roles that are currently enabled for the session.

Use the SET ROLE statement to enable and disable roles for your current session.  At one time you cannot enable more than 148 user-defined roles.

When a user logs on, SQL Database enables all privileges granted explicitly to the user and all privileges in the user's default roles. During the session, the user or an application can use the SET ROLE statement any number of times to change the roles currently enabled for the session.

Examples:

SET ROLE sb_admin IDENTIFIED BY SlightBook;

To enable all roles granted to you for the current session, issue the following statement:
SET ROLE ALL; 

To enable all roles granted to you except dw_manager, issue the following statement:
SET ROLE ALL EXCEPT sb_admin;

To disable all roles granted to you for the current session, issue the following statement:
SET ROLE NONE; 




Next 5 multiple choice(s)

1

Among the below commands, Which is the SCS command?

2

What is the meaning of SCS in SQL?

3

Among the below commands, Which is not TCS command?

4

Among the below commands, Which is TCS command?

5

What is the meaning of TCS in SQL?

Comments