Andhra University 2009 B.C.A Computer Application Andra university - Question Paper

[BCA-301]
B.C.A DEGREE EXAMINATION
THIRD YEAR
RELATIONAL DATABASE MANAGEMENT
SYSTEMS

Time:3hours Max. Marks :75
SECTION-A
Answer ALL questions
(4 x 10 = 40)

1. a) What is DBA? Explain the functions of DBA.
OR
b) Explain the three levels of data abstraction in a DBMS.

2. a) List and explain various operations on relational algebra.
OR
b) Define 3NF and Boyce-Cod normal form. Explain the
Difference between these normal forms

3. a) Explain about the correlated nested queries with an example
OR
b) Describe the strict two-phase locking protocol.

4. a) What is the concept of distributed database? Discuss the
Advantages of distributed database.
OR
[BCA-301]

b) Briefly explain about distribution and integration of data.
SECTION B
Answer any FIVE questions
5. What is differences between logical data independence and
Physical data independence?
6. What are different ER diagram notations?
7. Write the advantages of views.
8. Write about outer join operation.
9. What is difference between a key and a super key?
10. Write about shadow paging.
11. What are the additional functions of distributed database?
12. What is the difference between persistent and transient objects?

SECTION C

13. What are the responsibilities of the data designers?
14. What is the three-schema architecture of DBMS?
15. What is entity set?
16. What are the differences between classification and instantiations?
17. What is hierarchical data model?
18. What is GROUP BY clause?
19. Write SQL query to find the names of students who are not
Enrolled in any class.
20. What do you mean by redundancy?
21. What are multiple inheritances?
22. What is object identifier?