Download SGBAU BCA 2019 Summer 6th Sem Advance DBMS Question Paper

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 ---

1. (a) Explain the concept of Normalization with its different types in detail.
   (b) Explain choices in tuning queries and views.
2. (a) Explain the DBMS bench marking in detail.
   (b) What is the need of database tuning ? Explain.

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

3. (a) What are the different specialized locking techniques ? Explain in detail.
   (b) Explain the concept of Crash Recovery.
4. (a) Explain Recovering from a System Crash.
   (b) What do you mean by concurrency control transaction ? Explain its scheduling techniques.
5. (a) Explain the architecture for parallel databases.
   

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

   (b) Explain the following :—
   (i) Distributed Query processing
   (ii) Catalog management.
6. (a) Explain the concept of parallel query evaluation.
   (b) Explain distributed concurrency control with suitable example.

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

7. (a) Explain the storage and access methods of ORDBMS.
   (b) Explain :
   (i) Objects
   (ii) Inheritance.
8. (a) Explain the database design for ORDBMS.
   

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

   (b) Explain query processing and optimization.
9. (a) Explain DSS and OLTP of data warehousing.
   (b) What is data mining ? Explain.
10. (a) Explain Metadata Management in Data warehouse.
    (b) Explain OLLAP and Data warehousing environment.

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

YBC - 15383

FirstRanker.com

FirstRanker.com Firstranker's choice FirstRanker.com

FirstRanker.com

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