Introduction to SQL - Technical MCQs

Q1:

SQL data definition commands make up a(n) ________ .

A DDL

B DML

C HTML

D XML

ANS:A - DDL

DDL:

Data Definition Language (DDL) statements are used to define the database structure or schema. examples:

CREATE - to create objects in the database.
ALTER - alters the structure of the database.

DML:

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

SELECT - retrieve data from the a database.
INSERT - insert data into a table.
UPDATE - updates existing data within a table.

DCL:

Data Control Language (DCL) statements

TCL:

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.