Find users

Test Paper - Database Management - Mumbai University - Computer Science - 4th Semester - 2007

DBMS (Database Management Systems)

Post: September 22th, 2011
Description
structure of DBMS, validation based protocol, generalized projection, assertion, integrity constraint, ER Diagram, 1NF, 2 NF, 3 NF, deadlock, deadlock prevention,deadlock recovery
structure of DBMS, validation based protocol, generalized projection, assertion, integrity constraint, ER Diagram, 1NF, 2 NF, 3 NF, deadlock, deadlock prevention,deadlock recovery
-
Embed this document

Related videos

Report Report

Reason:

Send Message

Login or register to download this document!

If you are already registered, login otherwise Register , it just takes 1 minute!

Uploaded by:

jamal_11

jamal_11
Universityuni_5documents_40
Embed this document
Get the App
Contents
~ P4/RT -Ex-O? -428 Can. 260S-07. 5. E-. CCa.rrv>uJai) t$~tY\.1I') J)cJ-o.- 0~~ ~ kYV\..$. . [REVISEDCOURSE] (3 Hours) ~ f2ey. 2-7-) s-l 01ND-S162 L;J;~ (Total Marks: 100 N.S.: (1) Question NO.1 is compulsory. (2) Attempt any four questions out of remaining six questions. (3) Make suitable assumptions if needed. 1. (a) Explain the structure of DBMS. (b) Explain the insertion of entry in a B+ tree. (c) Explain validation based protocol. 2. (a), Explain following relational algebraic operations with example. (i) Division .. ~ 6 7 7 10 (ii) Generalized Projection' (iii) Rename (iv) Assignment (v) Outer Join' (b) What is view? How it is defined and stored? What are benefits and limitationof view? 10 (a) What is recoverable schedule? Why recoverabilityof schedule is desirable? Are there 10 'any circumstances under which it would be desirable to allow non-recoverable schedule? Explain. (b) What is deadlock? Discuss various strategies for deadlock prevention and 10 deadlock recov..

Docsity.com

Learning becomes social!

Authentication required

This feature is reserved for registered user

Register Login

Docsity.com

Learning becomes social!

Authentication required

Hi!
In order to freely download all the documents on Docsity, please register or login:

Register Login