THIRD SEMESTER DIPLOMA EXAMINATION IN ENGINEERING/TECHNOLOGY-MARCH, 2009
DATABASE MANAGEMENT SYSTEMS
PART-A
(Maximum marks:15)
v Answer the following questions in one or two sentences:
1.Define entity?
2.What is UML?
3.Define tuple.
4.List the symbols used to represent the select,project and Cartesian product operations.
5.What is the use of UNIQUE constraint?
6.What are aggragate functions?
7.What is the use of exception section in PL/SQL block?
8.What are triggers?
9.What is mirroring?
10.What are non-clustering indices?
PART-B
(Maximum marks:60)
(Answer one full question from each unit)
Unit-1
v (a)Describe with a figure the two-tier client architecture.(4)
(b)Explain the specialization feature of EER model with a suitable example.(8)
OR
v (a)Explain the inheritance property of EER model.(6)
(b)Explain the three schema architecture.(6)
Unit-2
v (a)Explain the set intersection and natural join operations with examples.(8)
(b)Compare BCNF and 3 NF.(4)
OR
v (a)Explain about dependency preservation.(6)
(b)Explain with an example the second normal form.(6)
UNIT-3
v (a)Explain the data types in SQL with examples.(6)
(b)Explain the following statements in ORACLE with examples:
(i)UPDATE (ii)INSERT (iii)DELETE.(6)
OR
v (a)Explain cost-based query optimization method.(6)
(b)Explain the following statements:
(i)ROLLBACK (ii)SAVE POINT (iii)COMMITT.(6)
UNIT-4
v (a)Differentiate between:
(i)Procedures and functions in ORACLE(6)
(ii)Database triggers and procedure.
(b)Explain the control statements in PL/SQL with examples.(6)
OR
v There are two tables maintained in a library management system:
(i)The MEMBER table containing details of members in library such as member number,member name,address,designation and department.
(ii)The book table containing details about books such as book number,title,author name,publisher name and stock quantity.Write a PL/SQL to accept a member number and book number.Issue book to a member only if it is available.If not issue a suitable error message.Perform required file updations.Assume suitable field name,data type and width for each field.(12)
UNIT-5
v (a)Explain horizontal data fragmentation in distributed databases.(6)
(b)Explain how to perform insert,look up and delete operation in a file having hash organization.(6)
OR
v (a)Explain RAID level 5(6)
(b)Explain about transaction states.(6)
0 comments:
Post a Comment