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 clause used to sort data in a database

(a)

SORT BY

(b)

ORDER BY

(c)

GROUP BY

(d)

SELECT

Which of the following language was designed for managing and accessing data in RDBMS?

(a)

DBMS

(b)

DDL

(c)

DML

(d)

SQL

The specific related information about every record in the table is maintained by

(a)

language

(b)

relation

(c)

tuple

(d)

field

Differentiate Unique and Primary Key constraint

Write the difference between table constraint and column constraint?

What is the difference between SQL and MYSQL?

What is SQL?

What is RDBMS?

What is the use of WAMP?

Define TCL.

Write the syntax of creating table in database.

Write any three DDL commands.

Write the use of Savepoint command with an example.

List the data types used in SQL.

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

Write a SQL statement to create a table for employee having any five fields and create a table constraint for the employee table.