CS403 Fall 2011 Final Term Feb 2012 – VU Current Paper – 06 Feb 2012

40 MCQ’S
4 Question of 2 Marks
4 Question of 3 Marks
4 Question of 5 Marks

Main Topics are:
Deadlock, Views, Transactions,
Question:- 2 Marks:
When Deadlock Occur;

5 questions ki sql ki query likhni thi in main sy 2 marks 3 marks and 5 k questions b thy.

Ik 5 marks ka question tha, a deadlock occur when the one transaction read to multiple transaction or esi quesiton ka 2sra part the k Wait For Map joining k use kerty hain if both statement are true or not true brief answer in detail.

Ik 5 marks ka question tha:

If a table 1 and table 2 have same entity and the table 1 is 20 index and the table 2 14 index. then the sequential file access use these operations (Insertion, udation or selection) on both table, if the statement true or nor justify answer in detail.

Ik 5 marks ka question the:

Over flow better then Chaining if this statement true or false justify answer in detail.