DISTANCE EDUCATION
M.Sc. (Software Engineering) Years Integrated) DEGREE
EXAMINATION, DECEMBER 2017.
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time Three hours Maximum 100 marks
PART A — × 8 40 marks)
Answer any FIVE of the following questions.
1. Explain briefly about the Schema and Subschema in
DBMS.
2. Explain the two kinds of Data Independence.
3. Write the Merits and Demerits of using relational
databases.
4. Write short notes on concept of relation model.
5. Mention some benefits of using Oracle as database.
6. Explain the important factor while evaluating your
system's level of CPU utilization.
7. Explain briefly the data manipulation language
statements.
8. How to create database links to access data and schema
objects in a distributed database system?
Sub. Code
25
DE-3037
2
WS 20
SECTION B — × 15 60 marks)
Answer any FOUR questions.
9. Explain with neat illustration about the three level
architecture of DBMS.
10. Discuss briefly about the relational database model with
suitable example.
11. Discuss in detail about the data control facilities in
DBMS with example.
12. Give the details of the following keys
Super key
Candidate key
Primary key
Foreign key.
13. Explain briefly about joining multiple tables in a query.
14. Write short notes on the following
Modifying tables
Renaming tables.
Copying another table.
Dropping a table.
15. Discuss in detail about Embedded SQL commands and its
uses.
————————