Scribd Logo
Upload

Welcome to Scribd!

  • 39 views

    Bca 6 Sem Advance Dbms S 2019

    Uploaded by

    Gaurav Dharamkar
    The document is an exam for an Advanced Database Management Systems course. It contains 10 questions covering topics like database normalization, query tuning, database benchmarking, crash recovery, concurrency control, parallel databases, distributed query processing, object-oriented databases, data warehousing, and metadata management. Students are required to answer 6 questions out of the 10 in detail within the allotted 3 hours.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Bca 6 Sem Advance Dbms S 2019

    Uploaded by

    Gaurav Dharamkar
    39 views2 pages
    The document is an exam for an Advanced Database Management Systems course. It contains 10 questions covering topics like database normalization, query tuning, database benchmarking, crash recovery, concurrency control, parallel databases, distributed query processing, object-oriented databases, data warehousing, and metadata management. Students are required to answer 6 questions out of the 10 in detail within the allotted 3 hours.

    Original Title

    bca-6-sem-advance-dbms-s-2019

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is an exam for an Advanced Database Management Systems course. It contains 10 questions covering topics like database normalization, query tuning, database benchmarking, crash recovery, concurrency control, parallel databases, distributed query processing, object-oriented databases, data warehousing, and metadata management. Students are required to answer 6 questions out of the 10 in detail within the allotted 3 hours.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    39 views2 pages

    Bca 6 Sem Advance Dbms S 2019

    Uploaded by

    Gaurav Dharamkar
    The document is an exam for an Advanced Database Management Systems course. It contains 10 questions covering topics like database normalization, query tuning, database benchmarking, crash recovery, concurrency control, parallel databases, distributed query processing, object-oriented databases, data warehousing, and metadata management. Students are required to answer 6 questions out of the 10 in detail within the allotted 3 hours.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    AW-t 8t 9

    B.C.A. (Part-IIf Semester-Vl Exsmination


    .AJVANCf,, DATABASE MAn-AGEI\{ENT SYSTEM
    Paper--6ST5
    Time : Tfuee Hoursl [Moximum h4arks : 50

    Note :- (1) All questions are compulsory.


    (2) All qucslions carry cqual marks.
    (3) Assume suilable data whcrever necessan.
    1. (a) Explain the conccpt ofNomalization with its different t)?es in detail. 6

    @) Explain choices in tuning queries and views. 6


    OR
    2. (a) Explain thc DBMS bench marking in detail. 6
    (b) What is the need ofdatabase tuning ? Explain. 6
    3. (a) U.hat are the different specializcd locking lechniqucs ? Explain in detail. 6
    (b) Explain the concept ofcrash Recovery. 6
    OR
    4. (a) Explain Rccovering from a Syslem Crash. 6
    (b) What do you mean by concurrcncv control transaction '1 Explain its scheduling
    tecluiques. 6
    5. (a) Explain the architectuc for parallel databases. 6

    @) Explah the following : -


    (i) Dimibuted Query processing
    (ii) Catalog managcment. 6

    OR
    6. (a) Explain thc concept ofpara.llcl query e\.aluation. 6
    (b) Explain distributed concurency conroluith suitablc examplc. 6
    7. (a) Explain thc storage and access methods ofORDBMS. 6
    (b) Explaia:
    (i) Objects
    (ii) Inhedtance. 6
    OR
    8. (a) Explain the database design for ORDBMS. 6
    (b) Explain query processing and optimizalion. 6

    9. (a) Explain DSS and OLIP of data warehousing. 6


    (b) What is data mining ? Explain. 6

    OR
    10. (a) Explain Metadau Managcment in Data warchouse. 6
    (b) Explain OLAP and Dala warehousjng environment. 6

    \tsc 15383 175

    You might also like