DISTANCE EDUCATION
M.Sc. Years Integrated) DEGREE EXAMINATION,
MAY 2016.
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time Three hours Maximum 100 marks
SECTION A — 8 40 marks)
Answer any FIVE of the following questions.
1. What is a Database Management System? Mention its
features.
2. What is the difference between Schema, Subschema and
Instances?
3. Write the advantages and disadvantages of using
relational databases.
4. Write short notes on Entity and Referential Integrity.
5. Mention some of the Databases types.
6. Write the importance of DML statements used for
managing data within schema objects.
7. What are the difference between DDL, DML and DCL
commands?
8. Explain briefly about Embedded SQL and its features.
Sub. Code
25
DE-3913
2
SER
SECTION B — 15 60 marks)
Answer any FOUR questions.
9. Explain the following
Meta Data
Schema and Subschema in Data Base Management
System
Data Independence.
10. Discuss the following
Semantic issues in Relation Model
Navigation and Efficiency in Relation Model
Write the purpose of Optical Storage.
11. Describe the Oracle Architecture with neat diagram.
12. Detail on the following relation database concepts.
13. Write and explain the commands with their syntax to do
the following oracle queries
Date/Time related queries
Data dictionary queries.
14. Give details of the following
Modifying Tables
Renaming Tables
Copying another Table
Dropping a Table.
15. Explain briefly about Embedded SQL Commands and its
purposes.