ACTIVITY TASK MODULE #3

 Activity task module no.3


A Data Definition Language (DDL) is a language used to define and manipulate the structure of a database. DDL statements are used to create, modify, and delete database objects such as tables, indexes, views, and stored procedures.

DDL commands typically include statements like CREATE, ALTER, and DROP, which are used to create, modify, and delete database objects, respectively. These statements allow users to define the characteristics of each object, such as its name, data type, length, and other attributes.



An Interactive Data Manipulation Language (IDML) is a type of programming language that allows users to interactively manipulate data stored in a database. IDML provides a set of commands and syntax that can be used to query and modify the data in a database. Unlike DDL, which is used to define and manage the structure of a database, IDML is used to manipulate the data within that structure.

An Embedded Data Manipulation Language (EDML) is a type of programming language that is embedded within another programming language or application. EDML provides a set of commands and syntax that can be used to manipulate data stored in a database, within the context of another application or programming language.




Comments

Post a Comment

Popular posts from this blog

What Is SQL

Image
  Relational databases are managed and worked on using the standard programming language SQL (Structured Query Language). It is frequently used to carry out a number of actions on databases, including adding, deleting, and changing tables and records.  Users can run SQL queries, which are used to extract particular data from databases. These queries might be as straightforward as simple data searches or as intricate as procedures involving several tables and conditions.  Database administrators, data analysts, and developers all utilize SQL to store, retrieve, and alter data. It is a vital tool for data management in contemporary enterprises and is widely utilized in a variety of sectors, including banking, healthcare, and retail. SQL is frequently used in various industries and applications where data storage and retrieval are essential. Some of the common areas where SQL is used are: 1. Business applications: SQL is used in business applications such as Enterprise Resource Planning (
Read more