SQL and SQL Commands

Question 1

What are two components within SQL?

Answer 1

• DDL(Data Definition Language) modifies the structure of a database.
• DML(Data Manipulation Language) modifies the data within the database.

Question 2

What are the 4 common commands within DDL? And what do they do?

CREATE, ALTER, DROP, Permissions

Answer 2

• CREATE: Creates a table or Database.
• ALTER: Changes the structure of a table or database.
• DROP: Deletes a table or database.
• Permissions enable who can modify the database with DDL.

Question 3

What are the four major commands within DML?

SELECT, INSERT, DELETE, UPDATE

Answer 3

• SELECT: selects or retrieves information (records & fields) from a database.
• INSERT: adds new records (rows) to a database table.
• DELETE: removes records from a database table.
• Update: modifies existing records in a database table.