Trending ▼   ResFinder  

PUNJAB TECHNICAL UNIVERSITY MCA - II (SEM 3) MAY 2008 : Relational Database Management Systems - Relational Database Management Systems - I

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 [A0514] (Please fill this Paper ID in OMR Sheet) MCA (304) (S05) (O) (Sem. - 3rd) RELATIONAL DATABASE MANAGEMENT SYSTEM - I Time : 03 Hours Maximum Marks : 75 Instruction to Candidates: 1) Section - A is Compulsory. 2) Attempt any Nine questions from Section - B. Section - A Q1) (15 x 2 = 30) a) What is the difference between simple and composite attributes? b) Explain the difference between a weak entity and a strong entity. c) What is the difference between total and partial generalization? d) What is the significance of an E-R diagram? e) What is an object oriented database? f) What do you mean by atomic domain? g) What is multivalued dependency? h) What is relational algebra? i) What are non-procedural languages? j) What is a tuple variable? k) What is a foreign key? l) What are log records? m) What do understand by a heterogeneous distributed database? n) What is data fragmentation? o) What is log-based recovery? D-396 P.T.O. Section - B (9 x 5 = 45) Q2) Explain the distinctions among the terms primary key, candidate key and superkey. Q3) Construct an ER diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. 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) Compare hierarchical, network and relational models. Q7) Explain why 4NF is a normal form more desirable than BCNF. Q8) Discuss the various operations that can performed in relational algebra. Q9) Why are certain functional dependencies called trivial functional dependencies? Q10) What benefit does strict two-phase locking provide? Q11) Discuss the relative advantages of centralized and distributed databases. Q12) Explain the difference between data replication in a distributed system and the maintenance of a remote backup site. Q13) Discuss various set operations that can be performed in SQL. RRR D-396 2

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

Additional Info : Mca - II (sem 3) May 2008 Question Paper - Relational Database Management Systems - I
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