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 Information Technology Database structure Question paper
Y-571
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2007
DATABASE ENGINEERING
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 aping constraints. [Marks 8]
b) Discuss the concept overgeneralization and aggression. [Marks 8]
Q.2.
a) Illustrate with example the relational algebra. [Marks 8]
b) What is SQL? Discuss salient features of SQL. [Marks 8]
Q.3
a) Describe typical RDBMS. [Marks 8]
b) How does the remapping of bad sectors by disc controllers affect data retrieval rates? Explain in brief. [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. 6)
a) Describe the basic concept of indexes. [Marks 8]
b) Draw state diagram of transaction. Explain in brief [Marks 8]
Q.6)
a) Describe database log-in log based recovery. [Marks 8]
b) Describe conflicts serilizable schedules [Marks 8]
Q.7)
a) Explain testing of view serilizability. [Marks 8]
b) Explain transaction in detail. [Marks 8]
Q.8) Write a short notes on (any three): [Marks 18]
a) Two phase locking protocol
b) Stable storage implementation
c) Check-point
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.
|
Advertise Here
|