#2
| |||
| |||
Re: Kuvempu University Question Papers MSC IT
Here I am giving you question paper of MSC IT of Kuvempu University as below:- MSIT-14 Time: 3hrs, Max Marks: 100 Answer all question from part-A Answer any Five full question from part-B Part-A 1.Name any four applications of database. (4) 2.How many levels are there in data abstraction? Name each of them. (3) 3.With an example briefly explain the different JOIN operators. (3) 4.What is view in SQL? Explain 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. Explain any two data models. (8) b)Briefly explain the function of DBA. (7) 2. a)Briefly explain the architecture of database design process. (8) b)Define and explain different types 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? Explain with example. (8) 5. a)What are the additional features of SQL? Explain in brief. (8) b)Briefly explain BCNF & DKNF. (7) 6. a)Explain issues of transaction with an example. (8) b)Briefly explain the problems of scheduling. (7) 7. a) Write a note on the following: (2*4=8) 1.Recoverability 2.Serializability b)Explain any two recovery methods (7) 8. a)With an example explain different update method. (8) b)Explain roll based access control. (7) |
|