DOEACC B Level Course Object Oriented Database Management System Exam Papers

Any buddy, please provide me the DOEACC B Level Course Object Oriented Database Management System Exam Previous Years Question Papers………….

As per your request here I am sharing the DOEACC B Level Course Object Oriented Database Management System Exam Previous Years Question Paper:

a) State the difference between transient and persistent objects. How is persistent handled
in object oriented database system? Illustrate with an example.
b) What is the difference between overloading and overriding methods? Explain with
examples.
c) Discuss the role of OMG in forming standards in Object Oriented Technology.
d) Distinguish between relational database and object oriented database systems.
e) Compare and contrast OLTP with OLAP.
f) What are the roles of stubs and skeleton in CORBA?
g) What is data mining? Give three examples of application where data mining is used,
clearly bringing out the differences between database and data mining.
(7x4)
2.
a) Discuss various characteristics of object hierarchy and entity hierarchy?
b) What is JDBC? How does it work? Explain in brief?
c) How does a OODBMS exploit encapsulation in implementing support for Abstract Data
Types (ADTs)?
(6+6+6)
3.
a) What is CORBA? Explain in brief the architecture of CORBA with special reference to
ORB, IDL and protocols.
b) What are the salient features of active database? How do you model an active
database?
c) Briefly discuss the general principles behind the C++ binding of the ODMG standards.
(8+5+5)
4.
a) What is the difference between constrained write and unconstrained write assumptions?
Which is more realistic?
b) Discuss, how serializability is used to enforce concurrency control in a database system.
c) What is meant by transaction rollback? Which recovery techniques do not require any
rollback?
(7+6+5)
5.
a) Consider the following relations for a database that keeps track of business trips of sales
persons in a sales office:
SALESPERSON(SSN,NAME,START_YEAR,DEPT_NO)
TRIP(SSN,FROM_CITY,TO_CITY,DEPARTURE_DATE,RETURN_D ATE,TRIP_ID)
EXPENSE(TRIP_ID,ACCOUNT_NO,AMOUNT)
i) Print the SSN of salesman who took trips of ‘ROME'
ii) Print the total trip expenses incurred by the salesman with SSN=’48548’
b) How the above object-orientation can be supported in SQL? List the Characteristic
features of SQL to deal with object orientation.
(8+10)
6.
a) FDBS (Federated Data Base) is an integration of autonomous database system. State
whether FDBS is a type of Distributed Database System. Discuss various issues
affecting the design of FDBS.
b) SQL Extension and Extension to an OO Programming are two approaches used for
Object Query Language. Compare and contrast between “SQL Extension” and
“Extension of an OO Programming” language.
c) “Under-estimating multiplicity can restrict the flexibility of an application in object oriented
technique.” Justify your answer.
(8+5+5)
7. Write short notes of any three of the followings:
a) Database Authorization
b) Virtual Functions and Static Functions
c) Nested Transactions in OODBMS
d) Distributed Updates


Rests of the questions are in the attachment, please click on it………..

Attached Files Available for Download

DOEACC B Level Course Object Oriented Database Management System Exam Paper.pdf (18.7 KB, 27 views)

I am doing DOEACC B Level Course. I want question papers of Object Oriented Database Management System. So tell me can you provide question paper of Object Oriented Database Management System?

Here you want question papers of Object Oriented Database Management System Exam of DOEACC B Level Course, so I am giving following papers:

DOEACC B Level Course Object Oriented Database Management System Paper I
1.
a) Abstraction is a fundamental human capability that permits us to deal with complexity.
Justify this statement.
b) In object oriented analysis and design, aggregation is considered as a special form of
association. Explain with an example.
c) Give reasons why it is necessary to override a feature in object oriented programming.
d) How does the concept of an object in the object oriented model differ from the concept of an
entity in entity relationship model?
e) What is the meaning of persistent and transient Objects in the object oriented databases?
Can a single class have both types of instances in object oriented databases?
f) Qualification improves semantic accuracy and increases the visibility of navigation paths in
object oriented analysis and design. Explain with an example.
g) “Underestimating multiplicity can restrict the flexibility of an application in object oriented
technique”. Justify the statement.
(7x4)

2.
a) Prepare an Object diagram for a graphical document editor that supports grouping, which is
a concept used in a variety of graphical editors. Assume that a document is composed of
several sheets. Each sheet contains drawing objects, including text, geometrical objects and
groups. A group is simply a set of drawing objects, possibly including other groups. A group
must contain at least two drawing objects. A drawing object can be a direct member of at
most one group. Geometrical objects include circles, ellipses, rectangles, lines and squares.
b) Write the necessary steps which are required to implement an “Object Model”.
c) Differentiate between overloading and overriding of methods in object oriented programming
with suitable examples. Explain using C++ code.
(8+6+4)

3.
a) For which category of application, the use of object data management is more appropriate?
State any three relevant application pertaining to the use of object data management principles.
b) Enumerate the strengths and weaknesses of object oriented database management system.
c) Differentiate between the concept of Data independence in distributed DBMS and the
concept of data independence in centralized DBMS.
(6+8+4)

4.
a) What is CORBA? Explain the services provided by the CORBA to support the integration
and interoperation of distributed objects.
b) What is the meaning and type of distributed database? Define the term Distributed DBMS.
Explain the objectives of distributed databases.
(8+10)
5.
a) With neat sketch, explain the architecture of typical data mining system.
b) What is a database authorization? How database authorization is done in relational
database management system?
c) Give comparison between On Line Transaction Processing (OLTP) and On Line Analytical
Processing (OLAP).
(8+6+4)

6.
a) SQL Extension and Extension to an OO Programming are two approaches used for object
query language. Compare and contrast between “SQL Extension” and “Extension to an OO
programming language”.
b) Explain, how the concept of data identity in relational database management system differs
from the concept of Object identity in object oriented database management system.
c) What is Object Management Group (OMG) reference model? Explain the responsibilities,
purposes and major components of OMG reference model.
(4+6+8)

7.
a) Differentiate the following Database concepts:
i) Remote Update Vs. Distributed Update
ii) Remote Transaction Vs. Distributed Updates.
b) What is the meaning of nested transactions in object oriented database management
system? Discuss various operations used in nested transaction.
c) What is object oriented database? What is the requirement of object oriented databases?
Explain the advantages of object oriented databases over relational databases.
(6+6+6)

__________________
Answered By StudyChaCha Member