Database Management System 2018 MCA 4th Sem AKTU

Printed Pages: 1 Sub Code: RCA401

Paper Id: 214421 Roll No. _____________________

MCA(SEM IV) THEORY EXAMINATION 2017-18DATABASE MANAGEMENT SYSTEMS

Time: 3 Hours Total Marks: 70

Note: Attempt all Sections. If require any missing data; then choose suitably.

SECTION A

1. Attempt all questions in brief. 2 x 7 = 14

1. What do you mean DBMS?
2. How entity sets converted to relations?
3. Define joins in relations.
4. Write the ways to declare key constraints.
5. Define secondary index.
6. What do you mean by query plan?
7. How compilation of queries is done?

SECTION B

2. Attempt any three of the following: 7 x 3 = 21

1. Describe evolution of database systems.
2. Write down the basics for relational model. How E/R diagrams can be converted to relation design?
3. Discuss simple queries and queries involving more than one relation.
4. Explain various indexes on sequential files.
5. Discuss various issues and models for resilient operaions.

SECTION C

3. Attempt any one part of the following: 7 x 1 = 7

1. Discuss various elements of E/R model.
2. Explain modeling of constraints in E/R model.

4. Attempt any one part of the following: 7 x 1 = 7

1. Write short note on design of relation database schemas.
2. Discuss extended operatos of relational algebra.

5. Attempt any one part of the following: 7 x 1 = 7

1. Discuss relation schema, view and datbase modifications.
2. Explain keys, foreign keys and constraints on attributes and tuples.

6. Attempt any one part of the following: 7 x 1 = 7

1. Discuss compressed bitmaps and managing bitmap indexes.
2. Explain scanning tables and parameters for measuring costs.

7. Attempt any one part of the following: 7 x 1 = 7

1. What do you mean by serial and seralizable schedules? Explain conflict serializability.
2. Discuss concurrency control by timestamps.

Thank You!