FirstRanker.com
A Firstranker's choice
Time : Three Hours] [Maximum Marks : 60
--- Content provided by FirstRanker.com ---
B.C.A. (Part—III) Semester—VI Examination
ADVANCE DATABASE MANAGEMENT SYSTEM
Paper—6ST5
Note :— (1) All questions are compulsory.
(2) All questions carry equal marks.
--- Content provided by FirstRanker.com ---
(3) Assume suitable data wherever necessary.- (a) Explain the concept of Normalization with its different types in detail.
(b) Explain choices in tuning queries and views. - (a) Explain the DBMS bench marking in detail.
(b) What is the need of database tuning ? Explain. - (a) What are the different specialized locking techniques ? Explain in detail.
(b) Explain the concept of Crash Recovery. - (a) Explain Recovering from a System Crash.
(b) What do you mean by concurrency control transaction ? Explain its scheduling techniques. - (a) Explain the architecture for parallel databases.
--- Content provided by FirstRanker.com ---
(b) Explain the following :—
(i) Distributed Query processing
(ii) Catalog management. - (a) Explain the concept of parallel query evaluation.
(b) Explain distributed concurrency control with suitable example. - (a) Explain the storage and access methods of ORDBMS.
(b) Explain :
(i) Objects
(ii) Inheritance. - (a) Explain the database design for ORDBMS.
--- Content provided by FirstRanker.com ---
(b) Explain query processing and optimization. - (a) Explain DSS and OLTP of data warehousing.
(b) What is data mining ? Explain. - (a) Explain Metadata Management in Data warehouse.
(b) Explain OLLAP and Data warehousing environment.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
YBC - 15383
FirstRanker.com Firstranker's choice FirstRanker.com
--- Content provided by FirstRanker.com ---
This download link is referred from the post: SGBAU BCA Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university