Exam Details
| Subject | object oriented dbms | |
| Paper | ||
| Exam / Course | m.sc. information technology | |
| Department | ||
| Organization | Alagappa University Distance Education | |
| Position | ||
| Exam Date | May, 2016 | |
| City, State | tamil nadu, karaikudi |
Question Paper
DISTANCE EDUCATION
M.Sc. (Information Technology) DEGREE EXAMINATION,
MAY 2016.
OBJECT ORIENTED DBMS
(2002 onwards)
Time Three hours Maximum 100 marks
PART A — (10 3 30 marks)
Answer ALL questions.
1. Define database.
2. What is abstraction? Give an example.
3. What is meant by conceptual Data Base Design?
4. Define entities, attributes and entity sets.
5. What is the use of data definition language?
6. Write the form of a basic SQL Query.
7. Differentiate schema and subschema.
8. What is transitive dependency?
9. What are the objectives of database security?
10. What is the basic idea in encryption?
PART B — 10 40 marks)
Answer any FOUR questions.
11. Explain the advantages of DBMS.
12. Explain the features of unified modeling language.
Sub. Code
15
DE-3667
2
wk14
13. Explain the various aggregate operators in SQL.
14. Explain the problems caused by redundancy.
15. Explain with examples mandatory access control.
16. Explain the data model for XML.
PART C — × 15 30 marks)
Answer any TWO questions.
17. Elaborate on describing and storing data in a DBMS.
18. Explain in detail, the additional features of ER model.
19. Discuss on clustering and indexing with examples.
M.Sc. (Information Technology) DEGREE EXAMINATION,
MAY 2016.
OBJECT ORIENTED DBMS
(2002 onwards)
Time Three hours Maximum 100 marks
PART A — (10 3 30 marks)
Answer ALL questions.
1. Define database.
2. What is abstraction? Give an example.
3. What is meant by conceptual Data Base Design?
4. Define entities, attributes and entity sets.
5. What is the use of data definition language?
6. Write the form of a basic SQL Query.
7. Differentiate schema and subschema.
8. What is transitive dependency?
9. What are the objectives of database security?
10. What is the basic idea in encryption?
PART B — 10 40 marks)
Answer any FOUR questions.
11. Explain the advantages of DBMS.
12. Explain the features of unified modeling language.
Sub. Code
15
DE-3667
2
wk14
13. Explain the various aggregate operators in SQL.
14. Explain the problems caused by redundancy.
15. Explain with examples mandatory access control.
16. Explain the data model for XML.
PART C — × 15 30 marks)
Answer any TWO questions.
17. Elaborate on describing and storing data in a DBMS.
18. Explain in detail, the additional features of ER model.
19. Discuss on clustering and indexing with examples.
Other Question Papers
Subjects
- c++ laboratory
- computer networks
- data structures – laboratory
- data structures and algorithms
- internet programming – laboratory
- internet programming and web design
- multimedia applications
- object oriented dbms
- object oriented programming and c++
- operating systems
- principles of information technology
- software engineering
- visual programming
- visual programming – laboratory