Time Left - 12:00 mins
GATE CS 2019 - Database(Database Design) Quiz-2 (App update required to attempt this test)
Attempt now to get your rank among 785 students!
Question 1
The AS clause can appear in
Question 2
Consider the following Statements:
1) An Entity Integrity constraint states that primary key value cannot be null.
2) A referential integrity constraint is specified between two relations.
3) A foreign key cannot be used to refer its own relation.
Which of the above statement are correct?
1) An Entity Integrity constraint states that primary key value cannot be null.
2) A referential integrity constraint is specified between two relations.
3) A foreign key cannot be used to refer its own relation.
Which of the above statement are correct?
Question 3
Given an instance of the STUDENTS relation as shown below:
For (Student Name, Student Age) to be a key for this instance, the value X should NOT be equal to____.
For (Student Name, Student Age) to be a key for this instance, the value X should NOT be equal to____.
Question 4
Consider the following declaration
F = {W →X, X → Y, W →XY} then which of the following statement is correct about ?
I. includes W → W, X →X, Y → Y
II. includes W → X, X →Y, W → XY
III. includes W → Y, W→Z
F = {W →X, X → Y, W →XY} then which of the following statement is correct about ?
I. includes W → W, X →X, Y → Y
II. includes W → X, X →Y, W → XY
III. includes W → Y, W→Z
Question 5
Find out the number of candidate keys of following Relation R(ABCDEFGH)
CH->G, A->BC, B->CFH, E->A, F->EG
CH->G, A->BC, B->CFH, E->A, F->EG
Question 6
What is true ?
i) Changes in data done by execution of instruction of a transaction are directly stored in database.
ii) Database in committed & aborted state of transaction is always consistent.
iii) Phantom read problem during concurrency of transactions is about not finding a variable.
iv) Normalization is the solution of redundancy problem.
i) Changes in data done by execution of instruction of a transaction are directly stored in database.
ii) Database in committed & aborted state of transaction is always consistent.
iii) Phantom read problem during concurrency of transactions is about not finding a variable.
iv) Normalization is the solution of redundancy problem.
- 785 attempts
- 9 upvotes
- 14 comments
Tags :
GATE & PSU CSDatabasesApr 1GATE & PSU CS