Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University) Computer M.C.A.(Second Semester) Examination,Nov.-Dec.,2007 model question papers



Download Model question papers & previous years question papers

Posted Date: 12 Jul 2009      Posted By:: rajesh kale    Member Level: Silver  Points: 5 (₹ 1)

2007 Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University) Computer M.C.A M.C.A.(Second Semester) Examination,Nov.-Dec.,2007 Question paper



Course: M.C.A   University/board: Rajiv Gandhi Proudyogiki Vishwavidyalaya(Technical University)





MCA-202
M.C.A.(Second Semester) Examination,Nov.-Dec.,2007
DATABASE MANAGEMENT SYSTEM
(MCA-202)
Time : Three Hours
Maximum Marks : 100
Minimum Pass Marks : 40

Note : Attempt any two parts of each question. All questions carry equal marks.

1.(a) Define Database Management System(DBMS).Discuss the responsibilities of DBA.
(b) Software India Ltd. is an organization involved in the design, development and marketing of
software products for a family of advanced personal computers.What entities are of interest
to such an enterprise ? Give a list of these entities and the relationship among them.
(c) Define the following :
(i) E-R Model
(ii)DBMS architecture

2.(a) Discuss Different types of key. For each case, give a suitable example. What is a foreign key
constraint ? Why is such constraint important ?
(b) Explain the following :
(i) SQL and its operation
(ii) Relational calculus
(c) What do you understand by Query processing and optimization ? Discuss in detail.

3.(a) Why do we need normailized data ? What is BCNF ? Discuss.
(b) Consider a relation R(A.B.C.D.E.). The following dependencies are given :
A -> B, BC -> E, ED ->
Find all keys of relations R. Is R in BCNF ? Justify your answer.
(c) Explain the following :
(i) Multivalued dependencies
(ii) Dependency preservation

4.(a) Discuss various transaction states with their description and state diagram.
(b) Explain the following :
(i) ACID properties
(ii) Checkpoints
(iii) Data fragmentation
(c) Enlist different schemes of database recovery and explain any one in detail.

5.(a) What do you understand by file organization ? Discuss different approaches of file
organization along with their merits and demerits.
(b) Explain the following :
(i) Object Oriented Database
(ii) Video servers
(iii) Data warehousing
(c) Explain the difference between each of the following
(i) Primary versus secondary indexes
(ii) Dense versus sparse indexes
(iii) Clustered versus unclustered indexes





Return to question paper search

Next Question Paper: Sample Paper – 2009 English

Previous Question Paper: Compter Hardware design

Related Question Papers:


  • M.C.A.(Third Semester) EXAMINATION,June,2008


  • M.C.A.(Third Semester) EXAMINATION,Dec.,2008


  • M.C.A.(Third Semester) EXAMINATION,June,2008


  • M.C.A.(Fourth Semester) EXAMINATION,Dec.,2008


  • M.C.A.(Second Semester) EXAMINATION, June,2007


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.


    Looking for University or College admissions in India for 2021 - 2022 Academic Year?

    APPLY NOW
    Top Contributors
    TodayLast 7 Daysmore...

    Awards & Gifts
     
    SpiderWorks Technologies Pvt Ltd, Kochi - India. © All Rights Reserved.