DBMS PREVIOUS YEAR QUESTION PAPER OCTOBER/NOVEMBER 2013

B.SC. III YEAR EXAMINATION

OCTOBER/NOVEMBER 2013

DATABASE MANAGEMENT SYSTEMS

time: 3 hours                                                                                         max marks 100

Sec - A (10x2=20)

I.  Answer all questions:

1. list the limitations of DBMS.
2. Define Index
3. Explain function dependency.
4. What is Surrogate key?
5. Explain triggers.
6. List the different types of locks.
7. Write the syntax of grant and revoke.
8. What are the types of concurrency control without locking method?
9. Define Database Administrator.
10. Write short notes on Data mining.

Sec-B (5x16=80)

II. Answer all questions:

    2. (a) Briefly discuss the data abstraction.
        (b) Explain the basic building blocks of Data model.

or

        (c) What are the functions of DBMS?
        (d) What are the business rules? Discuss in detail.

    3. (a) Explain 3NF and BCNF.
        (b) What is entity? Explain different types of attributes with examples.

or

        (c) Explain Supertype and Subtype relationships. Explain with examples.
        (d) Briefly discuss the degree of relationships.

    4. (a) Explain centralized and decentralized database design.
        (b) Explain various data conversion functions in SQL.

or

        (c) What is Exceptional handling? Explain with example.
        (d) Write the syntax and example write the important SQL functions.

    5  (a) Discuss Transaction transparency.
        (b) Explain concurrency control with time stamping.

or

        (c) What is Data replication? Explain 3 replication strategies.
        (d) Explain distributed database design.

    6  (a) What is OLAP? Discuss briefly the characteristics.
        (b) Explain in brief the evolution of the database administration function.

or

        (c) Discuss data dictionary as data administration tool.
        (d) Differentiate DA and DBA.