DISTANCE EDUCATION
B.Sc. (CS)/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. Define DBMS. Describe in detail about the various
features of Database and advantages of using
DBMS.
What are the various operations that can be
performed in a Database? Explain.
2. What is Relational model? Discuss in detail about
the various concepts used in relational Model.
Write a note on various mapping operations that
can be performed in a database.
3. Explain in detail about the various types of
databases used in oracle and write a note on
Various properties of relational databases.
Discuss in detail about logical structure in oracle.(10)
4. What are the various SQL Commands used to
access data in oracle? Explain.
Describe in detail about the various elements of
SQL language.
Sub. Code
35
DE-218
2
Ws 11
5. Explain in detail about the various form of using
select query in oracle with suitable examples for
each of them.
Give a note on various elements of SQL Languages
by giving corresponding examples for each of the
elements.
6. How the user can create and alter a table in oracle?

Describe the use of sub queries in oracle with a
relevant examples.
7. What are the various types of privileges that are
grant by the administrator to users? Explain.
Discuss in detail about the various form of revoke
statement in oracle with examples.
8. Write a detailed note on oracle precompilers.
Explain how the user can create indexes in oracle
with a suitable example.