DISTANCE EDUCATION
B.Sc. (Computer Science)/B.Sc. (CS)(Lateral) DEGREE
EXAMINATION, DECEMBER 2017.
RDBMS
(2007 Onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
x 20 100)
1. What are the advantages of DBMS over File
Processing system?
Discuss on manipulative capabilities of database
schema.
2. Explain the following with respect to Relational Model:-
Mapping operation.
Data manipulation facilities.
3. Discuss on various types of databases using oracle.

Discuss about relational database properties.
4. Describe the data access SQL commands and DML
commands.
Write queries for selecting distinct values and using
sub queries in SQL.
Sub. Code
35
DE-2521
2
Sp 6
5. How will you describe table definitions? Discuss
with example.
How is table modified and renamed? Explain with
examples.
6. Write queries for using expressions and working
with Null values in SQL.
How will you join multiple tables in a query?
Explain with examples.
7. How is table created? Explain with examples.
Discuss on Embedded SQL.
8. Explain schema and subschema in detail.
Describe the Data Control facilities in Relational
Model.