What are the two major components of SQL and what function do they serve?

Answer 1

The Data Definition Language (DDL). This component of the SQL language is used to create and modify tables and other objects in the database. For tables there are three main commands:

CREATE TABLE tablename to create a table in the database

DROP TABLE tablename to remove a table from the database

ALTER TABLE tablename to add or remove columns from a table in the database.

The Data Manipulation Language (DML) component of the SQL language is used to manipulate data within a table. There are four main commands:

then,

SELECT to select rows of data from a table

INSERT to insert rows of data into a table

UPDATE to change rows of data in a table

DELETE to remove rows of data from a table

Answer 2

The two major components of SQL are Data Definition Language (DDL) and Data Manipulation Language (DML). DDL is responsible for defining and modifying the structure of the database, including creating and altering tables. DML is used to manipulate and retrieve data within the database, with commands such as SELECT, INSERT, UPDATE, and DELETE.

Answer 3

[object Object]

Answer 4

DDL And DML