Andhra University 2009 B.C.A Computer Application Andra university - exam paper

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

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

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

2. a) List and discuss different operations on relational algebra.
OR
b) describe 3NF and Boyce-Cod normal form. discuss the
Difference ranging from these normal forms

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

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

b) Briefly discuss about distribution and integration of data.
part –B
ans any 5 ques.
5. What is differences ranging from logical data independence and
Physical data independence?
6. elaborate various ER diagram notations?
7. Write the advantages of views.
8. Write about outer join operation.
9. What is difference ranging from a key and a super key?
10. Write about shadow paging.
11. elaborate the additional functions of distributed database?
12. What is the difference ranging from persistent and transient objects?

part –C

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

Earning:   Approval pending.