ANU UG / Degree B.Sc 5th Sem Database Management System(DBMS) Imporant Questions

ANU B.Sc 5th Sem database management systems important questions for 5 units are available. You can get good marks by preparing these questions. The question papers consists of  8 questions and you need to answer any five questions. Each question carries 15 Marks. nagarjuna university B.Sc important questions for DBMS.

What are the expected Questions from each unit.

                  According to the model paper placed on the official nagarjuna university website, you can get single question from each unit compulsory. But as per our expectations the following choice is followed.

UNIT-I ------- 2 Question

UNIT-II ----- 2 Question

UNIT-III ----- 1 Questions

UNIT-IV ---- 1 Questions

UNIT-V ----  2 Question

You Might Also Like:  ANU B.Sc 5th Sem Model questions papers for all subjects click here

UNIT-I ( Overview of Database Management Systems)

1. What is DBMS? Write the Evaluation and Objects of DBMS.
2. Explain classification of Database Management Systems.
3. Write about a) Database b) Database Management systems.
4. What is File Base system? What are its drawbacks? Explain.
5. Explain advantages and disadvantages of Database Management system.
6. Explain Levels of abstraction (ANSI / SPARK Model).
   
7. What is data Model? Explain different types of data model in detail.
8. Explain different types of database architecture.
   
9. What are the various components of Database system? Explain.
10. Explain about a) Situation where DBMS is not necessary b) DBMS vendors and Their Products.
    

UNIT-III ( Entity Relationship Model)

1. What is ER-Modeling? Explain basic building block of ER-Modeling.
2. What is ER-Modeling? Write advantages and disadvantages of ER-Modeling.
   
3. Explain different types of entity sets and attributes in ER-Modeling.
4. What is relationship? Explain about relation ship degree and types of relations.
5. Explain procedure of reducing ER diagram to tables.
6. Explain IS A relationship, attribute inheritance and multiple inheritance.
   
7. What is EER Model? Explain generalization and specialization.
8. What is EER Model? Explain aggregation and composition.

 UNIT-IV (Relational Model)

1. what is relational model? Write about key features of relational model.
2. Explain about E.F.Codd's Relational database rules.
3. What is Key? Explain about various types of keys.
4. Explain different integrity constraints.
5. Explain various relational algebra operations.
6. Explain tuple relational calculus and domain relational calculus.
   

UNIT-IV ( Structured Query Language)

1. What is SQL? Explain different types of commands and data types in SQL
2. Explain different DDL and DML commands in SQL with syntax and examples.
3. Explain selection and projection operations with examples.
4. What are different aggregate functions in SQL? Explain with syntax and examples.
5. Explain about table modification and truncation commands in SQL.
6. What is constraint? Explain different types of constraints specified in SQL Queries.
7. Explain different types of Join and set operators in SQL.
8. What is View / Virtual table? Explain various view operations? Also mention advantages and disadvantages of it.
9. Write about a) Embedded Query b) Sub query.   

UNIT-V ( Procedural / Structured Query Language)

1. Explain the basic structure of PL/SQL Program and Write steps to create PL/SQL Program.
   
2. Explain various types of data types  and operators precedence in PL/SQL.
3. Explain various control structures in PL/SQL.
4. What are cursors and Functions? How to create them? Explain.
5. Explain procedure and Packages.
   
6. Explain exception haling mechanism in PL/SQL.
7. What is trigger? Explain different types of triggers in PL/SQL.