0 votes
75 views
in Database Management Systems by (user.guest)

1 Answer

0 votes
by (user.guest)
 
Best answer

Every database management system has specific languages and interfaces that help to execute database queries and modifications. Usually, Structured Query Language (SQL) is used by various DBMSs to read, store and modify data within a database. 

Types of DBMS languages:

DDL (Data Definition Language): As the name suggests it is used to define a database or its structure. It is used to create tables, schema, or defining integrity constraints on the data. Various commands under DDL are: create, alter, merge and drop.

DML (Data Manipulation Language): DML is used to modify the data within a database as per the user's requests. Insert, update and delete commands used to perform modifications on the data.

DRL (Data Retrieval Language): It is used to retrieve or access data from the database using select command.

TCL (Transaction Control Language): This is generally used for transactions related data. TCL is used to execute the modifications done by DML statements such as commit and rollback of data.

Related questions

+2 votes
1 answer 420 views
+2 votes
1 answer 510 views
+1 vote
1 answer 332 views
+1 vote
1 answer 325 views
+1 vote
0 answers 16 views
+1 vote
1 answer 3.8k views
+1 vote
1 answer 3.4k views
+1 vote
1 answer 433 views
+1 vote
1 answer 592 views
0 votes
1 answer 59 views
asked Oct 28 in Computer Networks by (user.guest)
0 votes
1 answer 48 views
+1 vote
1 answer 50 views
asked Oct 19 in Law for Engineers by (user.guest)
+1 vote
1 answer 75 views
+1 vote
1 answer 161 views
+1 vote
1 answer 288 views
+1 vote
1 answer 86 views
+1 vote
1 answer 309 views
+1 vote
1 answer 121 views
+1 vote
1 answer 163 views
+1 vote
1 answer 180 views
+1 vote
1 answer 151 views
+1 vote
1 answer 188 views
+1 vote
1 answer 77 views
+1 vote
1 answer 372 views
+1 vote
1 answer 128 views
+1 vote
1 answer 62 views
+2 votes
1 answer 765 views
+2 votes
1 answer 384 views
+2 votes
1 answer 949 views
+2 votes
1 answer 349 views
+2 votes
1 answer 787 views
+1 vote
1 answer 99 views
+1 vote
1 answer 99 views
+1 vote
1 answer 213 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...