R4R Team working to provide free of cost for experienced and freshers

Tutorials | Examples|Interview Questions and Answers|Java Tutorials| C Tutorials | C++ Tutorials | Spring Tutorials| Hibernate Tutorials | JSP Tutorials | Servelets Tutorials| C# Tutorials | PHP Tutorials etc , Basics | Download Software | Data Types | Variables | Constant | Storage & Classes | Operators | Decisions Making | Loops | Functions| Numbers | Arrays | Pointers | String | Datastructure | Expressions | Preprocessor Statement | I/O | Exception Handling | OOPs Tutorial | Classes and object |C++ Inheritance Overloading | Polymorphism | Abstraction | Encapsulation | Interfaces | Multithreading etc

DATABASE & SQL/PLSQL

DCL and TCL
Previous Home Next

DCL (Data Control Language)

Features of DCL are:

  1. DCL stands for Data Control Language
  2. Used to create roles
  3. Used to create permissions

Commands in DLC is given below

  1. GRANT: Gives user to access database means user privilege to database.
  2. REVOKE: Withdraw access privileges given with the GRANT command

TCL (Transactional Control Language)

Features of TCL are:

  1. TCL is stands for Transactional Control Language
  2. It is used to manage different transactions occurring within a database

Commands in TCL is given below

  1. COMMIT: This Statement used to save work done by the user.
  2. SAVEPOINT: Identify the point which you can later roll back in a transaction.
  3. ROLLBACK: Restore database to original.
  4. SET TRANSACTION: Change transaction options like isolation level and what rollback segment to use
Previous Home Next