DISTANCE EDUCATION
M.Sc. DEGREE EXAMINATION, MAY 2018.
DATABASE MANAGEMENT SYSTEMS
(2007 onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 x 3 30 marks)
Answer ALL questions.
1. Distinguish physical schema from logical schema.
2. Write about concurrent access anomalies of database
systems.
3. With an example, define the union operation used for
relational data.
4. Define any three basic domain types of SQL.
5. Differentiate single valued attribute from multivalued
attribute.
6. Define the following oracle SQL extensions
Upsert
Multitable inserts.
7. What is meant by hash partitioning?
8. What is a log writer related to oracle server?
9. With syntax, define the assertion condition used in SQL.
10. What are the constraints allowed to use on a single
relation while creating a table?
Sub. Code
15
DE-3893
2
Ws9
SECTION B — x 10 40 marks)
Answer any FOUR questions.
11. Discuss on manipulative capabilities and guidelines of
database schemes.
12. Give a note on database schema and keys used in
relational database.
13. What are semantic issues, navigation and efficiency of
relational model? Explain.
14. Narrate the logical structure and network system tables
of oracle database.
15. Discuss the basic queries using expressions that are used
in Oracle.
16. List out and explain any three embedded SQL statements
with examples.
SECTION C — × 15 30 marks)
Answer any TWO questions.
17. Give a detailed description on structure of relational
databases with necessary syntax and examples.
18. Write notes on the following related to oracle
Types of databases.
Benefits of oracle.
Relational database properties.
19. How do tables are created in oracle? Also explain the
procedure of modifying renaming, copying and dropping
of table with suitable examples.
————————