Categories

Databases management systems

CSE - Databases management systems - Questions and solutions
Question:-
Option (A)
Y Í X
Option (B)
Y Ì X
Option (C)
X Í Y
Option (D)
X Ì and Y Ì X
Correct Option:
A
Question:-
Option (A)
Tuple
Option (B)
Attribute
Option (C)
Entity
Option (D)
Degree
Correct Option:
B
Question:-
Option (A)
Lost update
Option (B)
Uncommitted dependency
Option (C)
Inconsistent data
Option (D)
Deadlock
Correct Option:
A,B,C
Question:-
Option (A)
R has no duplicates and S is non-empty
Option (B)
R and S have no duplicates
Option (C)
S has no duplicates and R is non-empty
Option (D)
R and S have the same number of tuples
Correct Option:
A
Question:-
Option (A)
First normal form
Option (B)
Second normal form
Option (C)
Third normal form
Option (D)
Fourth normal form
Correct Option:
C
Question:-
Option (A)
pcustomer_name(rbalance > 1000 (Deposit))
Option (B)
rcustomer_name (pbalance > 100(Deposit))
Option (C)
pcustomer_name (rbalance > 1000 (Borrow))
Option (D)
rcustomer_name (pbalance > 1000 (Borrow))
Correct Option:
A