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 By: kannan.p Member Level: Silver Posted Date: 28 May 2008
|
2007 Anna University B.E Computer Science DATABASE MANAGEMENT SYSTEMS Question paper
CS 1301- DATABASE MANAGEMENT SYSTEMS
PART-A
1. List any two advantages of database systems.
2. Give the reasons why null values might be introduces into the database
3. What is static SQL? How does it differ from dynamic SQL?
4. What are the different types of integrity constraints used in designing a relational database.
5. Compare sequential access devices versus random access devices with an example .
6. What can be done to reduce the occurrences of bucket overflows in a hash file organization?
7. Give the ACID properties.
8. State the benefits of strict two-phase locking.
9. What is the need for complex data types?
10. What is data mining?
PART - B
11 (a) Explain the system structure of a database system with neat block diagram.
OR
(b) (i) Construct an ER-diagram for hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted.
(ii) Discuss on various relational algebra operators with suitable example.
12 (a) (i) Considerr the employee database, where the primary keys are underlied.
employee (empname, street,city)
works (empname.companyname,salary)
company(companyname,city)
manages(empname,managername)
and give an expression in SQL for the following queries:
(1) Find the names of all employees who work for first bank corporation.
(2) Find the names.street addresses,and cities of residence of all employees who work for first bank corporation and earn more than 200000 per annum.
(3) Find the names of all employees in this database who live in the city as the companies for which they work.
(4) Find the names of all the employees who earn more than every employees of small corporation.
(ii) Discuss the names and weaknesses of the trigger mechanism. Compare triggers with other integrity constraints supported by SQL.
OR
(b) (i) What is normalization? Explain the various normalization techniques with suitable example.
(ii) Give the comparison between BCNF and 3NF.
13. (a) (i) Explain how the RAID system improves performance and relaiability.
(ii) Describe the structure of B+ tree and list the characteristics of a B+ tree.
OR
(b) (i) Explain the steps involved in processing a query.
(ii) Give the algorithm for hash join.
14.(a) (i) Describe about the testing of serializability.
(ii) Discuss on two-phase locking protocol.
OR
(b) (i) Explain the deferred and immediate- modification versions of the log-based recovery scheme
(ii) Write short notes on shadow paging
15.(a) (i) Highlight the features of OODBMS.
(ii) Write short notes on distributed databases.
OR
(b) (i) Give the structure of XML data.
(ii) Explain the architecture of a typical data warehouse and describe the various components of data ware house
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.
|
Watch TV Channels
|