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: 19 Jul 2009 Posted By: guna Member Level: Gold
|
2007 Basara University B.E Database structure Question paper
Date: 22-05-2007 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) Distinguish Database System And File System. [Marks 8]
b) Describe ER model. [Marks 8]
Q.2.
a) List and explain the fundamental operations on relational algebra. [Marks 8]
b) What is key? Explain different keys in relational model. [Marks 8]
Q.3
a) Explain file organization wit variable length records. [Marks 8]
b) What is data dictionary storage? Illustrate with example. [Marks 8]
Q.4 Write a short notes on (any three): [Marks 18]
a) Reducing ER diagram to tables
b) Domain relational calculus
c) Normalization using functional dependencies
d) Sequential file organization
SECTION-2
Q. 6)
a) List and discuss storage types and failure types. [Marks 8]
b) Explain immediate database modification recovery scheme with example.[Marks 8]
Q.6)
a) Explain two phase looking protocol with example.. [Marks 8]
b) What are methods or lock used in multiple granularity schemes? Give compatibility matrix for them. [Marks 8]
Q.7)
a) Explain the stable storage implementation in detail [Marks 8]
b) Explain activity level analysis using SPC. [Marks 8]
Q.8) Write a short notes on (any three): [Marks 18]
a) Estimation of query processing cost
b) Testing for serializability
c) Buffer management
d) 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
|