It5-dbms-dec08 (1)

Roll No. ....................... Total No. of Questions: 091

[Total No. of Pages: 02

PaperID [A04661 ( P l e a s ef i l l t h i s P a p e r I D i n O M R S h e e t )

B.Tech.(Sem.- 5'n) DATABASEMANAGEMET{T SYSTEMS(CS - 305) Time : 03 Hours

Maximum Marks : 60

Instruction to Candidates: 1) Section- A is Compulsory. 2) 3)

Attempt any Four questionsfrom Section- B. Attempt any Two questionsfrom Section- C. Section- A

( 1 0x 2 : 2 0 )

Ql) a)

What is a view?How a view is created?

b)

Whatarethevarioustypesoftransactionfailurethatmayoccurin system?

c)

List two reasonswhy null valuesmight be introducedin database?

d)

DefineE-RDiagramwith the help of an example?

e)

Distinguishbetweendisjoint andoverlappingconstraints?

0

What aremappingcardinalities?Discussits types?

g)

What is trigger?What is its use?

h)

Distinguishbetweenproceduraland non procedurallanguages?

D

What do you meanby QueryProcessor?

j)

DefineDDL andDML?

E-eegIr2081

P,TO.

Section-B (4x5:20) Q2) What is No-rmalization?Explain why 4NF is more desirablethan BCNF with thehelpof an example? Q3) Whatarethe main differencesbetweenfile processingand databasesystems? Q4) Discussthe classificationof Databases? Q5) What are the componentsof DBMS? Q6) What is deferredupdatetechniquefor databaserecovery? Section- C . (2 x l0:20) Q7) (a) Define transactions?What arethe statesof transactions? Whenundoandredooperations (b) DiscussACIDpropertiesoftransactions? . areused? Q8) DiscussdatabaseSecurityand Integrity?Explain its variousmethods? Q9) Write short notes on: (a) Levels of databaseabstraction. (b) DDL andDML. (c) Dataindependence.

osos

E-998

2