Trending ▼   ResFinder  

PUNJAB TECHNICAL UNIVERSITY MCA - II (SEM 4) SEP 2010 : Relational Database Management Systems - II

2 pages, 27 questions, 0 questions with responses, 0 total responses,    0    0
mca_india
   		+Fave Message
ProfileTimelineUploadsQ & A
 Home > mca_india >

Formatting page ...

Roll No........................... Total No. of Questions : 13] [Total No. of Pages : 02 Paper ID [A0516] (Please fill this Paper ID in OMR Sheet) MCA (401) (S05) (O) (LE) (Sem. - 4th) RDBMS - II Time : 03 Hours Instruction to Candidates: 1) Section - A is Compulsory. 2) Attempt any Nine questions from Section - B. Maximum Marks : 75 Section - A Q1) (15 2 = 30) a) How do system analysis and system development fit into a discussion about information system? b) Discuss the distinction between centralized and decentralized conceptual design. c) What is a consistent database state and how it is achieved? d) List four transaction properties. e) What is lock? How in general does it work? f) What are the advantages of DDBMS? g) Describe the difference between distribute database and distribute database processing. h) How main components of DSS interact to form a system? i) What is OLAP? j) What is data mining? k) What is the difference between homogeneous and heterogeneous database systems? l) What is timestamp? m) Define the term Domain of a database. n) What is the need of concurrency control? o) Give some disadvantages of database systems. A-534 P.T.O. Section - B (9 5 = 45) Q2) What DBMS component is responsible for concurrency control? How is this feature used to resolve conflicts? Q3) Describe three data fragmentation strategies. Give some examples. Q4) Describe the different types of database requests and transactions. Q5) What is data warehouse and what are its main characteristics? Q6) Explain what is meant by DDBMS and discuss the motivation in providing the such system. Q7) Briefly outline the criteria groups used to access the dimensionality of a data warehouse. Q8) Discuss how data mining can realize the value of data warehouse. Q9) Describe the characteristics of multidimensional data and how this data can be best represented. Q10) Describe the evolution from centralized DBMS to distributed DBMS. Q11) Explain the concept of serial, nonserial and serializable schedules. Q12) Write an algorithm for shared and exclusive locking. How does granularity affect this algorithm. Q13) Explain MPSD (Multiple-site Processing, Single-site Data) A -534 2

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - II (sem 4) September 2010 Question Paper - Relational Database Management Systems - II
Tags : mca exam papers, mca question papers, ignou mca question papers, ptu mca question papers, mca sample question paper, mca mumbai university question papers, mca exam syllabus, mca exam question paper, online mca exam papers, online mca exam preparation, mumbai university mca question papers, ignou university mca question papers  


© 2010 - 2025 ResPaper. Terms of ServiceContact Us Advertise with us

 

mca_india chat