DISTANCE EDUCATION
M.Sc. (Software Engineering) 5 Years Integrated DEGREE
EXAMINATION, MAY 2018.
RELATIONAL DATABASE MANAGEMENT SYSTEM
Time Three hours Maximum 100 marks
SECTION A — x 8 40 marks)
Answer any FIVE questions.
1. How DBMS in better than file management system?
2. Describe the different kinds of mapping operations.
3. Give an overview of oracle architecture and write the
benefits of oracle.
4. What are the aggregate functions offered by SQL and
explain.
5. How can you create and modify a table?
6. What is candidate key and composite key? Also write the
differences between primary key and foreign key.
7. Explain the concept of relational model.
8. Explain any four embedded SQL statements.
SECTION B — × 15 60 marks)
Answer any FOUR questions.
9. What are the possible schemas that we can have in
database systems? Explain them.
10. Describe the data manipulation facilities with examples.
Sub. Code
25
DE-4149
11. Explain the different types of databases.
12. List out the set operations available in SQL and explain
them.
13. With an example, explain how can you copy and rename a
table.
14. Explain the client/server system and write the properties
of relational database.
15. Explain how can you work with NULL values.