Introduction to SQL

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.



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.