DISTANCE EDUCATION
M.Sc. (Computer Science) DEGREE EXAMINATION,
DECEMBER 2017.
DATABASE MANAGEMENT SYSTEMS
(2007 Onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 x 3 30 marks)
Answer ALL questions.
1. What are physical level and logical level data
abstractions?
2. Define any three components of E-R diagram.
3. With an example, define the Cartesian product operation.
4. Define basic structure of an SQL expression.
5. What is a datalog program? Illustrate with a query.
6. Distinguish weak entity sets from strong entity sets.
7. Define Row triggers statement triggers.
8. List DML commands. Also write the syntax for any one
command.
9. Discuss briefly the concept of referential integrity.
10. Write the syntax of grant and revolve statement.
Sub. Code
15
DE-2793
2
Sp 1
SECTION B — × 10 40 marks)
Answer any FOUR questions.
11. Narrate the database languages. Also discuss its
features.
12. Write about database design in detail.
13. Compare and contrast data manipulation language with
data definition language.
14. List out data access SQL commands and explain any four
of it with syntax and example.
15. Elucidate the procedure of joining multiple tables
through a query, selecting district values with example
statements.
16. Give a note on embedded SQL and the languages that are
supported by oracle precompiler.
SECTION C — × 15 30 marks)
Answer any TWO questions.
17. With syntax and examples, explain any five fundamental
relational algebra operations.
18. Give the overview of oracle database with architectural
diagram.
19. Create a table for your class with necessary entities. Also
explain the procedure of inserting rows, modifying,
updating and manipulation of overall table with syntax
and examples.