Download SGBAU BCA 2019 Summer 3rd Sem DBMS Question Paper

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

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

3. (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
4. (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
5. (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
6. (A) What is DML ? Explain different types of DML commands. 6
   (B) What is View ? Explain how View can be created and dropped. 6
7. (A) What is Join ? Explain types of Joins. 6
   (B) Explain Group functions with example. 6
   

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

   OR
8. (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
9. (A) Explain different data types of PL/SQL.
   (B) What is Cursor ? Explain cursor declaration, cursor opening and cursor fetching. 8
   OR

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

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

FirstRanker.com