Amrita Vishwa Vidyapeetham 2007 Post Graduate Diploma Computer Application PGDCA(NS) ORACLE PCA6104 - Question Paper

PGDCA(NS) ORACLE PCA6104 May 2007

Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
1. (a) Describe the structure of overall database system with a neat diagram. (10)
(b) What are the objectives of database system? (10)
2. Explain the CODD's rules that have to be followed for a DBMS to be relational. (20)
3. (a) Describe the structure of relational databases. (10)
(b) Write short notes on : Object Oriented Relational Database. (10)
4. (a) What are the advantages and disadvantages of client/server technology? (10)
(b) Write and discuss the concept of data normalization. (10)
5. (a) Explain the different Relation Algebra operations in detail. (10)
(b) Write short notes on database triggers. (10)
6. Explain the subsequent :
(a) Consistency (5)
(b) Data Dictionary (5)
(c) Referential Integrity (5)
(d) Backup and Recovery (5)
7. (a) Explain about DML with examples. (10)
(b) Explain about TCL (transaction control language commands) (10)
8. Write short notes on subsequent :
(a) Embedded SQL (5)
(b) Working with NULL values (5)
(c) Database Objects (5)
(d) Correlated sub–query (5)

Earning:   Approval pending.