Tamil Nadu Open University (TNOU) 2009-2nd Sem M.C.A - - Advanced RDBMS -- IX - Question Paper
M.C.A. DEGREE EXAMINATION, 2009
( 2nd SEMESTER )
( PAPER - IX )
221. ADVANCED RDBMS
( New Regulations )
December ] [ Time : three Hours
Maximum : 100 Marks
part - A (8 ×5 = 40)
ans any 8 ques..
All ques. carry equal marks.
1. Write about info universal server.
2. provide a note on object database conceptual design.
3. explain the role of info systems in organizations.
4. provide a brief account of Boyce - Codd normal form.
5. Write about database languages and interfaces.
6. explain SQL data definition and its data kinds.
7. List and discuss database security problems.
8. Elucidate concurrency control based on time-stamp ordering.
9. Compare and contrast temporal database with spatial database.
10. Write the different kinds of distributed database systems. Also, discuss.
part - B (3 ×20 = 60)
ans any 3 ques..
All ques. carry equal marks.
11. With suitable illustration, discuss the object definition language in detail.
12. discuss the normal forms based on primary keys . Illustrate.
13. provide a neat description of tuple relational calculus.
14. define 2 phase locking techniques for concurrency control.
15. discuss the query processing methods of distributed databases.
Register Number:
Name of the Candidate:
69 17 M.C.A. DEGREE EXAMINATION, 2009
(SECOND SEMESTER)
( PAPER - IX )
( New Regulations )
December ] [ Time : 3 Hours
Maximum : 100 Marks
SECTION - A (8 x5 = 40)
Answer any EIGHT questions.
All questions carry equal marks.
1. Write about information unversal server.
2. Give a note on object database conceptual design.
3. Discuss the role of information systems in organizations.
4. Give a brief account of Boyce - Codd normal form.
5. Write about database languages and interfaces.
6. Discuss SQL data definition and its data types.
7. List and explain database secuirty issues.
8. Elucidate concurrency control based on time-stamp ordering.
9. Compare and contrast temporal database with spatial database.
10. Write the various types of distributed database systems. Also, explain.
SECTION - B (3 x20 = 60)
Answer any THREE questions.
All questions carry equal marks.
11. With suitable illustration, explain the object definition language in detail.
12. Explain the normal forms based on primary keys. Illustrate.
13. Give a neat description of tuple relational calculus.
14. Describe two phase locking techniques for concurrency control.
15. Explain the query processing methods of distributed databases.
|
Attachment: |
| Earning: Approval pending. |
