Download OU B.Sc 2019 June-July 4th Semester 3126 Database Management System Question Paper

FirstRanker.com

FACULTY OF SCIENCE

B.Sc. IV-Semester (CBCS) Examination, May / June 2019

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

Subject : Computer Science

Paper - IV (DSC) : Database Management Systems

Time : 3 Hours Max. Marks: 80

PART - A (5 x 4 = 20 Marks)

(Short Answer Type)

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

Note : Answer any FIVE of the following questions.

1. Define DBMS. Write the advantages of DBMS.
2. Discuss grouping operations with examples.
3. Explain different data types of SQL.
4. What is functional dependency? Explain.

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

5. Describe weak and strong entities with examples.
6. Write about BCNF rules.
7. Explain multi timestamp ordering protocol.
8. Write about nested transactions.

PART - B (4 x 15 = 60 Marks)

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

(Essay Type)

Note: Answer ALL the following questions.

1. (a) Describe the DBMS architecture in detail.
   (b) Explain fundamentals of relational algebra with examples for each.
2. (a) Explain DDL, DML and TCL commands with examples.
   

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

   (b) Explain stored procedures and functions in PL/SQL with examples.
3. (a) Explain entity sets, entity types, attributes and keys with examples.
   (b) Describe logical database design for relational model with an example.
4. (a) Discuss time stamp methods for concurrency control with examples.

FirstRanker.com

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