Madurai Kamraj University (MKU) 2005 Post Graduate Diploma Computer Application V - CLIENT/SERVER COMPUTING WITH ORACLE 7 - Question Paper

Time: 3 hours Maximum: 100 marks
PART A ans ALL ques. (20 x two =40 marks)

1. describe middleware.
2. What is an entity?
3. elaborate the components of an open system environment?
4. What is meant by ACID test?
5. What do you mean by bridges?
6. Write down the factors that determine the performance of WAN?
7. describe messaging and queuing.
8. State any 2 DDL commands.
9. Mention the character data kinds in oracle.
10. elaborate the 3 kinds of exports?
11. What is meant by savepoint?
12. Write short notes on client application interface.
13. describe a procedure.
14. elaborate the parts of a PL/SQL block?
15. describe preemptive and non-preemptive threads.
16. Distinguish ranging from nested tables and Varray.
17. What do you mean by cold and hot physical backups?
18. describe data security.
19. provide the syntax of grant statement with an example.
20. What is a constraint?

PART B ans ALL the ques. (5 x 12 =60 marks)

21. (a) discuss briefly the features of server machines. Or discuss the following:
(i) Consistency (ii) Robustness (iii) Transaction (iv) Recovery

22. (a) List down the merits and demerits of client/server model. Or Write short
notes on client application.

23. (a) explain the administrative steps in building a database. Or (b) discuss in
detail the advantages of table partitioning.

24 (a) Write short notes on database triggers. What is database tuning meant by?
(b) discuss the object tables and selecting values from object tables with suitable
examples.

25. (a) Illustrate networking concepts in the oracle with examples, Or (b) explain in
detail the transaction log management and threshold manager with respect to backup and
recovery.

Earning:   Approval pending.