Exam Details
Subject | database management systems | |
Paper | ||
Exam / Course | m.sc. computer science | |
Department | ||
Organization | Alagappa University Distance Education | |
Position | ||
Exam Date | May, 2016 | |
City, State | tamil nadu, karaikudi |
Question Paper
DISTANCE EDUCATION
M.Sc. (Computer Science) DEGREE EXAMINATION,
MAY 2016.
DATABASE MANAGEMENT SYSTEMS
(2007 onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 3 30 marks)
Answer ALL questions.
1. Give the usage of primary key foreign key
concatenated key.
2. What is the need for data migration?
3. Mention the concepts of Relational Model.
4. Name the different mappings allowed in a Relational
model.
5. Define client server systems.
6. Give the purpose of Network system tables.
7. Give an example for a simple query.
8. Define union.
9. What is meant by a table?
10. Give the purpose of oracle pre compiler.
Sub. Code
15
DE-3677
2
Ws2
SECTION B — 10 40 marks)
Answer any FOUR questions.
11. Mention the advantages of Data Base Management
System.
12. Explain the concept of schema and subschema.
13. Discuss the semantic issues related in relational model.
14. List the properties of relational database.
15. How to use sub queries in oracle? Explain with examples.
16. Discuss on the salient features of Embedded SQL.
SECTION C — 15 30 marks)
Answer any TWO questions.
17. Explain the following in a relational model
Data Definition facilities
Data control facilities.
18. Describe the architecture for the oracle database.
19. How to do the following:
Creating a table
Modifying a table
Renaming a table
Copying from one table to another
Dropping a table.
M.Sc. (Computer Science) DEGREE EXAMINATION,
MAY 2016.
DATABASE MANAGEMENT SYSTEMS
(2007 onwards)
Time Three hours Maximum 100 marks
SECTION A — (10 3 30 marks)
Answer ALL questions.
1. Give the usage of primary key foreign key
concatenated key.
2. What is the need for data migration?
3. Mention the concepts of Relational Model.
4. Name the different mappings allowed in a Relational
model.
5. Define client server systems.
6. Give the purpose of Network system tables.
7. Give an example for a simple query.
8. Define union.
9. What is meant by a table?
10. Give the purpose of oracle pre compiler.
Sub. Code
15
DE-3677
2
Ws2
SECTION B — 10 40 marks)
Answer any FOUR questions.
11. Mention the advantages of Data Base Management
System.
12. Explain the concept of schema and subschema.
13. Discuss the semantic issues related in relational model.
14. List the properties of relational database.
15. How to use sub queries in oracle? Explain with examples.
16. Discuss on the salient features of Embedded SQL.
SECTION C — 15 30 marks)
Answer any TWO questions.
17. Explain the following in a relational model
Data Definition facilities
Data control facilities.
18. Describe the architecture for the oracle database.
19. How to do the following:
Creating a table
Modifying a table
Renaming a table
Copying from one table to another
Dropping a table.
Other Question Papers
Subjects
- c++ and data structures – lab i
- computer architecture
- computer networks
- data structures using c++
- database management systems
- image processing and analysis
- internet programming — lab
- internet programming and web design
- mathematical foundation of computer science
- operating systems
- software engineering
- visual programming
- visual programming – lab