DOEACC Society 2006 DOEACC B Level B5.2 Object Oriented Database Management System ( ) - Question Paper

B5.2R3: OBJECT ORIENTED DATABASE MANAGEMENT SYSTEMS
NOTE:
Time: three Hours Total Marks: 100
1.
a) What is the purpose of inheritance? How does object oriented technique help produce
flexible and extensible software?
b) elaborate the advantages of polymorphism and dynamic binding?
c) While using object oriented analysis multiple inheritance in kind hierarchy occurs when a
certain subtype T is a subtype of 1 or more than 1 kinds and hence inherits the
function of 1 or more than 1 super kind. State whether the sentence is actual or false.
Justify your ans.
d) What is the virtual member function? How much does it cost to call a virtual function
compared to calling a normal function? Can destructor be virtual? What is the purpose
of a virtual destructor?
e) What is active database? How does it differ from object-oriented database?
f) What is multimedia database? How does it differ from conventional database? elaborate
the various kinds of multimedia data?
g) What is persistent programming language? How do they make object persistent?
(7x4)
2.
a) What is relational database management system? What is object oriented database
management system? Differentiate ranging from the conceptual design of object database
and relational database.
b) What is the importance of checkpoints in the database management system? How
checkpoints are used in the system log file of database management system? ([3+3+8]+4)
3.
a) discuss how object management group standard (OMG) – CORBA allows object to
communicate in distributed heterogeneous environment, providing transparency across
network, operating system and programming language boundaries.
b) What do you understand by a version of a configuration in database management system?
provide differences ranging from versions and configurations. What is concurrent engineering?
(12+6)
4.
a) What is data definition and a data manipulation in object database 02 differs from data
definition and data manipulation in object database object store.
b) In object-oriented approach polymorphism or operation overloading allows the identical
operation name or symbol to be bound to 2 or more various implementation of the
operation, depending on the kind of object to which operation is applied. State whether
the sentence is actual or false and justify your ans.
c) What is distributed database management system? How does it differ from object
oriented database management systems?
(12+2+4)
B5.2-R3 Page one of three July, 2006
1. ans ques. one and any 4 ques. from two to 7.
2. Parts of the identical ques. should be answered together and in the identical
sequence.
5. What do you mean by a recovery in database management system? What is the
necessity of recovery? elaborate the possible reasons for a transaction to fail in the
middle of the execution? What is the transaction processing?
(18)
6.
a) FDBS is an Integration of autonomous database system. State whether FDBS is a kind
of Distributed Database System. explain the problems affecting the design of FDBSs
(Federated database).
b) What is the data mining and data warehouse? discuss data mining process as a part of
the knowledge discovery process in brief.
c) List the main features of an oracle distributed database management system and draw
the block diagram of it.
([3+7]+4+4)
7. Consider the subsequent database schema, where underline shows primary or foreign
key.
EMPLOYEE
FName Minit LName SSN BDate Add Sex Salary SuperSSN DNo
DEPARTMENT
DName DNumber MGRSSN MGR StartDate
DEPT_LOCATION
PROJECT
WORKS_ON
ESSN PNo Hours
DEPENDENT
ESSN Dependent_Name Sex BDate Relationship
B5.2-R3 Page two of three July, 2006
DNumber DLocation
PName PNumber PLocation DNum
Write a SQl Query to retrieve the subsequent data:
a) Make a list of all project numbers for projects that involve an employee whose last name is
“smith’, either as a worker or as a manager of the department that controls the project.
b) Retrieve the name of every employee who has dependent with identical 1st name and identical
sex as the employee.
c) Retrieve the name of every employee who works on all projects controlled by department
number 5.
d) List the name of managers who have at lowest 1 dependent.
e) Retrieve all employees in department five whose salary is ranging from Rs. 30,000 and Rs.
40,000.
(4+4+4+4+2)
B5.2-R3 Page three of three July, 2006

Earning:   Approval pending.