GATE 2021: Database Rapid Mini Mock (App update required to attempt this test)
Attempt now to get your rank among 463 students!
Question 1
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.
Question 2
If every non-key attribute is functionally dependent on primary key, then the relation will be in
Question 3
The following diagram describes a part of an ER Diagram
Select the false statements among the following on the above diagram:
Question 4
Which of the following statements is true?
Question 5
In ER-model , weak entity meets which of the following conditions is true?
Question 6
When number of entities are bought together into one entity based on their similar characteristics, what is this process called
Question 7
SELECT __________
FROM instructor
WHERE dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary?
Question 8
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?
Question 9
Which of the following is correct?
Question 10
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 _______
Question 11
How many rows will be there in output of the following query for the data given below:
Employee
Teaches
Select *
from Employee
Where exists( select count(*)) from teaches
where Cname = 'CO'
Question 12
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