Q1.

CREATE TABLE CUSTOMER

(

CUSTNAME varchar(20) NOT NULL,

CUSTID CHAR NOT NULL PRIMARY KEY,

CITY VARCHAR (20)

);

Q2.

SQL>DESC CUSTOMER;

Q3.

INSERT INTO CUSTOMER(CUSTNAME ,CUSTID ,CITY ) VALUES ('SANA', 'S2134' , 'RAFHA');

INSERT INTO CUSTOMER(CUSTNAME ,CUSTID ,CITY ) VALUES ('MAHA', 'S4326' , 'RIYADH');

INSERT INTO CUSTOMER(CUSTNAME ,CUSTID ,CITY ) VALUES ('ZEEN', 'J4367' , 'DAMM');

INSERT INTO CUSTOMER(CUSTNAME ,CUSTID ,CITY ) VALUES ('LILA', 'L8796' , 'JEDD');

Q4.

ALTER TABLE CUSTOMER

ADD COLUMN MOBILE_NO INT ;

Q5.

SELECT * FROM CUSTOMER;