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

(a)

DDL

(b)

DML

(c)

DCL

(d)

DQL

The clause used to sort data in a database

(a)

SORT BY

(b)

ORDER BY

(c)

GROUP BY

(d)

SELECT

Which of the following is a collection of data entries?

(a)

Database

(b)

Table

(c)

Dbase

(d)

SQL

Which component of SQL includes commands to insert, delete and modify tables in database?

(a)

DCL

(b)

TCL

(c)

DDL

(d)

DML

TCL stands for

(a)

Transmission Control Language

(b)

Transfer Communication Language

(c)

Transaction Communication Language

(d)

Transaction control Language

Write the difference between table constraint and column constraint?

What is the difference between SQL and MYSQL?

What is RDBMS?

How will you create database and work with the database? Give example.

Define TCL.

Write a SQL statement to modify the student table structure by adding a new field.

Write any three DDL commands.

Write a SQL statement using DISTINCT keyword.

List the types of constraints.

Write the function performed by DDL.

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.

Explain ALTER command in detail.

Explain TCL commands in detail.