Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    O Ut Pplica Ion BC Emester AG MEN S P: Exam. Code 107203 Subject Code: 1790

    Uploaded by

    RAJESH
    This document is an exam paper for the subject Database Management System for the Bachelor of Computer Application third semester. It contains 8 questions divided into 4 parts (A, B, C and D). The questions cover topics like database architecture, ER model, normalization, database recovery, concurrency control, SQL queries, triggers, big data applications and technologies like NoSQL and data analytics. Students have to attempt 5 questions selecting at least one from each part, with the fifth question coming from any part. They are given 3 hours to complete the paper which is worth a total of 75 marks.

    Copyright:

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

    O Ut Pplica Ion BC Emester AG MEN S P: Exam. Code 107203 Subject Code: 1790

    Uploaded by

    RAJESH
    42 views2 pages
    This document is an exam paper for the subject Database Management System for the Bachelor of Computer Application third semester. It contains 8 questions divided into 4 parts (A, B, C and D). The questions cover topics like database architecture, ER model, normalization, database recovery, concurrency control, SQL queries, triggers, big data applications and technologies like NoSQL and data analytics. Students have to attempt 5 questions selecting at least one from each part, with the fifth question coming from any part. They are given 3 hours to complete the paper which is worth a total of 75 marks.

    Original Title

    dmso_bca_3rd sem_2019

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document is an exam paper for the subject Database Management System for the Bachelor of Computer Application third semester. It contains 8 questions divided into 4 parts (A, B, C and D). The questions cover topics like database architecture, ER model, normalization, database recovery, concurrency control, SQL queries, triggers, big data applications and technologies like NoSQL and data analytics. Students have to attempt 5 questions selecting at least one from each part, with the fifth question coming from any part. They are given 3 hours to complete the paper which is worth a total of 75 marks.

    Copyright:

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

    O Ut Pplica Ion BC Emester AG MEN S P: Exam. Code 107203 Subject Code: 1790

    Uploaded by

    RAJESH
    This document is an exam paper for the subject Database Management System for the Bachelor of Computer Application third semester. It contains 8 questions divided into 4 parts (A, B, C and D). The questions cover topics like database architecture, ER model, normalization, database recovery, concurrency control, SQL queries, triggers, big data applications and technologies like NoSQL and data analytics. Students have to attempt 5 questions selecting at least one from each part, with the fifth question coming from any part. They are given 3 hours to complete the paper which is worth a total of 75 marks.

    Copyright:

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

    a2zpapers.

    com
    Exam. Code 107203
    Subject Code: 1790

    Bachelor of Computer Application (BCA)


    3rd Semester
    www.a2zpapers.com

    DATABASE MANAGEMENT SYSTEM


    Paper-II
    Time Allowed-3 Hours] [Maximum Marks-75
    Note :- Attempt five questions, selecting at least one
    question from each Part. The fifth question may
    be attempted from any part.
    PART-A
    1. (a) List five responsibilities of the database manager
    for each responsibility, explain the problems that
    would arise if the responsibility were not
    discharged. 8
    (b) Compare the features of Network, Hierarchical
    and Relational model. 7
    2. (a) Discuss the three level architecture of database
    management system. Explain the various types
    of different levels of database architecture,
    Explain. 8
    (b) Discuss about the components of ER Model. Give
    an example. 7
    PART-B
    3. (a) What is Normalization? Explain the various types
    of normal forms with example. 8
    (b) What do you mean by recovery of database ?
    Discuss the various mechanisms used for the
    recovery of database. 7
    545(2119)IHH-12 I 81 I (Contd.)

    www.a2zpapers.com www.a2zpapers.com
    oad free old Question papers gndu, ptu hp board, punjab
    a2zpapers.com
    4. (a) What are vanous methods of concurrency
    control ? Explain in detail two phase locking
    protocol. 8
    (b) Explain the five main responsibilities of database
    www.a2zpapers.com

    administrator. 7

    PART-C
    5. (a) Discuss the use of selection and join operators
    on SQL based queries. 8
    (b) What are triggers ? Also explain the use of triggers
    in database. 7
    6. (a) How would you use the features of nested queries
    in SQL to develop complex queries ? Give
    examples. 8
    (b) Write short notes on the following terms :
    (i) DDL
    (ii) DeL. 7
    PART-D
    7. (a) What is Big Data? List down various applications
    of Big Data. 8
    (b) Explain the five V's of Big Data. 7
    8. Write detailed notes on the following :
    (a) No SQL
    (b) Data Analytics. 15

    545(2119)1HH-12181 2 6000

    www.a2zpapers.com www.a2zpapers.com
    oad free old Question papers gndu, ptu hp board, punjab

    You might also like