DBMS PREVIOUS YEAR QUESTION PAPER MARCH/APRIL 2013

B.Sc III YEAR EXAMINATION,

DATABASE MANAGEMENT SYSTEMS

MARCH/APRIL 2013

TIME:3 HRS                                                                            MAX MARKS:100

SEC-A

I. ANSWER ALL QUESTIONS:

1. Redundancy
2. Data dictionary
3. Primary key, Foreign key
4. Atomic attribute
5. Define cursors. What are their types?
6. Write the syntaxes of Commit and Rollback.
7. Explain Database Recovery Management in brief.
8. What is data fragmentation?
9. Data mining.
10. Data as a corporate asset - justify.

Sec-B

II. ANSWER ALL QUESTIONS:

   2.  a. Explain Data Redundancy Problems.

        b. Briefly discuss the data abstraction

or

        c. Explain the steps required to develop an ER diagram.

        d. What are Codd's relational database rules?

   3   a. What are basic constructs of the ER model? Explain with example.

        b. Explain with example 1NF and 2NF.

or

        c. Briefly discuss the degrees of relationships.

        d. Explain supertype and subtype relationship with examples.

   4   a. Explain various stages of SDLC.

        b. Explain different set operators with examples.

or

        c. What is sequence? What is the syntax to create a sequence?

        d. Discuss various Joins with examples.

   5   a. What is concurrency control? Explain concurrency control with locking methods.

        b. Discuss about the query optimization.

or

        c. What is Deadlock? How to detect and prevent?

        d. What are the components to DDBMS?

   6   a.  Discuss database administration tools.

        b. What is star schema? What are its components?

or

        c. Explain in detail the characteristics of Data warehouse data and Operational database data.

        d. Explain in detail the components of the Data Base Environment.