ANU UG / Degree B.Com (Res) 5th Semester DBMS Important Questions

ANU B.Com 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.Com 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 ------- 1 Question

UNIT-II ----- 2 Question

UNIT-III ----- 2 Questions

UNIT-IV ---- 1 Questions

UNIT-V ----  2 Question

You Might Also Like:  ANU B.Com 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.[Oct-19,17]
2. Explain classification of Database Management Systems.[Oct-18]
3. Write about a) Database b) Database Management systems.

UNIT-II

1. What is File Base system? What are its drawbacks? Explain.[Oct-17]
2. Explain advantages and disadvantages of Database Management system.
3. What is data Model? Explain different types of data model in detail.[Oct-19,17]
4. What are the various components of Database system? Explain.[Oct-19,18]

UNIT-III ( Entity Relationship Model)

1. What is ER-Modeling? Explain basic building block of ER-Modeling.[Oct-19,18,17]
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. What is EER Model? Explain generalization and specialization.
6. What is EER Model? Explain aggregation and composition.[Oct-19]
7. what is relational model? Write about key features of relational model.
8. Explain about E.F.Codd's Relational database rules.[Oct-18]
9. What is Key? Explain about various types of keys.[Oct-18]
10. Explain different integrity constraints.[Oct-19]

UNIT-IV ( Structured Query Language)

1. What is SQL? Explain different types of commands and data types in SQL.[Oct-17]
2. Explain different DDL and DML commands in SQL with syntax and examples.[Oct-19,17]
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.[Oct-18,17]
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. 
2. Explain various types of data types in PL/SQL.
3. Explain various control structures in PL/SQL.[Oct-17]
4. What are cursors and Functions? How to create them? Explain.[Oct-19,18]
5. Explain exception haling mechanism in PL/SQL.
6. What is trigger? Explain different types of triggers in PL/SQL.[Oct-19,17]