Time Left - 30:00 mins

GATE 2021: Database Rapid Mini Mock (App update required to attempt this test)

Attempt now to get your rank among 441 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

  • 441 attempts
  • 1 upvote
  • 4 comments
Dec 12GATE & PSU CS

Posted by:

Harshita AgarwalHarshita AgarwalMember since Jul 2020
Share this quiz   |