Alagappa University 2007 B.C.A Computer Application RDBM AND ORACLE - Question Paper

DISTANCE EDUCATION
B.C.A. DEGREE EXAMINATION, DECEMBER 2007.
RDBM AND ORACLE
(Upto 2002)
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
1. (a) What are the advantages of DBMS?
(b) Discuss about different user interfaces.
2. (a) What is relation? discuss different concepts in Relational model.
(b) Explain about different mapping operations with suitable examples.
3. (a) Explain the client/server architecture of ORACLE.
(b) Discuss about the structure of Oracle processes and physical files.
4. (a) What are DML commands? discuss every with an example.
(b) Explain choose query with an example for joining multiple tables, with sub queries.
5. (a) What is role, privilege and sequences in Oracle? discuss every with an example.
(b) What are commands used to replace a structure of a table? discuss every with an example.
6. (a) What is the need for Oracle precompiler and discuss embedded SQL with an example.
(b) Explain about Oracle System Tables, Users and Logical Structures.
7. (a) Discuss about elaborate benefits if oracle is used as RDBMS in an organization.
(b) Explain about schema and sub-schema with suitable examples.
8. Write short notes on :
(a) Table definitions
(b) Data control facilities
(c) Working NULL values
(d) Oracle Network.
————————

Earning:   Approval pending.