What type of language each system provide in dbms?
Answers
Answered by
0
Database languages are used for read, update and store data in a database. There are several such languages that can be used for this purpose; one of them is SQL (Structured Query Language).
Types of DBMS languages:
Data Definition Language (DDL): DDL is used for specifying the database schema. Let’s take SQL for instance to categorize the statements that comes under DDL.
To create the database instance – CREATETo alter the structure of database – ALTERTo drop database instances – DROPTo delete tables in a database instance – TRUNCATETo rename database instances – RENAME
All these commands specify or update the database schema that’s why they come under Data Definition language.
Data Manipulation Language (DML): DML is used for accessing and manipulating data in a database.
To read records from table(s) – SELECTTo insert record(s) into the table(s) – INSERTUpdate the data in table(s) – UPDATEDelete all the records from the table – DELETE
Types of DBMS languages:
Data Definition Language (DDL): DDL is used for specifying the database schema. Let’s take SQL for instance to categorize the statements that comes under DDL.
To create the database instance – CREATETo alter the structure of database – ALTERTo drop database instances – DROPTo delete tables in a database instance – TRUNCATETo rename database instances – RENAME
All these commands specify or update the database schema that’s why they come under Data Definition language.
Data Manipulation Language (DML): DML is used for accessing and manipulating data in a database.
To read records from table(s) – SELECTTo insert record(s) into the table(s) – INSERTUpdate the data in table(s) – UPDATEDelete all the records from the table – DELETE
Similar questions