Punjab Technical University 2007-4th Sem M.B.A (-3/) DBMS ( - 542) - Question Paper

MBA (Semester - third & 4th)

DBMS (MBA - 542)

Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) part - A is compulsory.
2) Attempt any 9 ques. from part - B.

part - A
Q1) (15 x two = 30)
a) What is Database? provide an example.
b) Mention the advantages of using DBMS.
c) describe Entity with an example.
d) What is meant by Concurrency?
e) Define, compare and contrast the Single valued attribute/multi-valued
attribute.
f) describe functional dependency.
g) discuss the role of DBA in a database environment.
h) What is a view? discuss what happens when a user accesses a database
through a view.
i) What is data independence in the situation of databases?
j) discuss how SQL handles the subsequent choose related constructs :
(i) Joins (ii) Character Matching.
k) provide 2 advantages and 2 disadvantages of Distributed database
Management System.
l) What is the purpose of “Null”? Is a component of a primary key allowed
to accept “null”? Why?
m) describe the terms 3NF and BCNF. describe a relation that is not in 3NF.
n) Write a short note on transaction management in the situation of Object
Oriented DBMS.
o) Entity integrity constraint in the relational model says that in no relation,
a _____ can be null, in the _______ constraint in the relational model,
an attribute that is a _____ key may be null as long as it is not part of a
_______ key.

part - B
(9 x five = 45)
Q2) List and briefly discuss the 3 levels of abstraction at which we design
a database. For every list the basic elements of that level. For the least
level only, what is the key consideration?
Q3) What is a database model? discuss any 2 kinds of data models with an
example for every.
Q4) discuss the need of data replication and data fragmentation with respect
to distributed databases. List the differences ranging from horizontal and vertical
fragmentation.
Q5) discuss the different operators available in relational algebra by taking
examples.
Q6) What is meant by Log based recovery techniques? discuss the writeahead
log strategy for recovery in a centralized DBMS, with the help of
an example.
Q7) What is multi-version technique of concurrency control? define this
with the help of an example. Will this scheme outcome in rollback and/or
deadlock? Justify your ans.
Q8) elaborate integrity constraints? discuss referential integrity constraint with
an example.
Q9) discuss how the “GROUP BY” clause works. What is the difference
ranging from WHERE and HAVING clauses? discuss them with the help of
an example for every.
Q10) elaborate the main features of the Object Oriented Database Management
System? How is this advantageous over RDBMS?
Q11) Suppose you are asked to design a university database system. elaborate
the security measures that may be proposed by you for database security?
You must describe different security levels for physical security, database
access and external schema.

Q12) Suppose in any manufacturing organization, a database updating operation
is always performed, immediately on the physical (stored) database. How
are do, undo and redo operations performed for this database? discuss
with the help of a suitable example.
Q13) Consider the subsequent relations :
Hotel {hotelNo, name, address}
Room {roomNo, hotelNo, type, price}
Booking {hotelNo, guestNo, dateFrom, dateTo, roomNo}
Guest {guestNo, name, address}
Write the SQL statements for the following:
(a) List the names and addresses of all guests in Chandigarh, alphabetically
ordered by name.
(b) List all family rooms with a price beneath Rs. 400 per night, in ascending
order of price.
(c) How many hotels are there?

Earning:   Approval pending.