Question 1 (5 marks)

Question 1

CREATE TABLE called supplier with the following fields .

supplier_id numeric(10)

-

> Primary key

with constraint name

supplier_name

varchar2(50)

-

>unique name

contact_name

varchar2(50)

city varchar2(10)

Region

> should accept only ('N', 'NW', 'NE', 'S', 'SE', 'SW', 'W', 'E')

1.

Insert 5 records

. Insert records based on the below questions .

2.

Disp

lay the details of the supplier

who comes from

Toronto

and

their supplier id 500;

3.

Add phone number

in the supplier table using DDL command

4.

Write a sql command to make city as unused column

5.

Delete the unused column in the supplier table

6.

Rename table SUPPLI

ER

-

> SUPPLIER CONTACT

7.

Write a sql command to delete

all the records in the

supplier table.

8.

Write a sql command to Retrieve the deleted table

9.

Write a sql command to

permanent

ly delete the table , so that it is not

mov

ed to recyclebin