2002 Andhra University MSc Computer Science RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper for exam preparation. Question paper for 2002 Andhra University MSc Computer Science RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper, 2002 Andhra University MSc Computer Science RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper. SiteMap
K2Questions Logo

2002 Andhra University MSc Computer Science RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper

University Question Papers
2002 Andhra University MSc Computer Science RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper
M.Sc Degree Examination
Second Year - First Semester Computer Science

RELATIONAL DATABASE MANAGEMENT SYSTEMS


Time: Three hours
Maximum: 75 marks

First Question is compulsory
Answer any FOUR from the remaining questions
All questions carry equal marks
Write all the bits of the first question at one place.

1.
a. Candidate key
b. DBA (Data Base Administrator)
c. Pitfalls in database design
d. Domain Relational Calculus

2.
(a) Explain what the Buffer Manager must do to process a read request for a page. What happens if the requested page is in the pool but not printed?

(b) Explain about data abstraction.

3.
Explain what is meant by:
(a) Repetition of information
(b) Loss of information
(c) Inability to represent information

Explain why any one of the these properties may indicate a bad relational database design.

4. (a) Discuss briefly about join dependably.

(b) Distinguish between the sparse and dense indexes.

5.
Consider the relation database:
Lives (person-name, street, city)
Works(person-name, company-name, salary)
Located-in(company-name-city)
Manager(person-name, manager-name)

(a) Find the name of the employer, street, city of all employees who work for First Bank Corporation and earn more than $10,000

(b) Find all employers who earn more than every employee of small bank corporation

(c) Find all employee name who lives in the same city as that of manager of First Bank Corporation

(d) Delete all the tapes in the works relation employees of Small Bank Corporation

6.
(a) What is the difference between B and B+ trees? Discuss

(b) Construct a B+ tree for the following set of key values:

2,9,12, 16, 17, 22, 27, 35, 43, 45.

7.
(a) Explain briefly about security specification in SQL.

(b) What are disadvantages of database systems?

8.
(a) What are the basic consistency problems in transaction management?

(b) What are the various types of Access Control Mechanisms?



About us | SiteMap | Terms of use | Privacy Policy | Disclaimer | Contact us | ©2010 K2Questions.com