Register

UGC NET CSE | December 2009 | Part 2 | Question: 20

• retagged by
3,296 views
0 votes
0 votes
Which of the following statement is wrong ?
I. 2-phase locking protocol suffer from dead lock.
II. Time stamp protocol suffer from more aborts.
III. A block hole in a DFD is a data store with only inbound flows.
IV. Multivalued dependency among attribute is checked at 3 NF level.
V. An entity-relationship diagram is a tool to represent event model.

(A) I, II, III

(B) II, III, IV

(C) III, IV, V

(D) II, IV, V
• retagged by
User Avatar

1 Answer

Best answer
3 votes
3 votes

 2-phase locking protocol suffer from dead lock.  TRUE
 Time stamp protocol suffer from more aborts.  TRUE (suffer from cascading rollback)
 A block hole in a DFD is a data store with only inbound flows.  TRUE
 Multivalued dependency among attribute is checked at 3 NF level.  FALSE  (checked at 4 NF level)
An entity-relationship diagram is a tool to represent event model.  FALSE  (tool to represent data model)

• edited by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
rishu_darkshadow asked Sep 17, 2017
2,132 views
UGC NET CSE | December 2009 | Part 2 | Question: 47
Analysis of large database to retrieve information is called (A) OLTP (B) OLAP (C) OLDP (D) OLPP
Analysis of large database to retrieve information is called(A) OLTP(B) OLAP(C) OLDP(D) OLPP
User Avatar
3 votes
3 votes
2 answers
2
rishu_darkshadow asked Sep 17, 2017
6,508 views
UGC NET CSE | December 2009 | Part 2 | Question: 19
A function that has no partial functional dependencies is in __________ form. (A) 3 NF (B) 2 NF (C) 4 NF (D) BCNF
A function that has no partial functional dependencies is in __________ form.(A) 3 NF(B) 2 NF(C) 4 NF(D) BCNF
User Avatar
1 votes
1 votes
1 answer
3
rishu_darkshadow asked Sep 17, 2017
931 views
UGC NET CSE | December 2009 | Part 2 | Question: 18
Match the following : ... $\text{4-a, 3-b, 2-c, 1-d}$ $\text{3-a, 4-b, 1-c, 2-d}$
Match the following :$\begin{array}{clcl} \text{(1)} & \text{Determinants} & \text{(a)}\ & \text{No attribute can be added} \\ \text{(2)} & \text{Candidate key} & \t...
User Avatar
5 votes
5 votes
4 answers
4
rishu_darkshadow asked Sep 17, 2017
6,397 views
UGC NET CSE | December 2009 | Part 2 | Question: 17
Specialization is __________ process. (A) top-down (B) bottom up (C) both (A) and (B) (D) none of these
Specialization is __________ process.(A) top-down(B) bottom up(C) both (A) and (B)(D) none of these
User Avatar
Link Copied!