DISTANCE EDUCATION
M.Sc. (Computer Science) DEGREE EXAMINATION,
MAY 2017
DATABASE MANAGEMENT SYSTEMS
(2007 Onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 3 30 marks)
Answer any SIX questions.Answer ALL questions.
1. What is a database management system?
2. List the features of DBMS.
3. What is meant by DML?
4. What is meant by data control?
5. Explain the efficiency of the relational model.
6. What is client/server system?
7. What is the purpose of NULL value?
8. What are database objects?
9. How will you copy a table in Oracle? Give an example.
10. What is embedded SQL?
Sub. Code
15
DE-490
2
WS 20
SECTION B — 10 40 marks)
Answer any FOUR questions.
11. Explain various user interfaces in DBMS.
12. Discuss the semantic issues in relational model.
13. Discuss about Oracle system tables.
14. Explain the benefits of Oracle.
15. How will you join tables? Explain with an example.
16. How will you create a table? Explain with an example.
SECTION C — 15 30 marks)
Answer any TWO questions.
17. Discuss the facilities available in relational model.
18. Explain the Oracle architecture and its processes in
detail.
19. How will you drop tables and other object in Oracle?
Explain in detail with example.