Madurai Kamraj University (MKU) 2006 B.C.A Computer Application -2 CLIENT/SERVER COMPUTING WITH ORACLE - Question Paper

Time: 3 hours Maximum: 100 marks
PART A ans any 6 ques.. (6 x five =30 marks)

1. What is data integrity?
2. elaborate the various kinds of users?
3. explain about the pitfalls of Client/Server technology.
4. Write down the characteristics of Client/Server Model.
5. discuss Data Control commands.
6. What is a trigger, discuss its various types?
7. Write any 2 DML command with examples.
8. How the errors can be trapped?
9. elaborate the functions of DBA?
10. elaborate the advantages of PL/SQL over SQL?

PART B ans any 4 ques.. (4 x 10 =40 marks)

11. elaborate the objectives of database system?
12. define Concurrency Control System.
13. explain the benefits of Client/Server Technology.
14. discuss about DDL with example.
15. elaborate the control statements available in PL/SQL?
16. elaborate the measures to be taken so as to protect database file?

PARTC ans any 2 ques.. (2 x 15 =30 marks)

17. Write down the formal definition of relational model.
18.(a) Differentiate local and global variable. (b) elaborate the data kinds available
in PL/SQL?
19. discuss how the database administrator planning for database installation.

Earning:   Approval pending.