Answer:
The trigger code is given below
create trigger F1_Del
after delete on Friend
for each row
when exists (select * from Friend
where ID1 = Old.ID2 and ID2 = Old.ID1)
begin
delete from Friend
where (ID1 = Old.ID2 and ID2 = Old.ID1);
end
create trigger F1_Insert
after insert on Friend
for each row
when not exists (select * from Friend
where ID1 = New.ID2 and ID2 = New.ID1)
begin
insert into Friend values (New.ID2, New.ID1);
end
Answer:
D). Algorithm
Explanation:
The set of specific, sequential steps that describe exactly what a computer program must do to complete the work is called an algorithm.
From the question, it is clear the correct option is algorithm.
In simple terms, to solve a problem the set of rules to follow is called algorithm. Algorithm in computer programming describes the steps that explains not only the task that needs to be performed, but also how to do it.
In algorithm, the steps are needed to be in the right sequence.
In my opinion, technology is uniting people, especially nowadays technology has helped friends and family that live far to communicate with each other, it has brought families close when they sit in the living room watching some movie.
It is probably a hyperlink, but it could be an action.
