What is site autonomy? – McqOptions

MCQOPTIONS

1.	What is site autonomy?
A.	Each server participating in a distributed database is administered independently from all other databases.
B.	Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.
C.	Local administrators cannot control corresponding local data. Therefore, each database administrator s domain of responsibility is smaller and more manageable.
D.	Administrators cannot recover from isolated system failures independently from other nodes in the system.
Answer» B. Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.

Discussion

No Comment Found

Related MCQs

Which feature of database reduces the amount of data transfer required between sites when a transaction retrieves data from remote tables and referenced in a distributed SQL statement?
In Rewriting your query to access the remote database once it is achieved by using collocated inline views, which term is used for defining two or more tables that are located in the same database?
Which of the agent is used so that the Generic connectivity enables you to connect to a non-oracle database data stores?
All users on the local database can access the remote database and all use the same userid/password to make the connection. How can user access the remote database through the link?
If your distributed query contains ___________, then the cost-based optimization is not effective.
Which of these is used to process information requests in the distributed databases?
If a part of a distributed statement fails, due to an integrity constraint violation then the database returns which error number?
What is site autonomy?
In distributed SQL statements, which of the following retrieves information from two or more nodes?
The REMOTE_OS_AUTHENT parameter operates an externally-authenticated user and it can connect to the remote database using a connected user database link, Select the correct parameter to set.