PTU Old Qestion Papers

Send video songs to your loved ones.

Custom Search

Cheapest and Best Web Solutions & Web Design
Make a presence of your business online with us

PTU Previous Question papers -MCA

MC 401 - RDBMS-II (2056)

Note: Section E is compulsory. Attempt any one Question from section A, B, C and D.


Section E (2 marks each)

Question 9 :
a.	What is a test plan? When is it prepared and what is its use?
b.	Which life cycle phase takes most of the time and which is the most important phase?
c.	What is serializability? What is its objective?
d.	What are the advantages of using centralized transaction processing systems?
e.	What do you mean by data allocation in distributed database design?
f.	Briefly discuss the hardware required for implementing client server architecture.
g.	What do you understand by three tired client server architecture? Explain with diagram.
h.	What are the key features of OLAP applications?
i.	What are the characteristics of data in a data warehouse/
j.	What is the objective of DSS?

Section A (10 marks each)
1.	What are the different approaches of database design? Explain each of them.
2.	Discuss the evaluation , operation and maintenance phases of DBLC.
Section B (10 marks each)
3.	What is two phase locking protocol? How does it guarantee serializability? Explain with example.
4.	(a) Differentiate between Homogenous and Heterogeneous DDBMS.
	(b) Discuss the advantages and disadvantages of using distributed databases.
Section C (10 marks each)
5.	Describe and explain in detail the Client Server architectural principles.
6.	Compare Client server verses traditional data processing systems. Support different facets of comparison with examples.
Section D (10 marks each)
7.	Explain the different components of DSS and how they interact to form a system.
8.	What is a data warehouse and what are its main characteristics? Discuss in detail with examples.