June 2015 - Paper 2

1. Home
2. UGC NET Computer Science Solved Papers
3. June 2015
4. Paper 2

16:  

An Assertion is a predicate expressing a condition we wish database to always satisfy. The correct syntax for Assertion is :

A.	CREATE ASSERTION',ASSERTION Name', CHECK',Predicate',
B.	CREATE ASSERTION 'ASSERTION NAME'
C.	CREATE ASSERTION, CHECK Predicate
D.	SELECT ASSERTION
	Answer Report Discuss
	Option: A Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

17:  

Which of the following concurrency protocol ensures both conflict serializability and freedom from deadlock ?

(a) 2-phase Locking

(b) Time stamp - ordering

A.	Both (a) and (b)
B.	(a) only
C.	(b) only
D.	Neither (a) nor (b)
	Answer Report Discuss
	Option: C Explanation : Click on Discuss to view users comments. D.Krishnakumar said: (8:38pm on Monday 29th June 2015) option (C) is correct, because Timestamp-based concurrency control algorithm is a non-lock concurrency control method. In Timestamp based method, deadlock cannot occur as no transaction ever waits. Write your comments here: Updating your Comments.. Updating your Comments..

18:  

Drop Table cannot be used to drop a Table referenced by ------ constraint.

(a) Primary key (b) Sub key (c) Super key (d) Foreign key

A.	(a)
B.	(a), (b) and (c)
C.	(d)
D.	(a) and (d)
	Answer Report Discuss
	Option: C Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

19:  

Database applications were built directly on top of file system to overcome the following drawbacks of using filesystems

(a) Data redundancy and inconsistency

(b) Difficulty in accessing Data

(c) Data isolation

(d) Integrity problems

A.	(a)
B.	(a) and (d)
C.	(a), (b) and (c)
D.	(a), (b), (c) and (d)
	Answer Report Discuss
	Option: D Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

20:  

For a weak entity set to be meaningful, lt must be associated with another entity set in combination with some of their attribute values, is called as :

A.	Neighbour Set
B.	Strong Entity Set
C.	Owner entity set
D.	Weak Set
	Answer Report Discuss
	Option: C Explanation : Click on Discuss to view users comments. Write your comments here: Updating your Comments.. Updating your Comments..

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »