Time Left - 15:00 mins

GATE CS 2021 : Database Quiz 3 (App update required to attempt this test)

Attempt now to get your rank among 669 students!

Question 1

“Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :

Question 2

Which of the following is not Armstrong’s Axiom?

Question 3

Which two attributes cannot be deleted from second tables if two tables are linked and if student id 2 left the institute and one student’s ID changed from 3 to 7 . Then how to maintain consistency of updated record?

Question 4

How many attribute/ attributes confirmly can be acting as primary key for above table -

Question 5

The following involve the three relations below:

a) R(a, b) = {(0, 1), (4, 5), (8, 9)}.

b) S(b, c) = {(1, 2), (5, 2), (5, 6), (5, 10), (13, 10)}

c) T(c, d) = {(2, 3), (6, 7), (10, 11), (10, 3)}

The number of tuples in R S T, where is the natural join is:

Question 6

Given a set of functional dependencies on R (A, B, C, D, E) find number of candidate keys?

A -> B

BC -> E

DE -> A

  • 669 attempts
  • 2 upvotes
  • 7 comments
Sep 22GATE & PSU CS