B.Sc-B.Sc Information Technology RDBMS(Alagappa University - Directorate of Distance Education-2012)

DISTANCE EDUCATION
B.Sc.(I.T)/ B.Sc.(I.T)(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 advantages of DBMS. (8)
(b) Explain the database schema. (12)
2. (a) Explain the basic concepts of relational model. (8)
(b) What do you mean by data control facilities?
Explain. (12)
3. (a) Write a note on client/ server system. (8)
(b) Write a note on Oracle users. (6)
(c) Explain the benefits of Oracle. (6)
4. (a) Explain DML with examples. (12)
(b) Explain about NULL values in detail. (8)
5. (a) Create a database for a college system. (8)
(b) Explain how can you define a table and drop a
table. (12)
6. (a) Describe the data control facilities. (10)
(b) Discuss about different database user interface. (10)
7. (a) Explain the architecture of Oracle. (10)
(b) Explain the Oracle logical structure. (10)
8. (a) Explain table join with examples. (12)
(b) Explain union with examples. (8)

Earning:  ₹ 3.50/-