Trending ▼   ResFinder  

PUNJAB TECHNICAL UNIVERSITY MCA - II (SEM 3) SEP 2010 : 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) (LE) (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 2 = 30) a) Briefly explain the structure the distributed database. b) Write short note on the hierarchical model. c) Explain the main components of the E-R model. d) Compare OOD and ORD. e) Write down main objectives of DBMS. f) What do you mean by functional dependency? Discuss types. g) Explain the 3NF. h) Differentiate between Relational Algebra and Relational Calculus. i) Discuss the JOIN operation of relational algebra. j) What are the problems arising out of un-normalized data? k) Distinguish between DDL and DML. l) What is a foreign key? What is its role? m) How database recovery is done? n) o) A-532 What is database integrity? Discuss its rules. Explain client/server architecture. P.T.O. Section - B Q2) (9 5 = 45) What are the advantages and disadvantages of distributed DBMS? Q3) What do you mean by database independence? Discuss its types. Q4) Compare relational and Network model. Q5) Define DBMS. Explain its architecture. Q6) Explain the basic operations of Relational Algebra with examples. Q7) Define Normalization. Explain 1NF and 2NF. Q8) Explain the storage organizations for relational model. Q9) Write down main features of relational calculus. Q10) Explain the data manipulation operations of SQL with examples. Q11) What is security? How security is maintained? Explain. Q12) What are the problems arising out of concurrency? How concurrency is handled? Q13) Write down main features of Oracle. kbkb A-532 2

Formatting page ...

 

  Print intermediate debugging step

Show debugging info


 

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