This download link is referred from the post: SGBAU BCA Last 10 Years 2010-2020 Question Papers || Sant Gadge Baba Amravati university
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.
- (A) Explain the architecture of Database Management System. 6
(B) Explain:--- Content provided by FirstRanker.com ---
(i) Data Abstraction
(ii) Data Integration. 6
OR - (A) What is DBMS ? Explain the component DBMS.
(B) What is Data Independence ? Explain physical and logical data independence. 6 - (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 - (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 - (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 - (A) What is DML ? Explain different types of DML commands. 6
(B) What is View ? Explain how View can be created and dropped. 6 - (A) What is Join ? Explain types of Joins. 6
(B) Explain Group functions with example. 6--- Content provided by FirstRanker.com ---
OR - (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 - (A) Explain different data types of PL/SQL.
(B) What is Cursor ? Explain cursor declaration, cursor opening and cursor fetching. 8
OR - (A) Explain PL/SQL Block with all sections.
(B) Explain While Loop in PL/SQL with example.
--- Content provided by FirstRanker.com ---
--- Content provided by 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