Client Server Computing with Oracle

5042/DC5 October 2007
Paper V - Client/Server Computing with Oracle
Time: Three Hours

Answer All Questions

Part A - (20x2 = 40 Marks)

1. Define Relational Model
2. What are attributes?
3. Define: Concurrency.
4. Define: DBMS.
5. What is meant by client?
6. Define: Object Oriented Programming.
7. Give the general syntax of INSERT command.
8. What is SQL?
9. Write a note on commit Command.
10. Define: DDL.
11. What are variables?
12. Define: function.
13. What are triggers?
14. List the functions of DBA.
    
15. Define: Database Back up.
16. Define: Domain.
17. What is meant by Client/Server model?
18. Define: Role
19. What are Blocks in PL/SQL?
20. What is DBA?
    
    Part B - (5x12=60 Marks)
    
    
21. (a) What are the advantages and disadvantages of Relationl Model? Discuss briefly.
    or (b) Discuss about Database security and Data integrity.
22. (a) Explain the benifits and pitfalls of client/server computing
    or (b) write a short notes on client application interface.
23. (a) Explain the general syntax of the following statements in SQL with examples.
    (i) Select
    (ii) Update
    (iii) Delete
    or (b) Describe in detail, the use of any TEN nemeric functions with examples.
24. (a) Explain the different loop structures in PL/SQL with examples.
    or (b) Write a PL/SQL statement to find the area and circumference of a circle.
25. (a) Describe the general syntax of 'create procedur' command with example.
    or (b) write short notes on Server Manager Interface.
    

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.