FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Examples of procedural DMLs include languages such as COBOL, FORTRAN, and PL/SQL. It is a type of DML where we specify what data we want and how we get it. A procedural language is difficult to learn.

Detailed explanation-2: -There are two types of DML, divided into the High-Level or Non-Procedural DML and the Low-level or Procedural DML.

Detailed explanation-3: -The procedural or low-level DML requires the user to specify what data are required and how to access that data by providing a step-by-step procedure. For example, relational algebra is a procedural query language. Here are some tasks that come under DML: Select: It is used to retrieve data from a database.

Detailed explanation-4: -Low-level DMLs are also called record-at-a-time DMLs because of this property. DL/1, a DML designed for the hierarchical model, is a low-level DML that uses commands such as GET UNIQUE, GET NEXT, or GET NEXT WITHIN PARENT to navigate from record to record within a hierarchy of records in the database.

Detailed explanation-5: -A DML is a language which enables users to access and manipulate data. The goal is to provide efficient human interaction with the system. There are two types of DML: procedural: the user specifies what data is needed and how to get it. nonprocedural: the user only specifies what data is needed.