Pondicherry University 2009 B.C.A Computer Application ,DBMS - Question Paper

(Pondicherry university)
B.C.A DEGREE EXAMINATION, APRIL/MAY 2009.

FOURTH SEMESTER

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEM

PART-A (10*2=20 MARKS)

ans ALL THE ques.

1. What is a database?

2. What term is used to define the consistency of data in all applications?

3. List out the kinds of approaches to be used for t the database structures.

4. When do we say that an attribute is functionally dependent on a different attribute?

5. Define pointers.

6. Define- hashing.

7. List out the data kinds available in oracle.

8. What are the DDL commands in oracle?

9. Write the syntax to create a unique index?

10. What is the purpose of using exception handling in PL/SQL?




PART-B (5*6=30 MARKS)
ANSWERS ANY 5 ques.

11. describe the subsequent terms
(a) entity
(b) attribute
(c) data item
(d) record
(e) tuble
(f) file

12. Differentiate the logical and physical organization of data

13. Write a note on tree-structure.

14. explain about 3rd normal form.

15. discuss about any 2 addressing techniques.

16. Write a note on Hashing.

17. discuss the subsequent commands
(a) Commit
(b) Delete
(c) define
(d) Drop.

18. discuss the different kinds of flow controls in PL/SQL.

Part-c (5*10=50 marks)

ans all ques.

19. discuss the characteristics of database system.
Or
20. explain the concept of a data model. What data models are used in database management system?

21. discuss DML operations in database system.
Or
22. define about the relational data base.


23. discuss briefly about indexed Sequential organization.
Or
24. Write short notes on pointers.


25. explain about different string functions in oracle.
Or
26. discuss various join and union operations in oracle.


27. How to create and debug procedures in PL/SQL? discuss it.
Or
28. discuss in detail about Triggers.

Earning:   Approval pending.