Kuvempu University 2011 M.Sc Information Technology First Semester .,(IT) ember/ember Distance Education RDBMS - Question Paper

MSIT-14

Time: 3hrs, Max Marks: 100

ans all ques. from part-A
ans any 5 full ques. from part-B

Part-A

1.Name any 4 applications of database. (4)
2.How many levels are there in data abstraction? Name every of them. (3)
3.With an example briefly discuss the various JOIN operators. (3)
4.What is view in SQL? discuss in brief. (3)
5.List the properties of transaction. (4)
6.Define data-catching (2)
7.Write a note on ARIES recovery. (3)
8.Write a note on digital signature. ( 3)


Part-B
1. a)Define data model. discuss any 2 data models. (8)
b)Briefly discuss the function of DBA. (7)

2. a)Briefly discuss the architecture of database design process. (8)
b)Define and discuss various kinds of keys. (7)

3. a)List a 12 rules of Dr.codds. (10)
b)Write a note on relational model constraint. (5)

4. a)What are the basic constraint in SQL? (7)
b)What are the aggregate functions in SQL? discuss with example. (8)

5. a)What are the additional features of SQL? discuss in brief. (8)
b)Briefly discuss BCNF & DKNF. (7)

6. a)Explain problems of transaction with an example. (8)
b)Briefly discuss the issues of scheduling. (7)

7. a) Write a note on the following: (2*4=8)
1.Recoverability
2.Serializability
b)Explain any 2 recovery methods (7)

8. a)With an example discuss various update method. (8)
b)Explain roll based access control. (7)

Earning:   Approval pending.