DISTANCE EDUCATION
B.Sc. (CS)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2016.
RDBMS
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. What is a DBMS? Describe the advantages of
DBMS?
Explain the manipulative capabilities of database
scheme.
2. Explain the concepts of relational model.
Explain in detail about data manipulation facilities.
3. Explain in detail with neat sketch of Oracle architecture.
4. Explain all the set operations in Oracle with suitable
SQL query.
5. Describe table definition? Give example.
Explain Oracle database objects.
6. Explain ORACLE queries working with NULL
values in detail. Give example.
Explain subqueries in ORACLE. Give example.
Sub. Code
35
DE-3405
2
hp-ap1
7. Discuss about embedded SQL.
Describe the benefits of Oracle.
8. Write short notes on the following
Schema and subschema
Relational model: Mapping operation
Distinct value in SQL
Oracle query using expressions.