DISTANCE EDUCATION
M.Sc. (Computer Science) DEGREE EXAMINATION,
MAY 2016.
DATABASE MANAGEMENT SYSTEMS
(2007 onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 3 30 marks)
Answer ALL questions.
1. Give the usage of primary key foreign key
concatenated key.
2. What is the need for data migration?
3. Mention the concepts of Relational Model.
4. Name the different mappings allowed in a Relational
model.
5. Define client server systems.
6. Give the purpose of Network system tables.
7. Give an example for a simple query.
8. Define union.
9. What is meant by a table?
10. Give the purpose of oracle pre compiler.
Sub. Code
15
DE-3677
2
Ws2
SECTION B — 10 40 marks)
Answer any FOUR questions.
11. Mention the advantages of Data Base Management
System.
12. Explain the concept of schema and subschema.
13. Discuss the semantic issues related in relational model.
14. List the properties of relational database.
15. How to use sub queries in oracle? Explain with examples.
16. Discuss on the salient features of Embedded SQL.
SECTION C — 15 30 marks)
Answer any TWO questions.
17. Explain the following in a relational model
Data Definition facilities
Data control facilities.
18. Describe the architecture for the oracle database.
19. How to do the following:
Creating a table
Modifying a table
Renaming a table
Copying from one table to another
Dropping a table.