SHARE
SPREAD
HELP

The Tradition of Sharing

Help your friends and juniors by posting answers to the questions that you know. Also post questions that are not available.

To start with, Sr2Jr’s first step is to reduce the expenses related to education. To achieve this goal Sr2Jr organized the textbook’s question and answers. Sr2Jr is community based and need your support to fill the question and answers. The question and answers posted will be available free of cost to all.

Sharing the knowledge gained, is a generous way to change our world for the better. -Sr2Jr

 

#
Authors:
Elmasri Navathe
Chapter:
System Concepts And Architecture
Exercise:
Review Questions
Question:6 | ISBN:9780133970777 | Edition: 7

Question

What is the difference between procedural and nonprocedural DMLs

 

TextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbookTextbook

Answer

Ans:Nonprocedural DML can be used on its own to specify complex database operations.It is a high level DML.High level DML statements are entered from a terminal or embedded in a general purpose programming language.

Procedural DML:It is known as low level DML.It must be embedded in a general purpose programming language.It retrives individual records or objects from the database.So that it needs to use programming language constructs,such as looping,to retrieve and process each record from a set of records.Because of this property these are called record-at-a-time.

0 0

Discussions

Post the discussion to improve the above solution.