Question

Course: Fundamentals of Databases

Write a Query for the Following Table.

Table Name: Student

Stu_ID	Name	Age	Address	Phone
1452364	Alla	22	Riyadh	7772223310
1452365	Ahamed	25	Jeddah	7772223311

a) Write a Query for Create Table:

b) Write a Query for insert filed in above Given Table.

c) Write a Query for Replace Age = 25 Replace by 26 the above given Table.

d) Write a Query for Remove Student ID =1452364 one Row above given Table.

e) Drop Student Table.

f) Arrange name filed at assisting order.

Answer 1

a) CREATE TABLE Student(Stu_ID integer,Name text,Age integer,Address text,Phone integer);

b) INSERT INTO Student VALUES (1452364,'Alla',22,'Riyadh',7772223310);
INSERT INTO Student VALUES (1452365,'Ahamed',25,'Jeddah',7772223311);

Select * from Student;

Output:

c) SELECT REPLACE(Age, 25,26) from Student;

Output:

d) Write a Query for Remove Student ID =1452364 one Row above given Table.

DELETE FROM Student WHERE Stu_ID = 1452364;

Select * from Student;

Output:

e)  DROP TABLE Student;