ANU UG/Degree B.Com(Computers) 4th Sem Database Management System(DBMS) Important Questions

ANU UG/Degree B.Com(Computers) 4th 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 & II( 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 the objectives of DBMS? Explain.
5. Explain the evaluation of DBMS.
6. Write about DBMS vendors and their products.
   

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-III( 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.
8. Explain aggregation and composition.
   

.Long Answer Questions.

1.  Explain basic building blocks of ER modeling.
   
2. Explain CODD Rules for relational model.
3.  Explain concept of key / different types of keys in Relational model.

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.
6. How to impose SQL constraints? Explain with examples.
   

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. 
4. Write about exception handling in PL/SQL.
   

 Prepared By

Name: D.Venkata Reddy, 

Qualification: M.Tech(Ph.D), UGC NET, AP SET Qualified 

Teaching Experience: 10 Years