Download OU (Osmania University) B.com (Bachelor of Commerce) 2nd Sem Relational Database Management Systems Important Question Bank For 2021 Exam

:
BCom I year II Semester Computer Application
Relational Data Base Management Systems
Question Bank
Relational Database Management Systems
Unit I
1.
Define Database.
2.
Define RDBMS.
3.
Explain about data models.
4.
What is data sharing?
5.
Explain the Evolution of database.
6.
Define Attributes. Explain different types of attribute.
7.
Explain Indices, Data Dictionary and Data files
8.
Write about keys with example.
9.
Explain advantages of DBMS over File Oriented Systems.
10.
Discuss the objectives of Database Approach.
11.
Explain Relational model Advantages and Disadvantages.
12.
Who is DBA? Explain the functions and roles of DBA.
Unit II
1.
Define Object, Relation with examples.
2.
Explain Relational Database Integrity.
3.
Explain Referential Integrity.
4.
What is functional Dependency?
5.
What is Normalisation? Explain different types of Normal Forms.
6.
What is File Organisation? Explain different types of File Organisation.
7.
What is multi Key File Organisation?
8.
Explain Relational Algebra.
9.
Explain ER Model with Example.
10.
Write about Heap File.
Unit III
1.
Explain SQL.
2.
Explain various SQL Commands with examples?
3.
Write about Having clause, Where clause and group by clause.
4.
Write about SQL Operators.
5.
What is Sequences? Explain procedure of creating, altering, dropping of
sequences.
6.
Define Index. List the guidelines of managing indexes.
7.
Discuss creating a table, temporary table, parallelizing the table creation.
Unit IV

1.
Write about atomicity
2.
Define Isolation.
3.
What is database errors
4.
What is Database Recovery?
5.
Explain Locking. List various types of locking techniques.
6.
What is Deadlock State? Explain the various techniques to control deadlock
state.
7.
Explain Database Security and Authorization.
8.
Explain three levels of DB backup and recovery technique.
Unit V

1.
What is Distributed Database System. Explain the need of DDBMS.
2.
Discuss about two-tier Architecture.
Page 1 of 2

---

3.
What is Data Replication? State various types of data replication
4.
List various data allocation strategies.
5.
Explain three data fragmentation strategies.
6.
Give a brief overview on the evolution of client/server computing models.
7.
Explain the difference between DDBMS and client server architecture.
*****
Page 2 of 2

---

Document Outline

• KV Ranga Reddy Degree College for Women: Hyderabad

---