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.