MODULE 23: SQL – COMPUTER SCIENCE.
Trusted by students across multiple disciplines!
What is SQL? - Answer: Structured Query Language (SQL) is used to create and use
databases, tables, and relationships.
What is RDBMS? - Answer: Relational database Management Systems are database
management systems that maintain data records and indices in tables. Relationships
may be created and maintained across and among the data and tables
What are the SQL sub-languages? - Answer: Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Transaction Control Language (TCL)
What is a Data Definition Language? - Answer: A sublanguage that deals with the
creation, alteration or deletion of our tables structure.
CREATE
ALTER
DROP - Deletes the table
TRUNCATE - Takes all information out of the table
What is Data Manipulation Language? - Answer: A specialized language is used to add,
change, delete, and retrieve the data in the database. This language also contains
commands that permit end users and programming specialists to extract data from the
database to satisfy information requests and develop applications
INSERT (create)
SELECT (read)
UPDATE (update)
DELETE (delete)
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
Trusted by students across multiple disciplines!
What is SQL? - Answer: Structured Query Language (SQL) is used to create and use
databases, tables, and relationships.
What is RDBMS? - Answer: Relational database Management Systems are database
management systems that maintain data records and indices in tables. Relationships
may be created and maintained across and among the data and tables
What are the SQL sub-languages? - Answer: Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Transaction Control Language (TCL)
What is a Data Definition Language? - Answer: A sublanguage that deals with the
creation, alteration or deletion of our tables structure.
CREATE
ALTER
DROP - Deletes the table
TRUNCATE - Takes all information out of the table
What is Data Manipulation Language? - Answer: A specialized language is used to add,
change, delete, and retrieve the data in the database. This language also contains
commands that permit end users and programming specialists to extract data from the
database to satisfy information requests and develop applications
INSERT (create)
SELECT (read)
UPDATE (update)
DELETE (delete)
1
APPHIA - Crafted with Care and Precision for Academic Excellence.
