ANU Database Management Systems ( 3rd B.Sc computers) Important Questions

Here are the ANU Database Management Systems ( 3rd B.Sc computers) Important Questions. All units question are available here and you can get prepare them.

UNIT-I

Chapter-I( Database Systems)

1. What are the advantages and functions of DBMS?
2. What are the main components of a database system?
3. What is file system? What are the major disadvantages of file system?

Chapter-II (Data Models)

1. What is Data Model? Explain different types of data models with examples.
2. Explain different levels of  Abstraction OR Explain three levels of DBMS architecture.
3. What is Business Rule? What is its purposing in data modeling? Write their characteristics.

Chapter-III( The Relational Database Model)

1. Write different advantages and disadvantages of Relational Database Model.
2. Explain different types of keys used in database models.
3. Explain relational set operators.
4. Write about Codd's Relational Database Rules.

UNIT-II

Chapter-I (Entity Relation Ship Model)

1. What is entity? Explain different types of entities.
2. What is attribute? Explain different types of attributes.
3. Explain ER-Model with the help of a suitable example.
4. Explain connectivity and cordiality with examples.
5. Explain Degree of relationship.

Chapter-II ( Advanced data modeling)

1. What is EER? Explain entity super type and sub type.
2. Discuss about constraints specified on super type and sub type relation ships.
3. What is attribute inheritance? Why is it important.
4.  What is surrogate key and when should you use one.

Chapter-III ( Normalization of Database Tables)

1. What is normalization? Discuss various steps in normalization with net sketch?
2. Explain basic normal forms with examples.
3. Explain advanced normal forms with examples.
4. Define and discuss about multi valued and transitive dependence with example.
5. What is anomaly? What are three types of anomalies caused by database.

UNIT-III

Chapter-I ( Introduction to SQL)

1. Explain various DDL and DML commands with examples in SQL
2. Define SQL? Write its features.
3. Discuss about different types of arithmetic functions in SQL
4. Discuss about different types of group functions in SQL
5. Discuss integrity constraints in SQL with suitable example?
6. Write about ORDER BY clause, GROUP BY clause and HAVING clause with examples.
7. Explain about BETWEEN, IS NULL, LIKE, IN, EXISTS Special operators used in SQL
8. What is an Index? Explain how to create an index in SQL.
9. What is view or Virtual Tables? Explain how to create a view in SQL.

Chapter-II

1. Explain SQL join operators with examples.
2. What is correlated sub-queries and sub-queries? Explain with an example.
3. What is function? Explain group functions( Aggregation) in SQL.
4. What are Triggers? How they are useful? Explain.
5. Differentiate Triggers with procedures.
6. Explain in detail about the stored procedures with examples 
7. Explain in detail about the cursors with examples
8. Write short note on embedded and dynamic SQL?

Chapter-III ( Database Design)

1. Discuss about system development life cycle (SDLC).
2. Explain in detail about the database life cycle (DLC).
3. Distinguish between centralized Vs. Decentralized Database Design
4. What are the factors influence DBMS software selections?

UNIT-IV 

Chapter-I ( Transaction Management and Concurrency control)

1. What is Transaction? Explain various states of Transaction?
2. Explain concurrency control with locking methods?
3. Explain concurrency control with time stamping methods?
4. Explain concurrency control with optimistic methods?
5. Explain Transaction Recovery?
6. What is Deadlock? Discuss techniques to control deadlocks.

Chapter-II (Distributed Database Management Systems)

1. What is DDBMS? Explain it advantages and disadvantages of DDBMS.
2. What are the components of DDBMS.
3. Distinguishes between distributed database and client/server architecture.
4. Explain database recovery management.
5. Explain performance transparency and query optimization?
6. What is serviceability? Explain in detail.