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

Download SGBAU (Sant Gadge Baba Amravati university) BCA 2019 Summer (Bachelor of Computer Applications) 6th Sem Advance DBMS Previous Question Paper

AW?1819
B.C.A. (Part?III) Semester?VI Examination
ADVANCE DATABASE MANAGEMENT SYSTEM
Paper?6ST5
Time 2 ThIce Hours] [Maximum Marks : 60
Note :? (1) All questions are compulsory.
(2) All questions carry equal marks.
(3) Assume suitable data wherever necessary.
1. (a) Explain the concept of Normalization with its different types in detail. 6
(b) Explain choices in tuning queries and views.
OR
2. (a) Explain the DBMS bench marking in detail. 6
(b) What is the need of database tuning ? Explain. 6
3. (a) What are the different specialized locking techniques ? Explain in detail. 6
(b) Explain the concept of Crash Recovery. 6
0R
4. (3) Explain Recovering from a System Crash. 6
(b) What do you mean by concurrency control transaction ?.? Explain its scheduling
techniques. 6
5. (a) Explain the architecture for parallel databases. 6
(b) Explain the following :7 ?
(i) Distributed Query processing
(ii) Catalog management. 6
0R
6. (:1) Explain the concept of parallel query evaluation.
(b) Explain distributed concurrency control with suitable example. 6
7. (a) Explain the storage and access methods of 0RDBMS.
(b) Explain :
(i) Objects
(ii) Inheritance. 6
OR
8. (a) Explain the database design for ORDBMS.
(b) Explain query processing and 6ptimization.
9. (3) Explain D88 and OLTP of data warehousing.
(b) What is data mining ? Explain.
O\O\O\O\
OR
10. (a) Explain Metadata Management in Data warehouse.
O?xO?~
(b) Explain OLAP and Data warehousing environment.
YBC 15383 175