B.Sc. Honours Information Technology Major — Semester II
Database Management Systems
Course 4 · Model Question Paper
SECTION — A
Answer any FIVE of the following
5 × 4 marks = 20 marks
- Describe the drawbacks of file-based system.
- Write the advantages of database approach.
- Explain the advantages of ER modeling.
- Write about Relational Data Model.
- Explain the data types in SQL.
- Explain aggregate function in SQL.
- Explain PL/SQL Data Types.
- What is a variable? How to declare a variable in PL/SQL.
SECTION — B
Answer any FIVE of the following
5 × 10 marks = 50 marks
UNIT I
9. (a) Define Database Management System. Explain various Data Models.
OR
9. (b) Explain three schema architecture of database.
UNIT II
10. (a) Explain the building blocks of entity relationship diagram with example.
OR
10. (b) What is relationship degree? Explain different types of relationships.
UNIT III
11. (a) Explain CODD Rules.
OR
11. (b) Explain various Normal Forms with examples.
UNIT IV
12. (a) Explain Data Manipulation Language Commands with examples.
OR
12. (b) Explain Data Definition Language Commands with examples.
UNIT V
13. (a) Explain the Structure of PL/SQL Program with example.
OR
13. (b) Explain Iterative Control Statements with examples.
మా వాట్సాప్ ఛానెల్లో జాయిన్ అవ్వండి
AP ప్రభుత్వ పథకాలు & జాబ్ అప్డేట్స్ కోసం జాయిన్ అవ్వండి!
Join WhatsApp Channel
