plz no hand writing or photos SQL DDL & DML Purpose The purpose of this assignme
ID: 3705060 • Letter: P
Question
plz no hand writing or photos
SQL DDL & DML
Purpose
The purpose of this assignment is to help you learn more about SQL.
Brief Introduction
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Action Items
Compare and contrast DDL commands with DML commands. You are requested to submit one example of SQL query for DDL and one for DML and discuss them with your friends.
Explanation / Answer
DDL is Data Definition Language:
Its defines the data structure
e.g CREATE TABLE , DROP, ALTER,TRUNCATE statement etc.
SQL Queries :
DML is Data Manipulation Language :
Its define the manipulation of the data.
e.g :Select, Insert, Update, Delete etc
SQL Queries :
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.