M.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Second Semester
Information Technology
RELATIONAL DATABASE MANAGEMENT SYSTEM
(RDBMS)
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Define Entity.
2. What is meant by foreign key?
3. State the two types of calculus.
4. Define one-to-one relation.
5. Define SQL.
6. State the purpose of commit command.
7. Define atomicity.
8. What is meant by lock?
9. What are cluster indexes?
10. Define trees.
Sub. Code
4MIT2C2
AFF-4974
2
Wk 11
Part B x 5 25)
Answer all questions.
11. Write about DDL.
Or
Write a note on database administrator and user.
12. Write briefly about predicate calculus.
Or
Write a note on relation and aggregation.
13. Write a note on SQL tables and views.
Or
Give an example for SQL insert and select
command.
14. Write a note on multiple granularities.
Or
Write a note on log based recovery.
15. Write a note on indexes and performance tuning.
Or
Write a note on PL/SQL variables.
AFF-4974
3
Wk 11
Part C x 10 30)
Answer any three questions.
16. Write in detail about the fundamental concepts of Entity
Relationship Models.
17. Explain in detail about relational algebra.
18. Discuss all SQL DDL commands with example.
19. Discuss about implementation of atomicity and durability
20. Discuss in detail about file organization and indexing.
————————