Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.

(a)

DDL

(b)

DML

(c)

DCL

(d)

DQL

Which command lets to change the structure of the table?

(a)

SELECT

(b)

ORDER BY

(c)

MODIFY

(d)

ALTER

The command to delete a table including the structure is

(a)

DROP

(b)

DELETE

(c)

DELETE ALL

(d)

ALTER TABLE

Queries can be generated using

(a)

SELECT

(b)

ORDER BY

(c)

MODIFY

(d)

ALTER

The clause used to sort data in a database

(a)

SORT BY

(b)

ORDER BY

(c)

GROUP BY

(d)

SELECT

Write a query that selects all students whose age is less than 18 in order wise.

Write the difference between table constraint and column constraint?

What is the difference between SQL and MYSQL?

Write any three DDL commands.

Write the use of Savepoint command with an example.

Write a SQL statement using DISTINCT keyword.

What are the components of SQL? Write the commands in each.

Construct the following SQL statements in the student table-
(i) SELECT statement using GROUP BY clause.
(ii) SELECT statement using ORDER BY clause.