My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Download Model question papers & previous years question papers
|
Posted Date: 02 Jan 2008 Posted By: Girish Patil Member Level: Platinum
|
2006 Shivaji University B.E Computer Science DATABASE ENGINEERING Question paper
H-357
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2006
SHIVAJI UNIVERSITY, KOLHAPUR
DATABASE ENGINEERING
Day and Date: Wednesday, 22-11-2006 Total Marks: 100
Time: 10.00p.m. To 1.00p.m.
Instructions:
Instructions:
1) Solve any THREE questions from SECTION-1
2) Solve any THREE questions from SECTION-2
3) Figures to right indicates full marks
SECTION-1
Q.1
a) Explain entities, their sets and mapping constraints. [Marks 8]
b) Explain the advantages of database systems over condensational file system. [Marks 8]
Q.2.
a) What do you understand by domain relational calculus? Explain with example. [Marks 8]
b) With example explain normalization is using join dependencies. [Marks 8]
Q.3
a) What is meant by file organization? Explain at least 3 different file organizations. [Marks 8]
b) What is data dictionary storage? Illustrate with example. [Marks 8]
Q.4 Write a short notes on [Marks 18]
a) Generalization
b) Relational algebra
c) Attributes types in ER diagram
SECTION-2
Q. 6)
a) Comment on the difference between index-sequential files and B+ tree file organization. [Marks 8]
b) Describe the steps in query processing along with necessary diagram.[Marks 8]
Q.6)
a) Classify the various types of failures that may occur in a system. [Marks 8]
b) What is view of serilizable? Explain the steps.. [Marks 8]
Q.7)
a) Explain static and dynamic hash function. [Marks 8]
b) Explain transaction in detail. [Marks 8]
Q.8) Write a short notes on (any three): [Marks 18]
a) Validation technique
b) Buffer management
c) Multiple key access
Return to question paper search
|
|
|
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.
|
Advertise Here
|