Trending ▼   ResFinder  

PUNJAB TECHNICAL UNIVERSITY MCA - II (SEM 4) MAY 2008 : 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) (Sem. - 4th) RELATIONAL DATABASE MANAGEMENT SYSTEM - II Time : 03 Hours Maximum Marks : 75 Instruction to Candidates: 1) Section - A is Compulsory. 2) Attempt any Nine questions from Section - B. Q1) Section - A (15 2 = 30) a) What is the difference between simple and composite attributes? b) What is a heterogeneous DBMS. c) What is the difference between total and partial generalization? d) What is a transaction? e) What is an object oriented database? f) What do you mean by atomic domain? g) What is multivalued dependency? h) What are client-server systems? i) What are non-procedural languages? j) What is a tuple variable? k) What is the process of data mining? l) What are log records? m) What is a data warehouse? n) What is data fragmentation? o) What is log-based recovery? Section - B (9 5 = 45) < Q2) Make a comparison of centralized versus decentralized design of a database management system. D - 395 P.T.O. Q3) Explain the database life cycle with the help of suitable block diagram. Q4) Define the concept of generalization. Give two examples where this concept is useful. Q5) What are the advantages of encrypting data stored in the database? Q6) Discuss the advantages and disadvantages of distributed database management system. Q7) Discuss the various levels of data and process distribution. Q8) Discuss the architecture of a client server system. Q9) Why are certain functional dependencies called trivial functional dependencies? Q10) What benefit does strict two-phase locking provide? Q11) What is a decision support system? Discuss the various requirements of a decision support system database. Q12) How online analytical processing (OLAP) tools help analysts to view data summarization. Q13) Describe benefits and drawbacks of a source driven architecture for gathering of data at a warehouse as compared to destination driven architecture. D - 395 2

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - II (sem 3) May 2008 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