munotes®

Engineering BE Information Technology Sem 5 December 2018 2018 Advanced Data Management Technology Question Paper - Mumbai University | munotes

December 2018 Question Paper.pdf
INFT · 1 May 2025

Loading PDF...

Questions asked in this paper

  1. Q1 a) Explain Brute-Force Nested Loop Join algorithm. 5 marks
    • b) is dead lock, explain wait and die scheme used for deadlock prevention. 5
    • c) What is Temporal Database? What are its characteristics? 5
    • d) Explain roll-up, drill down, slice, dice operations in OLAP. 5 Explain basic time stamp ordering protocol and compare it with 2 phase locking protocol in terms of deadlock and rollbacks. 10
    • b) Explain Mandatory Access Control and Discretionary Access Control, also explain access control list and access control entry w.r.t. the same. 10
    • a) Why fragmentation is required in distributed data bases, Explain Vertical fragmentation with example, comment on completeness , reconstruction and disjointness aspect of it. 10
    • b) Explain 2 Phase commit protocol with proper flow diagram. 10
    • b) is the significance of serializability, explain conflict serializability and view serializability with the help of example. 10
    • a) Explain types of data extraction methods in ETL process 10 What is basic difference between pessimistic and optimistic concurrency control algorithm. Explain distributed 2PL algorithm. 10
  2. Q6 Write short notes on (any two) 20 marks
    • b. Query Optimization
    • d. Challenges in ETL functions

Read from the scan above, so a character or two may differ. The scan is the original.

Report an error

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Connected Papers
Engineering / INFT · 241 papers
Browse all →
2023 - INFT3Principle Of Communication 2023 - INFT3 Engineering Mathematics 2023 - INFTDSE3Principle Of Communication 2023 - DSE INFT3 Data Structure And Analysis 2023 - INFT3 Data Structure And Analysis 2023 - INFT3 Database Management System 2023 - INFTDSE3Database Management System 2023 - INFT DSE3Engineering Mathematics III 2023 - DSE INFT3Paradigms And Computer Programming Foundation 2023 - INFT3Paradigms And Computer Programming Foundation 2022 - Principle Of Communication 2022 - Paradigma And Computer Programming Foundation 2022 - Data Structure And Analysis 2022 - Database Management System 2022 - Principle Of CommunicationDSE 2022 - INFT Enginering Mathematics IIIDSC 2022 - Data Structure AnalysisDSE 2022 - Paradigms Computer Programming FoundationDSE 2022 - Database Management System 2019 - Analog And Digital Circuits 2019 - Applied Mathematics III INFT 2019 - Applied Mathematics III 2019 - Applied Mathematics III 2019 - Applied MathematicsIII 2019 - Data Structure And Algorithm Analysis 2019 - Data Structure And Algorithm Analysis 2019 - Data Structures And Analysis 2019 - Data Structures And Analysis 2019 - Database Management System 2019 - Database Management Systems 2019 - Database Management Systems 2019 - Logic Design 2019 - Logic Design 2019 - Object Orientaed Programming Methodology Inft 2019 - Principes Of Analog And Digital Communication 2019 - Principes Of Analog Digital Communication 2019 - Principle Of Communications 2018 - Analog And Digital Circuits 2018 - Applied Mathematics III ItCBSGS 2018 - Applied Mathematics III 2018 - Data Base Management Systems 2018 - Data Structure And Algorithm Analysis 2018 - Database Management System 2018 - Logic Design 2018 - Principal Of Communications 2018 - Principes Of Analog And Digital Communication
2023 - INFT4Computer Network And Network Design 2023 - INFT4Engineerig Mathematics IV 2023 - INFT Operating System 2023 - INFT SEM4Automata Theory 2023 - INFT4Wireless Technology 2023 - INFT4 Computer Organization And Architecture 2022 - Computer Network And Network Desing 2022 - INFTAutomata Theory 2022 - Operating System 2022 - INFT Computer Organization And Architecture 2022 - Engineering Mathematics IV 2022 - Computer Network And Nstwork Design 2022 - Automata Theory 2022 - Operating System 2022 - Computer Organization And Architecture 2022 - SE CMPN INFT Engineering Mathematics IV 1 2019 - Applied Mathematics IV 2019 - Applied Mathematics IV inftCBSGS 2019 - Applied Mathematics IV 2019 - Applied Mathematics IV New IT 2019 - Applied Mathematics IV 2019 - Applied Physics I 2019 - Automata Theory 2019 - Automata Theory 2019 - Automata Theory 2019 - Automata Theory 2019 - Computer Networks 2019 - Computer Networks 2019 - Computer Networks 2019 - Computer Networks 2019 - Computer Organization And Architecture 2019 - Computer Organization And Architecture 2019 - Computer Organization And Architecture 2019 - Computer Organization And Architecture 2019 - Information Theory And Coding 2019 - Operating Systems 2019 - Web Programming 2019 - Web Programming 2018 - Applied Mathematics inftCBSGS 2018 - Applied Mathematucs 2018 - Automata Theory 2018 - Automata Theory 2018 - Computer Networks 2018 - Computer Networks 2018 - Computer Organization And Architecture 2018 - Computer Organization And Architecture 2018 - Information Theory And Coding 2018 - Operating Systems
2023 - INFT5 Computer Network Security 2023 - INFT5 Internet Programming 2023 - INFT5 Advanced Data Structure And Analysis 2023 - INFT5software Engineering 2023 - NFT5Data Mining And Business Intelligence 2023 - INFT5MATHS FOR DS 2023 - INFT5 Entrepreneurship And E Business 2022 - Advanced Data Structure And Analysis 2022 - Computer Network Security 2022 - Advance Data Technologies 2022 - Internet Programming 2022 - Software Engineering 2022 - Entrepreneurship And E Business 2019 - Advance Data Structures And Analysis Of Algorithms 2019 - Advance Data Structures And Analysis Of Algorithms Elective IChoice Base 2019 - Advanced Data Management Technology 2019 - Advanced Data Management Technology 2019 - Advanced Database Management Systems 2019 - Advanced Database Management Systems 2019 - Computer Graphics And Virtual Reality 2019 - Computer Graphics And Virtual Reality 2019 - Crptography And Network Security 2019 - Cryptography And Network Security 2019 - E Commerce And E Business 2019 - E Commerce And E Business Elective IChoice Base 2019 - Engineering Electromagnetics 2019 - Internet Programming 2019 - Microcontroller And Embeded Programming 2019 - Microcontroller And Enbeded Systems 2019 - Microconyroller And Embeded Systems 2019 - Open Source Technologies 2019 - Open Source Technologies 2019 - Operating Systems 2019 - Operating Systems 2018 - Advance Data Structures And AnalysisElective I 2018 - Advanced Data Management Technology Open 2018 - Advanced Database Management Systems 2018 - Computer Graphics And Virtual Reality 2018 - Cryptography And Network Security 2018 - E Comerce And E BusinessDLOCElective I 2018 - Internet Programming 2018 - Microcontroller And Embeded Systems 2018 - Microcontroller And Embeded Systems 2018 - Open Source Technologies 2018 - Operating Systems
Questions? Email contact@munotes.in
Done!
Done!