B.Sc-B.Sc Computer Science RDBMS(Alagappa University - Directorate of Distance Education-2012)

DISTANCE EDUCATION
B.Sc. (C.S.)/B.Sc. (C.S.) (Lateral) DEGREE EXAMINATION, MAY 2012.
RDBMS
(2007 onwards)
Time : Three hours Maximum : 100 marks
Answer any FIVE questions.
All questions carry equal marks.
(5 × 20 = 100)
1. (a) Explain the concept of schema and subschema. (10)
(b) Discuss in detail about different user interfaces. (10)
2. (a) What is meant by data independence? How to achieve it? (10)
(b) Explain the data definition facilities. (10)
3. (a) Discuss about the mapping operation. (10)
(b) Explain the oracle architecture in detail. (10)
4. (a) How can you join multiple tables through queries. (10)
(b) Discuss the elements of SQL language. (10)
5. (a) How a table is created and modified? (10)
(b) Discuss about the languages supported by oracle precompiler. (10)
6. (a) Discuss the advantages of database management system. (10)
(b) Explain the concepts of relational model. (10)
7. (a) Explain about the types of databases. (10)
(b) Discuss about the basic query in oracle. (10)
8. (a) Discuss about embedded SQL statements. (10)
(b) What are the semantic issues that arise in relational model? Explain. (10)

Earning:  ₹ 3.95/-