Quiz 2 Solution

 //Q1-

create table Employee(

eid int not null,

primary key (eid),

ename varchar(50),

salary money,

hiredate date,

jobtitle varchar(40),

Departmentno int,

DepartmentLocation varchar(50)

)

insert into Employee values (401,'Azam Mustafa',35000,'2020-01-16','react Developer',4,'karachi'),

(402,'Baseer vodha',25400,'2020-01-16','Java Developer',3,'lahore'),

(403,'Wali Haider',32000,'2020-01-16','pascal Developer',2,'karachi'),

(404,'Tayyab Anwar',12500,'2020-01-16','c# Developer',1,'pindy'),

(405,'Salman Ghouri',31000,'2020-01-16',' mern stack Developer',4,'karachi')

//Q2-

UPDATE Employee SET ename = 'Baseer vohra' WHERE eid = 402

Update tablename set fieldname='change' where samefieldid='fieldid'

//Q4

Delete from Employee WHERE salary>30000

//Q5

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

//Q6

CREATE VIEW EMPLOYEEVIEW AS

SELECT ename,salary,hiredate,jobtitle,DepartmentLocation FROM Employee 

WHERE DepartmentLocation='karachi'

//Q7

SELECT ename,len(ename) AS Ename FROM Employee;

//Q8

SELECT ename,salary+500 As '500+salary' FROM Employee;

//Q9

CREATE TABLE Airreservation  

(  

  AId INT PRIMARY KEY,  

  Passengername VARCHAR(45),  

  ticketno INT,

  seatno INT  

)  

insert into Airreservation values (403,'salman',101,22)

Delete from Airreservation where AId=403

update Airreservation set Passengername='baseer vohra' where AId=401

select * from Airreservation

select * from ARstatus

CREATE TABLE ARstatus 

(    

ARsId int IDENTITY,   

ARstatus text   

)  

create Trigger ARsinsert

ON Airreservation

for insert 

As begin

Declare @id int

select @id=AId from inserted

insert into ARstatus values ('Data Insert Sucessfully in table '+ CAST(@id as varchar(10)))

end

create Trigger ARsUpdate

ON Airreservation

for update 

As begin

Declare @id int

select @id=AId from inserted

insert into ARstatus values ('Data Update Sucessfully in table '+ CAST(@id as varchar(10)))

end

create Trigger ARsDelete

ON Airreservation

for DELETE 

As begin

Declare @id int

select @id=AId from inserted

insert into ARstatus values ('Data Delete Sucessfully in table ')

end

drop Trigger ARsDelete

//Q10

UPDATE Employee SET hiredate = '2020-12-25'

//Q11

SELECT ename,jobtitle,DepartmentLocation,Departmentno FROM Employee 

WHERE DepartmentLocation='lahore'

Browse More Articles

Tweet

Written by Ghouri Admin

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.