New Member FAQ | Forums | Earn Revenue


Resources Entrance Ask Experts Exam Papers Jobs English Projects Universities Colleges Courses Schools Training My India



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.

website counter



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



Course: B.E Information Technology   University: Basara University




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

Next Question Paper: Computer Organisation

Previous Question Paper: Engineering chemistry

Related Question Papers:


  • System Programming


  • Computer Organisation


  • Engineering chemistry


  • Computer Organisation


  • Database structure


  • Categories


    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





    Contact Us   Advertise   Editors    Privacy Policy    Terms Of Use   

    ISC Technologies.
    2006 - 2009 All Rights Reserved.