Scribd
Upload
11 views1 page

MCA Database Management Exam Questions

The document outlines the Mid-I Examination for the I MCA year at Aditya Women's Degree & PG College, focusing on Database Management. It includes a list of questions, with the first question being mandatory, covering various topics such as database management systems, normalization, and relational algebra. The exam is structured to assess students' understanding of key concepts in database management over a duration of 3 hours for a total of 70 marks.

Uploaded by

venkatesh k
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

MCA Database Management Exam Questions

The document outlines the Mid-I Examination for the I MCA year at Aditya Women's Degree & PG College, focusing on Database Management. It includes a list of questions, with the first question being mandatory, covering various topics such as database management systems, normalization, and relational algebra. The exam is structured to assess students' understanding of key concepts in database management over a duration of 3 hours for a total of 70 marks.

Uploaded by

venkatesh k
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ADITYA WOMENS DEGREE & PG COLLEGE

Gopalapatnam, Visakhapatnam
MID-I EXAMINATION
DATE: YEAR: I MCA Time :3hr
SUBJECT: DATA BASE MANAGEMENT Marks:70M

I. Write any five questions (1st question mandatory) 5x


14=70M
1. a) What is data base management system? 2m
b) Difference between data and information? 2m
c) What is partial functional dependency? 2m
d) What is trigger? 2m
e) What is data abstraction? 2m
f) What is index? 2m
g) Explain window functions? 2m

2. a) Explain data base system structure?


b) Explain relational calculus.
3. What is normalization? Explain types of normalization?
4. a)Explain overview of the design process ?
b)Explain ER components with examples?
5. a)What is functional dependency? Explain types of dependences?
b) Explain three schema architecture?
6. a) Explain intermediate and advanced features?
b) Explain schema refinement?
7. a) Explain relational algebra?
b) Explain integrity constraints with examples?
8. a) What is join. Explain types of join with examples?
b) Explain views with examples.

You might also like