In _______ DDBMS, every one of the site might manage different types of DBMS
In _______ DDBMS, every one of the site might manage different types of DBMS
______ fragmentation of a relation or a table can be acquired by dividing the table into a number of sub-tables having disjoint columns
______ fragmentation of a relation or a table can be acquired by dividing the table into a number of sub-tables having disjoint columns
_______ transparency resides when the user should recognise the database fragment names but have no need to declare at which locations these fragments are situated
_______ transparency resides when the user should recognise the database fragment names but have no need to declare at which locations these fragments are situated
state true or false
Replicated data management means capability to choose which copy of one copied data to access and to sustain the reliability of copy of replicated data
state true or false
Replicated data management means capability to choose which copy of one copied data to access and to sustain the reliability of copy of replicated data
________ Processor is also called Transaction Manager (TM) or Application Processor (AP).
________ Processor is also called Transaction Manager (TM) or Application Processor (AP).
________means System keeps several copies of data, stored at various sites, for quick retrieval fault tolerance
________means System keeps several copies of data, stored at various sites, for quick retrieval fault tolerance
Relation is divided into various ________
Relation is divided into various ________
A database that physically resides entirely on one machine under a single DBMS is known as ________database management system
A database that physically resides entirely on one machine under a single DBMS is known as ________database management system
In ddbms _________features the database is located at various sites or that there are many users accessing the data at the same time is not known to the users
In ddbms _________features the database is located at various sites or that there are many users accessing the data at the same time is not known to the users
_________ managers handle constant data and perform in collaboration with Distributed Transaction Coordinator (DTC) to guarantee isolation & atomicity to the application.
_________ managers handle constant data and perform in collaboration with Distributed Transaction Coordinator (DTC) to guarantee isolation & atomicity to the application.
Commit protocols are utilised to make sure _______ across sites
Commit protocols are utilised to make sure _______ across sites
When a site is unsuccessful or fails and then you restart, it has to perform ________ for all transactions that it has not yet committed suitably
When a site is unsuccessful or fails and then you restart, it has to perform ________ for all transactions that it has not yet committed suitably
_______ transaction manager with two phase commit protocol uses a coordinator to handle individual resource managers
_______ transaction manager with two phase commit protocol uses a coordinator to handle individual resource managers
Two phase commit is one transaction protocol intended for those complexities that happen with ___________ resource managers
Two phase commit is one transaction protocol intended for those complexities that happen with ___________ resource managers
state true false.
Distributed database recovery means The capability to recover data from case-by-case crashes and from different types of malfunctions, for example; breakdown of communication link
state true false.
Distributed database recovery means The capability to recover data from case-by-case crashes and from different types of malfunctions, for example; breakdown of communication link
________ is a software component on every computer in the distributed database system.
________ is a software component on every computer in the distributed database system.
In _____Distributed transactions should be carried out with adequate security management of data and the access/authorisation rights of users
In _____Distributed transactions should be carried out with adequate security management of data and the access/authorisation rights of users
In _______Relation is divided into various fragments stored at separate sites
In _______Relation is divided into various fragments stored at separate sites
When the database technology is the same at each of the locations and the data at the several locations are also compatible, that data is known as _______database
When the database technology is the same at each of the locations and the data at the several locations are also compatible, that data is known as _______database
state true or false.
Each workstation should have essential hardware and software that allow them to establish a network with other components on the distributed database system
state true or false.
Each workstation should have essential hardware and software that allow them to establish a network with other components on the distributed database system