DBMS PREVIOUS YEAR QUESTION PAPER MARCH/APRIL 2014

DBMS PREVIOUS YEAR QUESTION PAPER MARCH/APRIL 2014

FACULTY OF INFORMATICS

B.Sc III YEAR EXAMINATION

MARCH/APRIL 2014

DATABASE MANAGEMENT SYSTEMS

TIME: 3 HOURS                                                                                    MAX MARKS 100

SEC - A

1. ANSWER ALL QUESTIONS:
1. Define Index
2. What are the data models?
3. What is Foreign key?
4. Explain Primary key.
5. Discuss ISA
6. Deadlock
7. Serializability
8. ROLAP
9. Star Schema


2. ANSWER ALL QUESTIONS:

          2.  a. Discuss the problems of file system data management.

               b. What is relationship? Discuss the relationships in the relational database.

or

                c. Explain data redundancy problem.

                d. What are the components of DBMS?

          3.   a. Discuss Generalization and Specialization with neat diagram.
                b. Explain in detail 4NF,5NF.

   or

                c.What is entity relationship model? Explain with examle.
                d. What is entity clustering? Explain the use in the ER diagram.

          4.   a. What is a View? How to create and delete a view? Explain with example.
                b. What is database life cycle? Explain with a diagram the different states of database life                         cycle.

or

                c. What is cursor? What are their types explain with examples.
                d. With syntax and example write the important numeric and string functions.

           5.  a. What is transaction? What are their properties?
                b. What are the advantages and disadvantages of DDBMS?

or

                c. Discuss in detail database recovery management.
                d. Explain the differences between distributed database and client server architecture.

           6.  a. What is data warehouse? Explain its architecture.
                b. How does data mining work? Discuss the different phases in data mining process.

or

                c. What is business intelligence? Describe BI Framework.
                d. Describe DBA's responsibilities.