Download Model question papers & previous years question papers
|
Posted By: pradha s Member Level: Gold Posted Date: 27 Jun 2008
|
2007 Alagappa University P.G.D.C.A Question paper
|
|
|
DISTANCE EDUCATION
P.G.D.C.A (N.S) EXAMINATION,
DECEMBER 2007.
RDBMS AND ORACLE
(2000 onwards)
Time : Three hours Maximum : 100 marks
Answer any FIVE questions.
All questions 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 explain the concept of data normalization. (10)
5. (a) Explain the various Relation Algebra operations in detail. (10)
(b) Write short notes on database triggers. (10)
6. Explain the following :
(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 following :
(a) Embedded SQL (5)
(b) Working with NULL values (5)
(c) Database Objects (5)
(d) Correlated sub–query (5)
——————
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and
make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.