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

Time : Three Hoursl
A?V?l 802
B.C.A. (Park II) Scmcstcr?III Examination
3813 : DATA BASE MANAGEMENT SYSTEM
Note :?(1) All questions are compulsory.
l. (A)
03)
2. (A)
03)
3. (A)
(B)
4. (A)
(B)
5. (A)
(B)
6. (A)
(B)
7. (A)
(B)
8. (A)
(B)
9. (A)
(B)
10. (A)
(B)
(2) Assume suitable data wherever necessary.
Explain the architecture ofDalabasc Management System.
Explain :
(i) Data Abstraction
(ii) Data Integration.
OR
What is DBMS ?? Explain the component DBMS.
What is Data Independence ? Explain physical and logical data independence.
What is auribures ? Explain types of attribute with suitable example.
What is normalization ? Explain 1 NF, 2 NF, 3 NF with example.
0R
Explain lhc reduction of ER diagram to table.
Explain the following terms :
(1) Primary key
(ii) Candidate key
(iii) Foreign key.
Explain different data types in SQL.
What is Operator ? Explain EXISTS and LIKE operator with suitable example.
OR
What is DML '? Explain different types ofDML commands.
What is View ? Explain how Vicw can be created and dropped.
What is Join ? Explain types of Joins.
Explain Group functions with example.
0R
Explain scit?join with example.
Explain sci operations :
(i) Union
(ii) Cross Product
(iii) Difference
(iv) Intersection.
Explain different data types of PUSQL.
What is C ursor ? Explain cursor declaration, cursor opening and cursor fetching.
OR
Explain l?L/SQL Block with all sections.
Explain While Loop in PL/SQL with example.
YBC?15366
[Maximum Marks : 60
6
6
6
6
71,5