THIRD SEMESTER DIPLOMA EXAMINATION IN ENGINEERING/TECHNOLOGY-OCTOBER, 2010
DATABASE MANAGEMENT SYSTEM
PART-A
(Maximum marks:15)
v Answer the following questions in one or two sentences:
1.Define a record.
2.What is physical data independence?
3.List various data models?
4.Define functional dependency.
5.What is TCL?
6.What is the use of COMMIT statement?
7.What is a data base trigger?
8.Define embedded SQL.
9.What is RAID?
10.Define variable length records.
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 three tier client server architecture.(6)
OR
v (a)Explain the advantages of data base system over conventional systems.(6)
(b)Explain various components of storage manager.(6)
Unit-2
v (a)Explain the features of relational data model.(6)
(b)What is constraints?Explain integrity constraints in detail.(6)
OR
v (a)Explain 1NF and 2NF in 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 HAVING and GROUP BY in detail.(6)
OR
v A table named EMp consists of following fields:empno,name,deptno,salary,designation.Now write SQL commands for following:
(i)To create table.
(ii)To insert 5 numbers of values into it.
(iii)Find name of employees whose salary is between 10,000 and 20,000.
(iv)Find name ,designation,deptno of employees who have designation that don’t appear in deptno 2.(12)
UNIT-4
v (a)What are aggragate functions?Explain with example.(6)
(b)Explain stored procedures and functions.(6)
OR
v (a)Explain features of dynamic SQL.(6)
(b)What is cursor?Differnet types,explain with examples.(6)
UNIT-5
v (a)Explain features of RAID level 1.(6)
(b)Explain serializability in transaction management.(6)
OR
v (a)What is SAN?Its advantages.(6)
(b)Explain different file organizations.(6)
0 comments:
Post a Comment