Jawaharlal Nehru Technological University Kakinada 2010 B.Tech Information Technology Jntuniversity-kakinada,data base management systems, - exam paper

CODE NO:V0523/R07 SET NO:2


II B.Tech II Semester Regular Examinations,April 2010
DATA BASE MANAGEMENT SYSTEMS
(Common to Computer Science & Engineering and info technology)


Time:3 hours Max Marks:80

ans ANY 5 ques.
ALL ques. CARRY EQUAL MARKS

1.(a)Why would select a database system instead of simply storing data in operating system files?
When would it make sense not to use a database system? [8+8]
(b)What is logical data independence and why it is it important?
2.(a)What is a relation?Differentiate ranging from relation schema and relation instance.Define the
terms unity and degree of relation.What are domain constraints? [8+8]
(b)Explain new insertion,deletion and updating of database is performed in the relational algebra?
3.(a)Types of Join Operations. [16]
(b)Set Operations.
4.(a)Explain about four Nf?Give 1 example? [8+8]
(b)Explain about five Nf?Give 1 example?
5.(a)Explain how Concurrency execution of transactions improves overall system performance.
(b)What are the transaction isolation levels in SQL? [8+8]
6.(a)What are the merits & demerits of using fuzzy dumps for media recovery. [6]
(b)Explain three phases of ARIES Algorithm. [4]
(c)Explain three main properties of ARIES Algorithm. [6]
7.Explain why the allocation of records to blocks affects database-system performance
significantly. [16]
8.What are the differences ranging from B-tree indices and B+ tree indices.Explain in detail.
[16]

Earning:   Approval pending.