Download OU B.Sc 2018 May-June 2nd Year 2nd Semester 7119 Database management system Question Paper

FirstRanker.com

FACULTY OF SCIENCE

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

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

Subject: Computer applications

Paper - IV

Database Management Systems

Max Marks: 80

Time: 3 Hours

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

PART - A (5x4 = 20 Marks)

[Short Answer Type]

Note: Answer any five of the following questions.

1. Explain about three level architecture.
2. Explain about integrity constraints.

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

3. Explain different aggregate functions supported by SQL.
4. Explain about scalar data types.
5. What is an attribute? Explain different types of attributes.
6. Explain about functional dependency.
7. Explain about properties of transaction.

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

8. Explain about Two Phase Locking (2PL).

PART - B (4x15 = 60 Marks)

[Essay Answer Type]

Note: Answer any four questions from the following.

9. a) Explain the advantages and disadvantages of DBMS.
   

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

   OR
   b) Explain the functions of DBMS.
10. a) Explain about functions and procedures in advanced-SQL.
    OR
    b) Explain about discretionary access control mechanism.

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

11. a) Explain about specialization, generalization and aggregation with suitable examples.
    OR
    b) Define Normalization. Explain about 3NF and BCNF with examples.
12. a) Explain about Deadlocks in detail.
    OR
    

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

    b) Explain different recovery techniques.

FirstRanker.com