THIRD SEMESTER DIPLOMA EXAMINATION IN ENGINEERING/TECHNOLOGY-OCTOBER, 2011
DATABASE MANAGEMENT SYSTEMS
PART-A
(Maximum marks:15)
v Answer the following questions in one or two sentences:
1.Define primary Key.
2.Define schema
3.List the needs of normalization.
4.Define functional dependency.
5.What is SQl?
6.What is integrity constraints?
7.What is the use of data base cursor?
8.Define embedded SQL.
9.List different ways of groupingrecords in a file.
10.Define data fragmentation.
PART-B
(Maximum marks:60)
(Answer one full question from each unit)
Unit-1
v (a)Explain data base architecture with diagram.(6)
(b)Explain 2 tier client server architecture.(6)
OR
v (a)Explain the advantages of data base system over conventional systems.(6)
(b)Explain data independences in detail.(6)
Unit-2
v (a)Explain any 2 relational operations in detail.(6)
(b)What is constraints?Explain integrity constraints in detail.(6)
OR
v (a)Explain 3 NF and 4 NFin detail.(6)
(b)Explain different types of join operations.(6)
UNIT-3
v (a)Explain various data types of SQL in detail with examples.(6)
(b)Explain the working of UPDATE and CREATE INDEX command.(6)
OR
v An employee table named EMP consists of following fields:
Emp.no,name,dept.no,salary,designation.Now write SQL commands for the following:
(i)to create table
(ii)To insert 5 numbers of values into it.
(iii)Find dept.no.who has maximum number of employees.
(iv)Find minimum salary of employees who have more than 10,000 as salary.(12)
UNIT-4
v (a)What are aggregate functions?Explain with example.(6)
(b)Explain different types of data base triggers.(6)
OR
v (a)Explain features of dynamic SQL.(6)
(b)What is cursor?Explain different types with examples.(6)
UNIT-5
v (a)Explain data fragmentation in distributed data base .(6)
(b)Explain serializability in transaction management.(6)
OR
v (a)What is SAN?Write its advantages.(6)
(b)Explain concurrent execution.(6)
0 comments:
Post a Comment