ANU UG/Degree B.Sc 3rd Sem Database Management System(DBMS) Important Questions

 ANU UG/Degree B.Sc 3rd Sem Database Management System(DBMS) Important Questions are now available. Here you can get all degree important questions for all subjects. We are providing important question and guess papers for your exams since last 6 Years. Our expert designed these questions such that you can get maximum marks in you external exams.

UNIT-I( Overview of DBMS)

Short Answer Questions

1. Explain file based system and its disadvantages.
2. Explain the classification of database management systems.
3. Explain the three schema architecture for database.
4. What are cost and risks of database approaches.

Long Answer Questions.

1. Explain advantages and  disadvantages of database management system.
2. What is data model? Explain different types of data models.
3. Write about different components of DBMS with neat diagram.

UNIT-II( ER & EER Modeling)

Short Answer Questions

1. Explain different types of entities  
2. Explain different types of attributes
3. Explain different types of relationships 
4. What are advantages of ER Modeling.
5. Write about supertype and subtypes.
6. Write about generalization and specialization.
7. Write about IS-A relationship and attribute inheritance.

.Long Answer Questions.

1.  Explain basic building blocks of ER modeling.
   
2. Write the procedure / steps for converting ER diagram to relations with examples. 
3. What are different types of constraints that are possible on generalization and specialization.

UNIT-III( Relational Model).

 Short Answer Questions

1. Explain CODD Rules for relational model.
2. Explain concept of key / different types of keys in Relational model.
3. Write note on integrity constraints.
4. Write advantages and limitations of relational algebra.
5. What is normalization? What are the advantages of normalized relations over un-normalized relations? 
6. What is functional dependency? Write inference rules.
7. What is multi valued dependency? How to remove it?
8. Difference between TRC and DRC.

.Long Answer Questions.

1. With suitable examples explain all relational  set operations.
2. With an example explain TRC and DRC.
3. What is normalization? Write  the steps of normalization.
4. Explain different types of normal forms.

UNIT-IV(SQL) 

 Short Answer Questions

1. Write about history of SQL.
2. Explain different data types in SQL.
3. Explain selection and projection operation in SQL.
4. Explain different aggregate functions in SQL.
5. Write about table modification commands.
   
6. Write about sub query with examples. 

.Long Answer Questions.

1. Explain different types of SQL commands.
2. Write about DDL and DML statements.
3. Explain different set operations in SQL.
4. Explain different types of SQL joins.
5. What is View? Explain the process of creating different types of views.

UNIT-V(PL/SQL)

 Short Answer Questions

1. Write different features of PL/SQL.
2. Explain the structure of PL/SQL block.
3. Explain data types and operators precedence.
4. Write the steps to create a PL/SQL program.
5. Differences between functions and procedures.

 Long Answer Questions.

1. Explain different types of iterative controls in PL/SQL.
2. What is trigger? What three parts of trigger? Explain different types of triggers.
3. How to create and run triggers in PL/SQL? Explain with example program.