DISTANCE EDUCATION
M.Sc. Years Integrated) DEGREE EXAMINATION,
MAY 2017.
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time Three hours Maximum 100 marks
SECTION A — 8 40 marks)
Answer any FIVE questions.
All questions carry equal marks.
1. Discuss the features of database management system
over conventional techniques for handling large data.
2. Write short notes on Data control facilities with suitable
examples.
3. Give brief notes on relational database properties.
4. Briefly explain
Query within query.
UNION operator.
5. Write SQL query for the following.
Use the CREATE TABLE command to create all the
tables in the 'Book Database'.
Branch Table Branch-no, Branch-name, Branchlocation,
No-of-employees.
Publisher table Publisher-code, Publisher-name,
Publisher-city, Publisher-state.
Differentiate between DROP TABLE command and
DELETE command.
Sub. Code
25
DE-735
2
wk11
6. Write short notes on evaluation of expressions in SQL.
7. Give a brief note on database schema.
8. Briefly explain network system tables.
SECTION B — 15 60 marks)
Answer any FOUR questions.
9. Explain in detail
Schema and subschema.
Manipulative capabilities of database.
10. Discuss in detail any two issues encountered in the
relational model.
11. Describe the oracle database architecture.
12. Write in detail the various DML commands with
appropriate examples.
13. Give a brief note on embedded SQL statements.
14. Explain in detail the various types of outer joins with
suitable examples.
15. Write short notes on logical comparison.