SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

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


 

 

 

 



D


Solution:-

Transaction Control Statement (TCS)
Transaction control statements are used to apply the changes permanently save into the database. Permanent work saves into the database. Restore database to original form since the last COMMIT.

  1. COMMIT    - Permanent work save into database using the commit statement
  2. ROLLBACK - Restore database to original form since the last COMMIT
  3. SAVEPOINT - Create SAVEPOINT for later uses ROLLBACK the new changes
  4. SET TRANSACTION - SET TRANSACTION command sets the transaction properties such as read-write/read-only access



Next 5 multiple choice(s)

1

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

2

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

3

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

4

Among the below commands, Which is not SCS command?

5

Among the below commands, Which is the SCS command?

Comments