Client Server Computing with Oracle

Paper V - CLIENT/SERVER COMPUTING WITH ORACLE 7 May 2005

Time: Three hours Maximum: 100 marks
PART A Answer ALL questions (20 x 2 =40 marks)

1. Define middleware.
2. What is an entity?
3. What are 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. Define messaging and queuing.
8. State any two DDL commands.
9. Mention the character data types in oracle.
10. What are the three types of exports?
11. What is meant by savepoint?
12. Write short notes on client application interface.
13. Define a procedure.
14. What are the parts of a PL/SQL block?
15. Define preemptive and non-preemptive threads.
16. Distinguish between nested tables and Varray.
17. What do you mean by cold and hot physical backups?
18. Define data security.
19. Give the syntax of grant statement with an example.
20. What is a constraint?

PART B Answer ALL the questions (5 x 12 =60 marks)

21. (a) Explain briefly the features of server machines.

Or

Explain 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) Discuss the administrative steps in building a database.
Or
(b) Explain in detail the advantages of table partitioning.

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

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