Anonymous

What Do You Know About Non-Procedural And Procedural Data Manipulation Language (DML)?

5

5 Answers

Muhammad Azhar Profile
Muhammad Azhar answered
Non-Procedural DML:  A high-level or non-procedural DML allows the user to specify what data is required without specifying how it is to be obtained. Many DBMSs allow high-level DML statements either to be entered interactively from a terminal or to be embedded in a general-purpose programming language.    The end-users use a high-level query language to specify their requests to DBMS to retrieve data. Usually a single statement is given to the DBMS to retrieve or update multiple records. The DBMS translates a DML statement into a procedure that manipulates the set of records. The examples of non-procedural DMLs are SQL and QBE (Query-By-Example) that are used by relational database systems. These languages are easier to learn and use. The part of a non-procedural DML, which is related to data retrieval from database, is known as query language.    Procedural DML:  A low-level or procedural DML allows the user, i.e. Programmer to specify what data is needed and how to obtain it. This type of DML typically retrieves individual records from the database and processes each separately. In this language, the looping, branching etc. Statements are used to retrieve and process each record from a set of records. The programmers use the low-level DML.
Anonymous Profile
Anonymous answered
Allows user programmer to specify what is needed and how to obtain it.and non procedural specify user what data is required without specifying how it is obtained
Anonymous Profile
Anonymous answered
There are two types of Data manipulation language (DML). One is known as nonprocedural DML and other is known as procedural DML.

Nonprocedural DML: It is also known as high level Data Manipulation language. It is used to specify complex database operations. We can enter these high level DML statements from a display monitor with the help of Database Management Systems or these statements can also be entered through a terminal. We can also embed these high level DML statements in a programming language.
Procedural DML: It is also known as low level DML. It is used to get data or objects from the database. It processes each operation separately. That's why it has to use programming language constructs to get a record or to process each record from a set of records. Because of this property low level DML is also called set at a time or set oriented DMLs.
Low level and high level DMLs are considered as part of the query language because both languages may be used interactively. Normally casual database (end) users use a nonprocedural language.
Anonymous Profile
Anonymous answered
Procedural language commands will used in specific statements only.
Nonprocedural language commands will be used anywhere in the program.

Answer Question

Anonymous