and 5 others joined a min ago.
0
1.7kviews
Advanced Data Management Technology Question Paper - Jun 19 - Information Technology (Semester 5) - Mumbai University (MU)
1 Answer
0
16views
written 4.9 years ago by
teamques10
★ 64k
|
Advanced Data Management Technology - Jun 19
Information Technology (Semester 5)
Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.
Attempt any four:
1.a.
Write short note on "Query Evaluation Plan"
(5 marks)
00
1.b.
Justify the statement "Collection of operations that form a single logical unit of work are called Transactions."
(5 marks)
00
1.c.
List and explain the commonly accepted security goals for databases.
(5 marks)
00
1.d.
List and Distribution Design Issues and explain any one in detail.
(5 marks)
00
1.e.
List and explain basic tasks involved in Data Transformation.
(5 marks)
00
2.a.
Show that the two-phase locking protocol ensures conflict serializability, and that transactions can be serialized according to their lock points.
(10 marks)
00
2.b.
Explain generic layering scheme for Distributed Query Processing.
(10 marks)
00
3.a.
Explain Temporal databases with suitable example.
(10 marks)
00
3.b.
List and explain any four OLAP Operations in a cube with suitable example.
(10 marks)
00
4.a.
What is the general purpose of the Data-warehouse architecture? Explain the architectural components of Data-warehouse with suitable diagram.
(10 marks)
00
4.b.
List various fragmentation strategies in distributed database and explain any one in detail.
(10 marks)
00
5.a.
List and explain the types of activities and tasks that compose the ETL process.
(10 marks)
00
5.b.
Explain ARIES Algorithm in detail.
(10 marks)
00
6.a.
Measures of Query cost.
(5 marks)
00
6.b.
Shadow Paging.
(5 marks)
00
6.c.
Mobile Databases.
(5 marks)
00
6.d.
Factless Fact Tablel
(5 marks)
00
ADD COMMENT
EDIT
Please log in to add an answer.