DATA BASE Language :- The data base management system provide a set of data base language and interfaces to perform appropriate operation on the data stored in the data base this language is can grouped as per following----------
1- Data Definition Language [DDL]
2- Data Manipulation Language [DML]
3- Data Control Language [DCL]
4- Data Query Language [DQL]
DDL -:- It defind the structure of the relation in the database, we can create new relation's modify existing relation's using DDL commonds Create table, Alter table , Crop table ,or the common commond of DDL.
DML -:- The data manipulation language commonds such as Insert, Delete, Update, Operate, on actual data , we can manipulate the actual data using DML commond.
DCL -:- Stands for the data control language using DCL constant or condition can be imposed on the data actual data.
DQL -:- The DQL commonds are used to querying the data store in the data base on the bases of some selection criteria. The select commond with all variation and predicate is a powerful query statement used by the DBMS.
1- Data Definition Language [DDL]
2- Data Manipulation Language [DML]
3- Data Control Language [DCL]
4- Data Query Language [DQL]
DDL -:- It defind the structure of the relation in the database, we can create new relation's modify existing relation's using DDL commonds Create table, Alter table , Crop table ,or the common commond of DDL.
DML -:- The data manipulation language commonds such as Insert, Delete, Update, Operate, on actual data , we can manipulate the actual data using DML commond.
DCL -:- Stands for the data control language using DCL constant or condition can be imposed on the data actual data.
DQL -:- The DQL commonds are used to querying the data store in the data base on the bases of some selection criteria. The select commond with all variation and predicate is a powerful query statement used by the DBMS.
No comments:
Post a Comment