GATE 2021: Database Rapid Mini Mock (App update required to attempt this test)
Attempt now to get your rank among 441 students!
The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
If every non-key attribute is functionally dependent on primary key, then the relation will be in
The following diagram describes a part of an ER Diagram
Select the false statements among the following on the above diagram:
Which of the following statements is true?
In ER-model , weak entity meets which of the following conditions is true?
When number of entities are bought together into one entity based on their similar characteristics, what is this process called
WHERE dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary?
Consider the following SQL Queries: Employee (Eid, Ename, sal) S1: SELECT count (*) FROM Employee; S2: SELECT count (Eid) FROM Employee; Which of the following is true?
Which of the following is correct?
Suppose we are given a schedule with three transaction T1, T2 and TAssume that the no of operation in T1 T2 and T3 are m, n and p respectively. How many no of schedules are there which are non-serial? Suppose value of m=5, n=4, p=3 _______
How many rows will be there in output of the following query for the data given below:
Where exists( select count(*)) from teaches
where Cname = 'CO'
Consider the following statements:
1: Select * from R
2: (Select * from R) INTERSECT (Select * from R)
3: Select Distinct * from R
What is the maximum number of statements that produce the same output? If all the statements produde different output then your answer should be