Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question :
Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriented Database or OODB is defined as a persistent and sharable collection of objects defined by an OODM.
(i) OODBMSs were developed due to some of the inadequacies of the existing database technology. One of the inadequacies refers as Impedance mismatch problem. Explain what is meant by impedance mismatch, in the context of relational database system.
(ii) Give example of Four Advanced Database Applications and discuss their general characteristics. Explain why these applications are not suitable for a relational database.
(iii) Define each of the following concepts in the context of an object-oriented data model:
a. Abstraction. b. Objects and attributes. c. Methods and messages. d. Classes, subclasses and superclasses.
Removing a Synonym: DROP SYNONYM D30;
Explain the shadow paging recovery technique. Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i
Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort. To overc
What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.
What are the two main goals of parallelism? Load -balance multiple small accesses, so that the throughput of such accesses enhances. Parallelize large accesses so that the res
Q. What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra
What are the three classes of SQL expression? SQL expression consists of three clauses: Select From Where
Oracle & Distributed Databases 1. Differentiate between PL/SQL functions and procedures. 2. Draw the diagram of logical structure of oracle database and explain it in brief.
growing phase and shrinking phase are disjoint, why ?
Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd