B.C.A-B.C.A Computer Application RDBMS (Alagappa University - Directorate of Distance Education-2012)

DISTANCE EDUCATION
B.C.A/B.C.A (Lateral) DEGREE EXAMINATION, MAY 2012.
RDBMS
(2003 onwards)
Time : Three hours Maximum : 100 marks
Answer any FIVE questions.
All questions carry equal marks. (5 × 20 =100)
1. (a) Describe about different user interfaces. (10)
(b) Explain about schema and subschema in detail. (10)
2. (a) Explain the concepts of Relational Model. (10)
(b) Write about mapping operation. Give an example. (10)
3. (a) Discuss the benefite of oracle. (10)
(b) Explain the Logical structures in oracle with example. (10)
4. (a) Discuss about DML. (10)
(b) Discuss on the basic queries using expressions. Show that with examples. (10)
5. (a) Write SQL query to create an employee table with the fields emp no, name, designation, basic pay, DA, HRA. (12)
(b) Write SQL query to calculate the gross pay and net pay and display the employee details. (8)
6. Explain on how to create a table, modify a table, Rename a table, copying from another table and to drop the table with examples. (20)
7. (a) Write in about client/server system. (10)
(b) What is Database schema? Explain. (10)
8. (a) Write short notes on Table definitions. (10)
(b) Explain the elements of SQL Language. (10)

Earning:  ₹ 6.05/-