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
Tags :
GATE & PSU CSDatabasesSep 22GATE & PSU CS