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 is

(a)

DROP

(b)

DELETE

(c)

DELETE ALL

(d)

ALTER TABLE

Which of the following is a standard programming language to access and manipulate database?

(a)

MySQL

(b)

SQL

(c)

PHP

(d)

Python

Which of the following is a collection of data entries?

(a)

Database

(b)

Table

(c)

Dbase

(d)

SQL

Which of the following processing skills of SQL provides commands for defining relation schemes?

(a)

MySQL

(b)

DDL

(c)

DML

(d)

DCL

Write the difference between table constraint and column constraint?

What is the difference between SQL and MYSQL?

What is the use of WAMP?

Define Data Manipulation Language.

Define TCL.

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

Write any three DDL commands.

How will set a primary key for more than one field? Explain with example.

How will you generate queries and retrieve data from the table? Explain?

Write the different categories of SQL commands.

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

Explain ALTER command in detail.