FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

Download SGBAU BCA 2019 Summer 3rd Sem DBMS Question Paper

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

This post was last modified on 10 February 2020

This download link is referred from the post: SGBAU BCA Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university


FirstRanker.com

B.C.A. (Part—II) Semester—III Examination

3ST3 : DATA BASE MANAGEMENT SYSTEM

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

Time : Three Hours | [Maximum Marks : 60

Note :— (1) All questions are compulsory.

(2) Assume suitable data wherever necessary.

  1. (A) Explain the architecture of Database Management System. 6
    (B) Explain:

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

    (i) Data Abstraction
    (ii) Data Integration. 6
    OR
  2. (A) What is DBMS ? Explain the component DBMS.
    (B) What is Data Independence ? Explain physical and logical data independence. 6
  3. --- Content provided by FirstRanker.com ---

  4. (A) What is attributes ? Explain types of attribute with suitable example. 6
    (B) What is normalization ? Explain 1 NF, 2 NF, 3 NF with example. 6
    OR
  5. (A) Explain the reduction of ER diagram to table. 6
    (B) Explain the following terms :

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

    (i) Primary key
    (ii) Candidate key
    (iii) Foreign key. 6
  6. (A) Explain different data types in SQL. 6
    (B) What is Operator ? Explain EXISTS and LIKE operator with suitable example. 6

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

    OR
  7. (A) What is DML ? Explain different types of DML commands. 6
    (B) What is View ? Explain how View can be created and dropped. 6
  8. (A) What is Join ? Explain types of Joins. 6
    (B) Explain Group functions with example. 6

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

    OR
  9. (A) Explain self join with example. 6
    (B) Explain set operations :
    (i) Union
    (ii) Cross Product

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

    (iii) Difference
    (iv) Intersection. 6
  10. (A) Explain different data types of PL/SQL.
    (B) What is Cursor ? Explain cursor declaration, cursor opening and cursor fetching. 8
    OR
  11. --- Content provided by FirstRanker.com ---

  12. (A) Explain PL/SQL Block with all sections.
    (B) Explain While Loop in PL/SQL with example.

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