Download OU B.Com 2nd Sem Relational Database Management Systems Important Questions

FirstRanker.com

Firstranker's choice

BCom | year II Semester Computer Application

--- Content provided by FirstRanker.com ---

Relational Data Base Management Systems

Question Bank

Relational Database Management Systems

Unit I

1. Define Database.

--- Content provided by FirstRanker.com ---

2. Define RDBMS.
3. Explain about data models.
4. What is data sharing?
5. Explain the Evolution of database.

Unit II

--- Content provided by FirstRanker.com ---

1. Define Attributes. Explain different types of attribute.
2. Explain Indices, Data Dictionary and Data files
3. Write about keys with example.
4. Explain advantages of DBMS over File Oriented Systems.
5. Discuss the objectives of Database Approach.

--- Content provided by FirstRanker.com ---

Unit III

1. Explain Relational model Advantages and Disadvantages.
2. Who is DBA? Explain the functions and roles of DBA.
3. Define Object, Relation with examples.
4. Explain Relational Database Integrity.

--- Content provided by FirstRanker.com ---

5. Explain Referential Integrity.

Unit IV

1. What is functional Dependency?
2. What is Normalisation? Explain different types of Normal Forms.
3. What is File Organisation? Explain different types of File Organisation.

--- Content provided by FirstRanker.com ---

4. What is multi Key File Organisation?
5. Explain Relational Algebra.

Unit V

1. Explain ER Model with Example.
2. Write about Heap File.

--- Content provided by FirstRanker.com ---

3. Explain SQL.
4. Explain various SQL Commands with examples?
5. Write about Having clause, Where clause and group by clause.
6. Write about SQL Operators.
7. What is Sequences? Explain procedure of creating, altering, dropping of sequences.

--- Content provided by FirstRanker.com ---

8. Define Index. List the guidelines of managing indexes.
9. Discuss creating a table, temporary table, parallelizing the table creation.
10. Write about atomicity
11. Define Isolation.
12. What is database errors

--- Content provided by FirstRanker.com ---

13. What is Database Recovery?
14. Explain Locking. List various types of locking techniques.
15. What is Deadlock State? Explain the various techniques to control deadlock state.
16. Explain Database Security and Authorization.
17. Explain three levels of DB backup and recovery technique.

--- Content provided by FirstRanker.com ---

18. What is Distributed Database System. Explain the need of DDBMS.
19. Discuss about two-tier Architecture.
20. What is Data Replication? State various types of data replication
21. List various data allocation strategies.
22. Explain three data fragmentation strategies.

--- Content provided by FirstRanker.com ---

23. Give a brief overview on the evolution of client/server computing models.
24. Explain the difference between DDBMS and client server architecture.

FirstRanker.com

Firstranker's choice

--- Content provided by FirstRanker.com ---