OU Degree Relational Database Management Systems Important Questions

[Rahul]

OU Degree Relational Database Management Systems ( RDBMS ) Important Questions - Set 1

Download attachment

www.forum.universityupdates.in

OU Degree Relational Database Management Systems ( RDBMS ) Important Questions - Set 2

Download attachment

www.forum.universityupdates.in

Unit -1
1. What is File system? Disadvantages of File system?
2. What is DBMS? Advantages of DBMS?
3. DBA functions and roles?
4. What is Relational model?
5. Explain ER model including diagram?

Short
1. DBMS
2. Primary key, Foreign key, candidate key and super key
3. Write relational algebra functions
4. Weak and strong entity
5. Specialization, Generalization and Aggregation

Unit - 2
1. What is Normalization? Write all normal forms with an examples
2. How to store database on hard disk
3. Index sequential file organization and hashed file organization
4. Types of indexes

Short
1. Entity integrity constraints
2. Functional depending
3. Decomposition
4. Binary search tree.

Unit - 3
1. What is SQL and explain DDL,DML,DCL and TCL commands
2. Explain all SQL data types
3. SQL queries

Short
1. Grant and revoke
2. Commit and rollback
3. Operators in SQL
4. Where clause
5. Group by and having clause
6. Order by clause
7. Types of Joins

Unit - 4
1. Explain ACID properties
2. Concurrent transactions
3. Locking system
4. Dead lock and its preventions
5. Data base recovery
6. Database security and integrity

Unit - 5
1. What is distributed database management system and advantages?
2. Client and server database – 2 tier and 3 tier architecture
3. Data Fragmentation
4. OLTP and OLAP

Short
1. Data warehouse
2. Mobile database
3. Data replication
4. Database partition