FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download Mumbai University (MU) MCA 2019 May 4th Sem 55005 Advance Database Techniques Question Paper

Download MU-(University of Mumbai or University of Bombay) MCA (Master of Computer Application) 2019 May 4th Sem 55005 Advance Database Techniques Previous Question Paper

This post was last modified on 05 February 2020

MU-Mumbai University MCA Last 10 Years 2010-2020 Question Papers || University of Mumbai


I Fl rstRankamm 55005 / Advance Database Techniques

Firstranker's choice

FirstRanker.com

--- Content provided by FirstRanker.com ---

(3 Hours) [Total Marks: 100]

Note: 1) Question No. 1 is compulsory

2) Attempt any four questions from the remaining six questions.

Q1. Write short note on the following (attempt any Four) (20)

  1. Parallel data base architectures
  2. --- Content provided by‌ FirstRanker.com ---

  3. K-means Clustering
  4. Search engines
  5. Neural networks
  6. ORDBMS

Q2. What are multidimensional cubes? Explain how the Pivot and Slice-dice operations are performed. (10)

--- Content provided by‌ FirstRanker.com ---

Q3. Describe Naive bays classification in detail with suitable example. (10)

Q4. Discuss how the scanning, sorting and join operations can be parallelized using data partition technique (10)

Q5. Explain Bell-LaPedula Model. (10)

Q6. Discuss Deadlock detection in distributed database. Explain dead lock preventive techniques with example. (10)

Q7. Explain the Architecture of data warehouse and explain detail. (10)

--- Content provided by FirstRanker.com ---

Q8. Explain ETL process in data warehousing in detail with suitable examples. (10)

Q9. Describe KDD Process in detail,with suitable examples. (10)

Q10. How recovery in a distributed DBMS is more complicated than in centralized system. Justify your answer. (10)

Q11. What is bloom join and semi join? Explain them in detail with example. (10)

Q12. Differentiate between the following: (20)

--- Content provided by⁠ FirstRanker.com ---

  1. Synchronous vs Asynchronous replication
  2. Star schema vs Snow flake schema
  3. OODBMS vs ORDBMS
  4. OLAP vs OLTP

FirstRanker.com

--- Content provided by‌ FirstRanker.com ---



This download link is referred from the post: MU-Mumbai University MCA Last 10 Years 2010-2020 Question Papers || University of Mumbai

--- Content provided by⁠ FirstRanker.com ---