Download Model question papers & previous years question papers

Posted Date: 20 Oct 2016      Posted By:: panchami    Member Level: Gold  Points: 3 (Rs. 3)

2015 Database management system second semester MCA exam 2015 Question paper



Course:   University/board:

Are you looking for the old question paper of MCA second semester degree examination of Database management system? Here is the previous year question paper from Kerala university. This is the original question paper from the MCA second semester examination conducted in the year 2015. Feel free to download the question paper from here and it to prepare for your upcoming exam.



SECOND SEMESTER MCA DEGREE MODEL EXAMINATION, 2015 (2006 Admn.)
06.205: DATA BASE MANAGEMENT SYSTEM.


Time : 3 Hours
Max. Marks : 100

PART A

Answer all questions. Each carries 4 marks.

1. What are different models of locking? What is meant by Comp matrix?

2. Illustrate the use of outer join.

3. What is meant by a view?

4. Who are the different categories of database users?

5. Define functional dependency. Write any two axioms based in functional dependencies.

6. List the responsibilities of the Database Manager.

7. Explain how a transaction is managed in SQL.

8. What is data independence?

9. Draw and explain state diagram of transaction.

10. What is normalization? What are its objectives?

[10 x 4 = 40 Marks]

PART B

Answer all six questions. Each question carries 10 marks.

1. Explain Database system structure with a neat diagram.

2. Compare conventional file processing system with DBMS.

3. Explain the fundamental operations in relational algebra with suitable examples.

4. What is meant by data abstraction? Explain the difference between physical level, conceptual level and view level of data abstraction.

5. Explain indexing in detail.

6. ABN bank offer 5 types of account, namely Savings, Recurring, Loan, Current and Money market. It operates a number of branches and clients of the branch have any number of accounts. Accounts can be individual or joint. Identify the entities and of your interest and show their attributes. What relationships exist among these attributes? Draw the corresponding ER diagram. Also design a relational schema to the above ER diagram.

[6 x 10 = 60 Marks]





Return to question paper search

Next Question Paper: MECE-003: Actuarial Economics: Theory And Practice in Specialization of (Economics) from IGNOU

Previous Question Paper: Original question paper of Maharashtra State Board of Technical Education (MSBTE) for Diploma in Electronics and Telecommunication Engineering for Sixth semester.(Winter 2015 G). Subject :- Advanced Communication System(17656)

Related Question Papers:


Categories


Submit Previous Years University Question Papers and make money from adsense revenue sharing program

Are you preparing for a university examination? Download model question papers and practise before you write the exam.


Awards & Gifts
Top Contributors
TodayLast 7 Daysmore...

Online Members

Nilesh
More...
 
ISC Technologies, Kochi - India. © All Rights Reserved.