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
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
_______ 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
________ Processor is also called Transaction Manager (TM) or Application Processor (AP).
________ Processor is also called Transaction Manager (TM) or Application Processor (AP).
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
________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
________ is a software component on every computer in the distributed database system.
________ is a software component on every computer in the distributed database system.
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
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
_________ 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.
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
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
In _______Relation is divided into various fragments stored at separate sites
In _______Relation is divided into various fragments stored at separate sites
______ 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
Commit protocols are utilised to make sure _______ across sites
Commit protocols are utilised to make sure _______ across 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
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
Relation is divided into various ________
Relation is divided into various ________
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