DBMS PREVIOUS YEAR QUESTION PAPER OCTOBER/NOVEMBER 2012

B.Sc III YEAR EXAMINATION

DATABASE MANAGEMENT SYSTEM

OCTOBER/NOVEMBER 2012

TIME 3HRS                                                                                                            MARKS 100

SEC - A

I   ANSWER ALL QUESTIONS:

       1.  Define the following:

1. Meta Data
2. Data Models
3. Subtype discriminator
4. Degree of relationships
5. Write any 4 arithmetic functions.
6. Cursor in Sql
7. Transaction
8. Lock Granularity
9. Data warehouse
10. Slice and dice technique

II  ANSWER ALL QUESTIONS:

2. a. Explain Codd's relational database rules.
    b. Explain the advantages of DBMS.

or

    c. Define a relation and explain the characteristics of relational table.
    d. Define Business rules.

3  a. Explain EER Model constraints briefly.
    b. Explain super and subtype entities with example.

or

    c. What is an attribute? Explain different types of attributes with examples.
    d. Write short notes on attribute inheritance, specialization and entity clustering.

4  a. Explain DDL and DML Commands with syntax and examples.
    b. Write short notes on set operations.

or

    c. Explain SDLC with the help of a neat diagram.
    d. Explain view and index in SQL.

5  a. What is concurrency control? Write about 3 main problems cause by concurrency control.
    b. Write short notes on wait/die and wound/wait schemes.

or

    c. Explain the characteristics of DDBMS.
    d. Explain two phase commit protocol.

6  a. Define the data warehouse properties.
    b. Describe OLAP and explain its properties.

or

    c. Describe various phases in Data /mining.
    d.What are different technical roles of DBA?