What is DCL and TCL give examples of each?

What are DCL and TCL give example?

DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. TCL is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

What is DCL and TCL?

DCL – Data Control Language. TCL - Transaction Control Language.

What is DCL in DBMS example?

Data control language (DCL) is used to access the stored data. It is mainly used for revoke and to grant the user the required access to a database. In the database, this language does not have the feature of rollback. It is a part of the structured query language (SQL).

What is DDL DML and DCL commands with examples?

DDL – Data Definition Language. DQl – Data Query Language. DML – Data Manipulation Language. DCL – Data Control Language.