THIRD SEMESTER DIPLOMA EXAMINATION IN ENGINEERING/TECHNOLOGY-MARCH, 2008
DATABASE MANAGEMENT SYSTEMS
PART-A
(Maximum marks:15)
v Answer the following questions in one or two sentences:
1.Define super key.
2.What is specialization?
3.Define normailization.
4.What is foreign key?
5.What is the use of Exists function?
6.List the basic parts of a trigger.
7.What is PL/SQL?
8.Write the syntax of statement used to create stored procedures.
9.What do you mean by RAID level 6?
10.What are heap files?
PART-B
(Maximum marks:60)
(Answer one full question from each unit)
Unit-1
v (a)Explain about the query processor.(6)
(b)Distinguish between the following:
(i)Logical data independence and physical data independence
(ii)Physical schema and logical schema.(6)
OR
v (a)Explain the entity-relationship model.(6)
(b)Explain the function of DML and the types of DML.(6)
Unit-2
v (a)Explain the Boyce-Codd Normal form.(6)
(b)Describe about domain constraints and key constraints.(6)
OR
v (a)Explain the natural join operation with a suitable example.(6)
(b)Explain design guidelines for relational schema.(6)
UNIT-3
v (a)Explain the query optimization process.(6)
(b)Explain how to join tables with a suitable example.(6)
OR
v (a)In an inventory system a product table is maintained,which contain details such as product code,description,rate and another transaction file having product code,transaction type,quanity sold and date of transaction.Assume suitable field names,data type and width.Write SQL statements required to perform the following operations:
(i)List the average quantity sold for each item.
(ii)List the sum total of all transactions for the month of August.
(iii)List items that have not been sold in product master.(6)
(b)Explain grouping using GROUP BY and HAVING clauses with examples.(6)
UNIT-4
v An employee table have fields-employee code,employee name,department code and salary.Assume suitable field length and data type.Write a PL/SQL block of code that increase the salaries of two employees ‘Nithya’and’Yamuna’by Rs.2000 and Rs.2500.If the total of salary of all employees is greater than 35000 undo the updates made to the records of ‘Nithya’and ‘Yamuna’.(12)
OR
v (a)Where do the stored procedures and functions reside and how the ORACLE engine creates the same?(6)
(b)Explain the steps to execute a procedure or function.(6)
UNIT-5
v (a)Explain the factors to be considered for choosing a RAID level.(4)
(b)What are the reasons for bucket overflows in hash file organization?.(4)
(c)Explain two reasons for allowing concurrent executions.(4)
OR
v (a)Explain conflict serializability.(8)
(b)What are the advantages of distributed databases?(4)
0 comments:
Post a Comment