Download Model question papers & previous years question papers
|
Posted Date: 23 May 2012 Posted By:: Surabhi Paul Member Level: Silver Points: 5 (Rs. 1)
|
2011 Kuvempu University M.Sc Information Technology First Semester M.sc.,(IT) Degree Examination November/December 2011 Distance Education RDBMS Question paper
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)
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and
make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.