In the given

query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

Which

of the following is not an aggregate function in SQL?

Suppose relation R(A,B,C) has the tuples:

Which of the following columns cannot be directly indexed without extra mechanisms?

Which

keyword allows us to find the unique values in the database?

Given R(A,B,C,D,E,F) and S={A→C,A→D,D→E,E→F}, what is A+

Consider relation Student(ID, Name, Major, Dept, HOD) with FDs:

• ID → Name, Major

• Major → Dept

• Dept → HOD

Primary Key = {ID}

Which of the following clauses in SQL allows us to

extract data in a range?

CREATE TRIGGER Products_Update

ON Products

FOR UPDATE

AS

INSERT INTO PriceTracking(ProductID, Time, OldPrice, NewPrice)

SELECT I.ProductID, GETDATE(), D.UnitPrice, I.UnitPrice

FROM Inserted I

INNER JOIN Deleted D

ON I.ProductID = D.ProductID

AND I.UnitPrice <> D.UnitPrice;

What is the purpose of this trigger?

Suppose relations R(A,B) and S(B,C,D) are as

follows:

Compute the full outer join on B, the left outer join on B, and

the right outer join on B. In each case, R is the left operand and S is the

right operand. Find the correct statement in the list below