#1
| |||
| |||
![]() 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……….. Last edited by GaganD; June 29th, 2019 at 12:37 PM. |
#2
| |||
| |||
![]()
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?
|
#3
| |||
| |||
![]()
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 |