Advantages and disadvantages of data manipulation language in sql?

Answer 1

Data Manipulation Language (DML) in SQL, such as SELECT, INSERT, UPDATE, DELETE, allows users to retrieve, modify, and delete data in a database. One advantage of DML is its flexibility in manipulating data, enabling users to perform complex queries and updates. However, a disadvantage is the potential for human error when writing DML statements, which can lead to unintended data modifications or deletions. Additionally, DML operations can impact database performance, especially when dealing with large datasets.

Answer 2

advantages of data manipulation language:


1.the DML statements can modify the data stored in a database.
2.user can specify what data is needed.
3.dml tends to have many different flavours and capabilities between database vendors.
4.it provides efficient human interaction with the system.



disadvantages of data manipulation language:


1.dml cannot be used to change the database structure.
2.tables or columns cannot be created or deleted using dml.