DISTANCE EDUCATION
B.Sc. (IT)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2017.
RDBMS
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. State the differences between file system and
database system with its features.
Explain in detail about database schemas.
2. Discuss in detail about various keys used in
relational model with necessary illustrations.
State the concepts of Data Definition and Data
Control facilities with example.
3. With a neat diagram, explain the operations of
client/server system.
Write a short note on oracle users and logical
structures.
4. Explain in detail about DML commands with
necessary examples.
Write a short note on joining multiple tables and
selecting distinct values in SQL with example.
Sub. Code
35
DE-229
2
wk14
5. Explain the procedure to create a table with
primary key functions by providing suitable
example.
Write short notes on Embedded SQL statements.
6. Write a note on semantic issues in relational model.

Discuss the mapping operations in DBMS based
relational model.
7. Mention the types of databases and explain how the
relational model is different from network model.

Write a detailed account on overview of Oracle
Architecture.
8. Write a note on weak entity sets and strong entity
sets with examples.
Discuss the elements of SQL language.