Advanced Database Management System
Max Marks: 20
Note: The Question paper is divided into three sections A, B, and C. Write Answer as per the given instruction.
Section-A (Very Short Answer Type Questions)
Note: Answer all questions. As per the nature of the question you delimit your answer in one word, one sentence or maximum up to 30 words. Each question carries 1 mark. 4×1=04
1. _____________________ and ______________________ are the two types of constraints on a relationship.
2. Cardinality ratio is the ___________________ number of relationship instances that an entity can participate in.
3. In an ER-diagram, the entities, attributes and relationships are represented as _____________, _______________ and _________________ respectively.
4. Participation constraints in relationships are of two types, _____________ and _______________ participation.
Section-B (Short Answer Questions)
Note: Answer any 2 questions. Each answer should not exceed 200 words. Each question carries 4 marks. 2×4=08
1. Explain three level database architecture. What are its objectives?
2. What do data independence and its types? How data independence is achieved?
3. What are advantages of DBMS?
4. Discuss the main disadvantages of a Traditional file approach?
Section ‘C’ (Long Answer Questions)
Note: Answer any one question. You have to delimit your each answer maximum up to 800 words. Each question carries 08 marks.
Q.1 What is a JOIN operation? How is it represented? Explain with example.
Q.2 How does a tuple relational calculus differ from domain relational calculus?
Latest Govt Job & Exam Updates: