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!
Improved Reliability:In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link creation some sites inaccessible, does not make the whole system inoperable. Distributed DBMSs are designed to continue to function despite such as failures. In particular, if data are replicated in various sites, a transaction requiring a particular data item may find it at various sites. Therefore, the failure of a site does not necessarily imply the shutdown of the system.
The failure of one site must be identified by the system, and appropriate action may be required to recover from the failure. The system has no longer used the services of the failed site. At last, when the failed site recovers or is repaired, mechanisms have to be available to integrate it smoothly back into the system. The recovery from failure in distributed systems is much more difficult than in a centralised system.
Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known
What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche
Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates
Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD
What is a value? A data value is used for identity. This form of identity is used in relational systems.eg: The primary key value of a tuple recognize the tuple.
Group By clauses • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used
define anomalies and different types of anomalies with example
What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage
You are required to design and build a data mart/data warehouse using Oracle. A national bank allocates funding every year for its local branches to provide temporary staff cove
Australian Bureau of Statistics (ABS) provides retail data for different groups and different states as well as the aggregate numbers. Table 11 " Retail Turnover, State by Industry
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