Post Graduate Diploma Computer Application ALAGAPPA UNIVERSITY - DISTANCE EDUCATION P.G.D.C.A. (Non-Semester) EXAMINATION, MAY 2010. RDBMS AND ORACLE Question paper

RDBMS AND ORACLE (2000 onwards)

Time : Three hours
Maximum : 100 marks

Answer any FIVE questions.
All questions carry equal marks.

1. (a) Define DBMS. Explain different user interfaces.(10)
(b) Explain the Internal architecture of a Database system with a neat diagram.(10)

2. (a) Explain Navigational problems and efficiency considerations of Relational Model.(10)
(b) Discuss the mapping operation with examples.(10)

3. (a) Explain Data Definition facilities in Relational Model.(10)
(b) Explain the integrity constraint features of SQL in data control facilities.(10)

4. (a) Explain the Client/Server computing model with neat diagram.(10)
(b) Describe the Oracle data base architecture. (10)

5. (a) Explain about DDL with examples.(10)
(b) Explain in detail on various String functions that are used in Oracle.(10)

6. (a) Explain about NULL values with examples.(10)
(b) How can you merge tables in Oracle? Explain with examples.(10)

7. (a) Explain about VIEW tables and its uses.(10)
(b) Explain about set operators in Oracle.(10)

8. Write short notes on following :
(a) Grant privilege.(10)
(b) Precompiler.(10)