Exam Details
| Subject | elective – relational database management | |
| Paper | ||
| Exam / Course | m.sc. computer science | |
| Department | ||
| Organization | alagappa university | |
| Position | ||
| Exam Date | November, 2017 | |
| City, State | tamil nadu, karaikudi |
Question Paper
M.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Second Semester
Computer Science
Elective RELATIONAL DATABASE MANAGEMENT
SYSTEMS
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is a Data Model?
2. Mention any four secondary storage devices.
3. Define the term index.
4. What is the purpose of file Organization?
5. Write any two characteristics of SQL.
6. State the need for Normal Forms.
7. Define Cryptosystem.
8. What do you mean by Data Base Recovery?
9. How to define a Query in Oracle?
10. Mention the need for copying another table.
Sub. Code
4MCE2E5
AFF-4959
2
Wk 11
Part B x 5 25)
Answer all questions choosing either or
11. Briefly explain about E-R model with neat diagram.
Or
How to create and manipulate indexed sequential
organization?
12. Explain the organization and usage of secondary
indexes.
Or
Discuss File Organization based on dynamic
hashing with deferred splitting.
13. Explain the fundamental operations in Relational
Algebra with examples.
Or
What are the design procedures in Relational Data
Base design? Explain.
14. Write short note on Access Control.
Or
What are the various Concurrency control
techniques? Explain.
15. How will you join multiple tables in a query?
Explain.
Or
Explain how to describe and modifying tables.
AFF-4959
3
Wk 11
Part C x 10 30)
Answer any three questions.
16. Write short notes on
Sequential File Organization.
Hashing.
17. Explain in detail about the Secondary indexes with
respect to B-Tree.
18. Describe about the Functional dependency and Logical
Implication of Dependency.
19. Explain about the Data Base recovery in detail.
20. Discuss in detail about the Data Access SQL commands
and DML commands.
————————
Second Semester
Computer Science
Elective RELATIONAL DATABASE MANAGEMENT
SYSTEMS
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is a Data Model?
2. Mention any four secondary storage devices.
3. Define the term index.
4. What is the purpose of file Organization?
5. Write any two characteristics of SQL.
6. State the need for Normal Forms.
7. Define Cryptosystem.
8. What do you mean by Data Base Recovery?
9. How to define a Query in Oracle?
10. Mention the need for copying another table.
Sub. Code
4MCE2E5
AFF-4959
2
Wk 11
Part B x 5 25)
Answer all questions choosing either or
11. Briefly explain about E-R model with neat diagram.
Or
How to create and manipulate indexed sequential
organization?
12. Explain the organization and usage of secondary
indexes.
Or
Discuss File Organization based on dynamic
hashing with deferred splitting.
13. Explain the fundamental operations in Relational
Algebra with examples.
Or
What are the design procedures in Relational Data
Base design? Explain.
14. Write short note on Access Control.
Or
What are the various Concurrency control
techniques? Explain.
15. How will you join multiple tables in a query?
Explain.
Or
Explain how to describe and modifying tables.
AFF-4959
3
Wk 11
Part C x 10 30)
Answer any three questions.
16. Write short notes on
Sequential File Organization.
Hashing.
17. Explain in detail about the Secondary indexes with
respect to B-Tree.
18. Describe about the Functional dependency and Logical
Implication of Dependency.
19. Explain about the Data Base recovery in detail.
20. Discuss in detail about the Data Access SQL commands
and DML commands.
————————
Other Question Papers
Subjects
- .net technology
- advanced database systems
- advanced java programming
- advanced operating systems
- applied mathematics for computer science
- cloud computing
- communication and employability skills
- compiler design
- computer communication networks
- computer system architecture
- cryptography and network security
- data communication networks
- data mining and data warehousing
- data mining and warehousing
- data structures and algorithms
- elective : cloud computing
- elective – computer graphics
- elective – relational database management
- elective — digital image processing
- elective — mobile computing
- elective — object oriented analysis and design
- elective — software engineering
- elective — wap and xml
- elective i — software project management
- elective iii — soft computing
- elective: multimedia system
- elective: soft computing
- internet and java programming
- multimedia and its applications (elective – ii)
- network security
- operating system
- principles of compiler design
- programming in php
- web technology