Master of Science I (Computer Science
Examination: Oct Nov 2016 Semester I (New CBCS)
SLR No. Day
Date Time Subject Name Paper No. Seat No.
SLR SC-
299
Wednesday
16/11/2016
10.30 AM
to
01.00 PM
DBMS
C
HCT-1.1
es Instructions: Question No. 1 and 2 is compulsory.
Attempt any three questions from Q.no. 3 to Q. no. 7
Figures to right indicate full marks.
Total Marks: 70
Q.1 Choose correct alternative. 10
In a relation schema each tuple is divided in to fields called.
relation domain
queries all of the above
In an E-R model is described in the database by storing its data.
entity attribute
relationship notation
DFD stands for
Data flow diagram Data file diagram
Data flow document none of above
command can be used to modify a column in a table.
Update Alter
Set Create
Which of the following is not the type of data integrity
Key integrity Domain integrity
Entity Referential integrity
In the architecture of a database system external level is the.
Physical level Logical level
Conceptual level view level
Which database level is closed to the users
external internal
physical conceptual
a consist of a sequence of query and or update statement.
commit transaction
rollback flashback
SET concept is used in
Network model Hierarchical model
Relational model None of the above
10) Which normal from is considered adequate for relational database design.
2NF 3MF
4NF BCNF
State true/ false 04
It is possible to define a scheme completely using DDL and DML.
A B-tree of order m has maximum of m+1 children.
Relational algebra is procedural query language.
Cross product is a unary operator.
Q.2 Write short note on the following: 08
ACID properties
Data replication.
Answer the following: 06
What is DDL and DML. Give one example each.
Explain different types of database users.
Q.3 Answer the following:
Describe various components of DBMS. 07
Define data model. Explain different types of data model with examples. 07
Q.4 Answer the following:
What is meant by functional dependencies? Explain in detail 2NF, 3NF 07
Give symbol used in E-R diagram and draw E-R diagram for library management
system.
07
Q.5 Answer the following:
Explain two phase locking protocol. 07
What are the advantages of distributed database over a centralized database. 07
Q.6 Answer the following:
Explain the various ways in which database backup and recovery can be
implemented.
07
Give the steps in query processing? 07
Q.7 Answer the following:
Define serializability Explain the types of serializability.
Describe nested table and varying arrays.