Madras University (UnOM) 2005 B.C.A Computer Application Database management system - Question Paper

PART A - (10 x three = 30 marks)

ans any TEN ques.. All ques. carry equal marks.

every ans should not exceed 50 words.

1.Write a note on Query processor.


2.What are Events?


3.Write a note on Data Dictionary.


4. What is the use of ORDER BY clause? provide an example.


5. Write a note on CREATE VIEW command.


6.Write about UNION operator in SQL.


7.What are the basic kinds of forms?


8. elaborate the common uses for Report Layout Elements?


9. elaborate Tool bars?


10.Write a note on Data clustering.


11. List down the role of Database Administrator.


12. Write a note on OLE.


PART B - (5 x six ~ 30 marks)


ans any 5 ques.. All ques. carry equal marks.

every ans should not exceed 200 words.

13.Write short notes on class diagrams.


14. explain the common comparisons used in the WHERE clause of choose statement.


15. elaborate SQL Data Manipulation Commands? explain briefly with examples.


16.Write short notes on procedural languages.


17. Distinguish ranging from Horizontal and Vertical Partitioning.


18. Write short notes on object oriented databases.


19. explain briefly about Microsoft COM and CORBA.


PART C - (4 x 10 = 40 marks)

ans any 4 ques.. All ques. carry equal marks.

every ans should not exceed 500 words.

20. discuss about different Database Components with a neat
diagram.


21. define in detail, queries with Multiple Tables with examples.


22. discuss about effective design of Reports and Forms.


23. define in detail, Basic Report kinds with examples.


24. discuss about Data Storage Methods.


25. define in detail, Database Security and Privacy.

Earning:   Approval pending.