M.Sc (Computer Science) (CBCS)
Examination, 2017
DBMS
Day Date: Tuesday, 25-04-2017 Marks: 70
Time: 10.30 AM to 01.00 PM
Instruction Question no. 1 and 2 are compulsory.
Attempt any 3 questions from Q. no. 3 to Q. no. 7
Figures to the right indicate full marks.
Q.1 Choose correct alternatives. 10
The concept of locking can be used to solve the problem of

Deadlock Lost update
Inconsistent data All of the above
Which of the following is a valid SQL type?
CHARACTER NUMERIC
FLOAT All of the above
ODBC stands for
Object data base connectivity
Oral data base connectivity
Oracle data base connectivity
Open data base connectivity
Relational calculus is a
Procedural language Non procedural language
High level language All of the above
Multi value dependency among attribute is checked a which
level.
2Nf 5NF 4NF 3NF
In the architecture of a database system external level is the
Physical level Logical level
Conceptual level View level
a preferred method for enforcing data integrity.
Constraints store procedure triggers cursors
The data base schema is written in.
HLL b)DML b D D L DCL
Page 2 of 2
SET concept is used in
Network model Hierarchical model
Relational model None of the above
10) can be used to modify a column in a
table.
Alter Update Insert Create
State True or False. 04
Conceptual model is independent of both hardware and
software.
A file manipulation command that extract some of the records
from a file is called SELECT.
The full form of DDL is dynamic data language.
Transaction processing is associate with every thing below
except conforming an action or triggering response.
Q.2 Write short notes of the following. 08
Fragmentation
DBA
Answer the following. 06
Explain DDL and DML give one example each.
Explain Strong entity set and weak entity set.
Q.3 Answer the following.
Explain three level architecture of DBMS with neat diagram. 07
Define entity and attribute. Explain the different types of attribute
that occur in E-R model.
07
Q.4 Answer the following.
Explain domain constraints and boyce code normal form with
examples.
07
What is relational algebra? Enlist and explain the fundamental
operation of Relational algebra.
07
Q.5 Answer the following.
Explain in detail the concept of serializability. 07
Explain log based recovery in detail. 07
Q.6 Answer the following.
Explain the advantages of optimization in query processing. 07
Discuss two phase commit protocol and its significance. 07
Q.7 Answer the following.
How do you implement distributed database in a real time
environment.
07
Describe the concept of nested table and varying arrays. 07