⟩ Do you know Data Definition Language, Data Control Language and Data Manipulation Language?
Data Definition Language (DDL):- are the SQL statements that define the database structure.
Example:
a. CREATE
b. ALTER
c. DROP
d. TRUNCATE
e. COMMENT
f. RENAME
Data Manipulation Language (DML):- statements are used for manipulate or edit data.
Example:
a. SELECT - retrieve data from the a database
b. INSERT - insert data into a table
c. UPDATE - updates existing data within a table
d. DELETE
e. MERGE
f. CALL
g. EXPLAIN PLAN
h. LOCK TABLE
Data Control Language (DCL):-statements to take care of the security and authorization.
Examples:
a. GRANT
b. REVOKE
