Osmania University Database Management System Study Material/Notes - Set 1
Set 1 | Set 2 | Set 3 | Set 4
Osmania University Database Management System Important Questions
Set 1 | Set 2
Osmania University Database Management System Model Question Papers
www.forum.universityupdates.in
Unit-1
1. What is dbms? What are the advantages and disadvantages dbms?
2. What is dbms? What is the purpose of designing database systems? (Disadvantages of file based systems)
3. Write about various database languages?
4. What are the applications of database systems?
5. What is data abstraction? What are the 3 levels of data abstraction?(write about view of data)
6. What is relational database?
7. what is database architecture(components of dbms)
8. Write about different types of database users?
9. What is DBA? What are the roles and functions of dab?
10. What are database schema and its types (external, conceptual, physical?)
11. Wite about various database keys
12. Write about relational query language and its types (procedural and non procedural)
13. Write about various relational/set operations?
14. What is relational algebra? What are the various relational algebra operations?
Unit-II
1. What is ER model? What are the basic building block of err model?
2. What is ER- diagram? What are the various symbols used in ER-diagrams?
Steps for designing ER diagram?
3. What is attribute ? What are the types of attributes?
4. What are the entity relationship design issues?
5. write about specialisation, generalisation, aggregation, composition with example? (Extended ER
features)
6. What is functional dependency? What are the types of functional dependencies?
7. What is Normalisation? Write about 1NF, 2NF, 3NF, BCNF
8. Write about decomposition using multivalve dependencies?
9. Write about database design methodology for relation databases?
Unit-III
1. What is DDL and DML commands with syntax and examples?
2. Write about DCL and TCL commands with syntax and examples?
3. Write about various set operations with examples?
4. What is null value?
5. Write about various group or aggregate functions?
6. Write about nested queries with examples?
7. write about where, order by, group by, having clause
8. What is join? Different types of joins
9. What is view? How do you create, update and delete a view?
10. What is transaction? Write about commit, rollback, and savepoint
11. What are the various data types in sql?
12. What is authorisation? Discuss about granting and revoking of privileges?
13. How to access sql from a programming language (write about job connectivity)
14. Write about functions and procedures in pl/sql
15. What is trigger? How do you create triggers in psalm with program?
16.What are the various Integrity constraints?
UNIT-IV
1. What is transaction? What are the various ACID properties?
2. What is transaction? What are the various states of transactions?
3. What is Concurrency control and need for Concurrency control?
4. What is concurrency control? What are the problems associated with Concurrency control?
5. What is concurrency control? Write about concurrency control with locking methods?
6. What is concurrency control? Write about concurrency control with time stamping methods?
7. What is concurrency control? Write about concurrency control with Optimistic methods?
8. What is lock? Types of locks? (GRANULARITY OF DATA ITEMS)
9. What is dead lock? How do you avoid, detect and prevent dead lock situation?
10. What is database recovery? Need of database recovery?
11. What is database recovery? What are the various recovery techniques?
12. What is database security? What are the types of threats?
13. What is database security? Write about various computer based controls
Set 1 | Set 2 | Set 3 | Set 4
Osmania University Database Management System Important Questions
Set 1 | Set 2
Osmania University Database Management System Model Question Papers
University Updates
www.forum.universityupdates.in
Unit-1
1. What is dbms? What are the advantages and disadvantages dbms?
2. What is dbms? What is the purpose of designing database systems? (Disadvantages of file based systems)
3. Write about various database languages?
4. What are the applications of database systems?
5. What is data abstraction? What are the 3 levels of data abstraction?(write about view of data)
6. What is relational database?
7. what is database architecture(components of dbms)
8. Write about different types of database users?
9. What is DBA? What are the roles and functions of dab?
10. What are database schema and its types (external, conceptual, physical?)
11. Wite about various database keys
12. Write about relational query language and its types (procedural and non procedural)
13. Write about various relational/set operations?
14. What is relational algebra? What are the various relational algebra operations?
Unit-II
1. What is ER model? What are the basic building block of err model?
2. What is ER- diagram? What are the various symbols used in ER-diagrams?
Steps for designing ER diagram?
3. What is attribute ? What are the types of attributes?
4. What are the entity relationship design issues?
5. write about specialisation, generalisation, aggregation, composition with example? (Extended ER
features)
6. What is functional dependency? What are the types of functional dependencies?
7. What is Normalisation? Write about 1NF, 2NF, 3NF, BCNF
8. Write about decomposition using multivalve dependencies?
9. Write about database design methodology for relation databases?
Unit-III
1. What is DDL and DML commands with syntax and examples?
2. Write about DCL and TCL commands with syntax and examples?
3. Write about various set operations with examples?
4. What is null value?
5. Write about various group or aggregate functions?
6. Write about nested queries with examples?
7. write about where, order by, group by, having clause
8. What is join? Different types of joins
9. What is view? How do you create, update and delete a view?
10. What is transaction? Write about commit, rollback, and savepoint
11. What are the various data types in sql?
12. What is authorisation? Discuss about granting and revoking of privileges?
13. How to access sql from a programming language (write about job connectivity)
14. Write about functions and procedures in pl/sql
15. What is trigger? How do you create triggers in psalm with program?
16.What are the various Integrity constraints?
UNIT-IV
1. What is transaction? What are the various ACID properties?
2. What is transaction? What are the various states of transactions?
3. What is Concurrency control and need for Concurrency control?
4. What is concurrency control? What are the problems associated with Concurrency control?
5. What is concurrency control? Write about concurrency control with locking methods?
6. What is concurrency control? Write about concurrency control with time stamping methods?
7. What is concurrency control? Write about concurrency control with Optimistic methods?
8. What is lock? Types of locks? (GRANULARITY OF DATA ITEMS)
9. What is dead lock? How do you avoid, detect and prevent dead lock situation?
10. What is database recovery? Need of database recovery?
11. What is database recovery? What are the various recovery techniques?
12. What is database security? What are the types of threats?
13. What is database security? Write about various computer based controls
Last edited: