Total No. of Questions—8] [Total No. of Printed Pages—3
Seat
No. [5361]-302
M.C.A. (Commerce) (III Semester) EXAMINATION, 2018
302 ADVANCED DATABASE MANAGEMENT SYSTEM
(2013 PATTERN)
Time Three Hours Maximum Marks 50
N.B. Attempt any 5 questions.
(ii Figures to the right indicate full marks.
1. Attempt the following
What is SOAP Explain.
Explain Round Robin Partitioning technique.
What is Query optimization.
2. Attempt the following
Explain Intra Query parallesim.
Explain Data Replication in Distributed data storage.
Define
Encapsulation
(ii Inheritance
3. Attempt the following
Explain two phase commit protocol.
[5361]-302 2
Explain decision Tree.
Define
Region Data
(ii Point Data
4. Attempt the following
Explain deadlock handling in DDBMS.
Explain client-server architecture.
Explain shared memory.
5. Attempt the following
Explain Data warehouse structure in detail.
Explain distributed catlog manager.
Define
Linear speed up
Linear scale up.
6. Attempt the following
Explain Apriori Algorithm.
Compare between Homogeneous and Heterogeneous system.
Define
Precision
(ii Recall
[5361]-302 3 P.T.O.
7. Attempt the following
What is XML Differentiate between HTML and XML.
Explain Majority Protocol.
8. Attempt All
Consider the following schema
Student sname, city, class)
Perform horizontal fragmentation of student relation using following
predicates.
P1 city 'Mumbai'
P2 city
P3 city
Perform vertical fragmentation of Drug relation given
below
Drug dname, type, company, price)
According to the following requirements
Site 1 requires information about dno, dname, type.
Site 2 requires information about company price.