Page 1 :
111111001111111, 1111111111111111111111, , QP CODE: 21002285, , 21002285, , Reg No, Name, , '2.9..9.Q1\.0 '.2.t\-'3,~ S, , .R Ae.EPA: . '? .Vi., , M Sc DEGREE (CSS) EXAMINATION, NOVEMBER 2021, First Semester, M.Sc.Data Analytics, , CORE - ST050104 - DATA BASE TECHNOLOGY, 2019 ADM ISSION ONWARDS, C2CA2073, Time: 3 Hours, , Weightage : 30, Part A (Short Answer Question s), Ans we, any eigllt questions., Weight 1 eac/J., , 1. Define Data Models . Give some examples ., , ¥', , Explain DDL and DML?, What are the states a tra nsaction can achieve?, , ¥, , K, , Explain Two-Phase Locking protocol., What is a wait-for grapl1? Demonstrate its use., Explain the concept of inherintance., , 7. What are the drawbacks of OTO?, ~What are data warehouse s?, 9. Explain dual levels of granularity., 10. What is OLAP and OLAP cube? Explain with example., {8 l< 1=8 we1gtHageJ, , Pa rt B {Short Essa y/Problems), Answer any six questioos, Weigtl/ 2 eac/1., , ~efine Keys. Explain the different types., \, , \, , »., , Explain Domai n Relational Calcul11s., , ,1 3. Explain assenian and triggers?, , 14 . Elborate the pitfalls in the design of r1atallase, , lllil~l[tlllll Ill, , P ogc 112, , Turn Over, , 112

Page 2 :
lllllilhi~l.111111, How is a file organized sequentially?, What is View Serializability? How can it be achieved?, 17. What are the ru les followed in a distributed database?, Explain Multidimensional models and distinguish between dimension tables and fact tables ., (6•2= 12 weighlage), , Part C (Ess ay Type Questions), Answer any two questions., Weight 5 each., , 19. What are the advantages of database processing?, , _;,:er., , P,, , Write an essay on E-R Diagrams., Write a note on MongoDB., , 22. Explain about Data Wareh ouse life cycle., (2•5=10 welghtage), , 111111111111111, , Pngo 212, 2/2