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

Paper V - CLIENT/SERVER COMPUTING WITH ORACLE seven May 2005
Time: 3 hours Maximum: 100 marks
PART A ans ALL the 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.Define a procedure.
13.What are the parts of a PUSQL block?
14.Define preemptive and non preemptive threads.
15. Distinguish ranging from nested tables and varray.
16. What do you mean by cold and hot physical backups?
17. describe data security.
18. provide the syntax of grant statement with an example.
19. What is a constraint?
20. What is meant by database tuning?
PART B (5 x 12 =60 marks)
21. (a) discuss briefly the features of server machines. Or (b) discuss the following: (i)
Consistency (ii) Robustness (iii) Transaction Recovery
22. (a) Write short notes on client application (ii) List down the merits and demerits of
client/server model. Or (b) discuss in detail the advantages of table Partitioning.
23. (a) (i) Write short notes on database triggers. (ii) Distinguish ranging from conventional
and direct path loading given by SQL* loader Or (b) discuss the object tables and
selecting values from object tables with suitable examples.
24. (a) Write short notes on: (i) View (iii) Pre-defined exceptions (ii) Bit map index Or
(b) explain the administrative steps in building a database.
25. a) Illustrate. with examples oracle the networking concepts Or (b) explain in detail
the transaction log management and threshold manager with respect to backup and
recovery.

Earning:   Approval pending.