Download Model question papers & previous years question papers
|
Posted By: Girish Patil Member Level: Diamond Posted Date: 02 Mar 2008
|
2007 BabaSaheb Bhimrao Ambedkar University B.Tech Information Technology Database Engineering Question paper
|
|
|
Day and Date: Wednesday, 22-11-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) 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.2
a) Explain entities, their sets and mapping constraints. [Marks 8]
b) Explain the advantages of database systems over condensational file system. [Marks 8]
Q.3.
a) List and explain different components of SQL. [Marks 8]
b) Explain the basic components of referential integrity. [Marks 8]
Q.4 Write a short notes on (any 3) [Marks 18]
a) Data abstraction model
b) Domain relational calculus
c) Attributes types in ER diagram
d) Buffer management
SECTION-2
Q.5)
a) Explain static and dynamic hash function. [Marks 8]
b) Explain transaction in detail. [Marks 8]
Q. 6)
a) Describe the basic concept of indexes. [Marks 8]
b) Draw state diagram of transaction. Explain in brief [Marks 8]
Q. 7)
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.8) Write a short notes on (any three): [Marks 18]
a) Equivalence of expression
b) Database modifications
c) Multiple key access
d) Graph based protocol in concurrency control
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.