A distributed database (DDB) is an integrated collection of databases.

A.True
B.False
ANSWER:A
A distributed database (DDB) is not an integrated collection of databases.
A.True
B.False
ANSWER:B
The basic function of DDBMS is to keep track of the data distribution,
fragmentation and replication by expanding the DDBMS catalog.
A.True
B.False
ANSWER:A
In a homogeneous database, all different sites store database identically.
A.True
B.False
ANSWER:A
In a heterogeneous distributed database, different sites can use different schema.
A.True
B.False
ANSWER:A
Each site (or node) in a distributed system is subject to the same types of failure
as in a centralized system.
A.True
B.False
ANSWER:A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A.True
B.False
ANSWER:B
distributed unit of work allows various statements within a unit of work to refer
to multiple remote DBMS locations
A.True
B.False
ANSWER:A
The semijoin approach saves network traffic.
A.True
B.False
ANSWER:A
The problem of concurrency control is more complex in a distributed database.
A.True
B.False
ANSWER:A
With failure transparency, all of the actions of a transaction are committed or
none of them are committed.
A.True
B.False
ANSWER:A
Each site (or node) in a distributed system is subject to the same types of failure
as in a centralized system.
A.True
B.False
ANSWER:A
With asynchronous technology, if any copy of a data item is updated anywhere on the
network, the same update is immediately applied to all other copies or it
is aborted.
A.True
B.False
ANSWER:B
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A.True
B.False
ANSWER:B
An increasingly popular option for data distribution as well as for fault tolerance
of any database is to store a separate copy of the database at each of two or
more sites.
A.True
B.False
ANSWER:A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A. True
B. False
Answer:B
A distributed unit of work allows various statements within a unit of work to refer
to multiple remote DBMS locations.
A. True
B. False
Answer:A
The samijoin approaches save network traffics.
A. True
B. False
ANSWER: A
The problem of concurrency control is more complex in a distributed database
A. True
B. Fales
ANSWER: A
Data replication is favored where most process requests are read-only and where the
data are relatively static.
A. True
B. False
ANSWER: A
The purpose of timestamping is to avoid the use of locks.
A. True
B. False
ANSWER: A
With failure transparency, all of the actions of a transaction are committed or
none of them are committed.
A. True
B. False
ANSWER: A
There are two types of fregmantation,
A.true
B.false
Answer: B
DDBMS is faster then DBMS.
A.true
B.false
Answer: A
Distribution Transparency mean programs can be written as if a database is not
distributed for its user.
A.true
B.false
Answer: A
Transperency is not a property of DDBMS.
A.true
B.false
Answer: B
In vertical fragmentation attributes are divided.
A.true
B.false
Answer: A
A distributed database management system manages the database as if it were not
all stored on a same computer.
A. true
B. false
Answer:A
Partitioned, replicated is the type of DDB design.
A. true
B. false
Answer:B
Transaction transparency, it must not handle database recovery.
A. true
B. false
Answer:B
Where the data they access actually located is known as location transparency.
A. true
B. false
Answer:A
A distributed database is a database in which storage devices are not all attached
to a common cpu.
A. false
B. true
Answer:B
The semi join approach saves network traffic.
A.True
B.False
ANSWER:A
Distributed data access was needed to support geographically dispersed business
units.
A.True
B.False
ANSWER:A
The Internet is the repository for distributed data.
A. True
B. False
ANSWER:B
Correctness rules for fragmentation are Completeness, Construction and Jointness.
A.True
B.False
Answer:B
One of the advantages of a distributed database management system (DDBMS) is
security.
A.True
B.False
ANSWER:A
Synchronization for pull replication is less disruptive and occurs only when needed
by each site, not when a central master site thinks it is best to update.
A. True
B. False
ANSWER:A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A. True
B. False
ANSWER:B
The semijoin approach saves network traffic.
A. True
B. False
ANSWER:A
The problem of concurrency control is more complex in a distributed database.
A. True
B. False
ANSWER:A
With asynchronous technology, if any copy of a data item is updated anywhere on the
network, the same update is immediately applied to all other copies or it is
aborted.
A. True
B. False
ANSWER:B
Rapid ad hoc data became unnecessary in the quick-response decision-making
environment.
A. True
B. False
ANSWER: B
One of the advantages of a distributed database management system (DDBMS) is
security.
A. True
B. False
ANSWER: B
The transaction processor (TP) is the software component found in each computer
that requests data.
A. True
B. False
ANSWER: A
When you create a database, you first create the primary keys.
A. True
B. False
ANSWER: B
A primary key is a field (or group of fields) that uniquely describes each record
in the database. 
A. True
B. False
ANSWER: A 
Foreign keys uniquely identify records.  
A. True
B. False
ANSWER: B
The relational database model was created by E.F. Codd.
A.True
B.False
ANSWER:A
A database is called "self-describing" because it contains a description of itself.
A.True
B.False
ANSWER:A
In a database, data is stored in spreadsheets which have rows and columns.
A.True
B.False
ANSWER:B
A database has data and relationships.
A.True
B.False
ANSWER:A
The purpose of a database is to help people stop using spreadsheets.
A.True
B.False
ANSWER:B
Each site (or node) in a distributed system is subject to the same types of failure
as in a centralized system.
A.True
B.False
Answer:A
In a semijoin, only the joining attribute is sent from one site to another, and
then only the required rows are returned.
A.True
B.False
Answer: A
The problem of concurrency control is more complex in a distributed database.
A.True
B.False
Answer: A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A.True
B.False
Answer: B
With asynchronous technology, if any copy of a data item is updated anywhere on the
network, the same update is immediately applied to all other copies or it is
aborted.
A.True
B.False
Answer: B
Replication may use either synchronous or asynchronous distributed database
technologies, although asynchronous technologies are more typical in a replicated
environment.
A.True
B.False
ANSWER:A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A.True
B.False
ANSWER:B
A distributed unit of work allows various statements within a unit of work to refer
to multiple remote DBMS locations.
A.True
B.False
ANSWER:A
The purpose of timestamping is to avoid the use of locks.
A.True
B.False
ANSWER: A
The problem of concurrency control is more complex in a distributed database.
A.True
B.False
ANSWER:A
Distributed data access was needed to support geographically dispersed business
units.
A. True
B. False
ANSWER: A
Performance transparency ensures that the system finds the most cost-effective path
to access remote data.
A. True
B. False
ANSWER: A
The semijoin approach saves network traffic.
A. True
B. False
ANSWER: A
Map Reduce is a batch-oriented parallel computing model.
A. True
B. False
ANSWER: A
Static extract is used for ongoing warehouse maintenance.
A. True
B. False
ANSWER: B
All sites in a distributed database commit at exactly the same instant.
A. TRUE
B. FALSE
ANSWER: B
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A.True
B. False
ANSWER:B
The problem of concurrency control is more complex in a distributed database.
A.TRUE
B.FALSE
Answer:A
The semijoin approach saves network traffic.
A.TRUE
B.FALSE
Answer:A
A distributed unit of work allows various statements within a unit of work to refer
to multiple remote DBMS locations.
A.TRUE
B.FALSE
Answer:A
Distributed processing shares a databases logical processing among two or more
physically independent sites that are connected through a network.
A. True
B. False
ANSWER :A
The transaction processor is the software component found un each computer that
requests data.
A: True
B: False
ANSWER : A
A distributed database management system must be communications- media-
dependent.
A: True
B: False
ANSWER : B
Both distributed processing and distributed databases require a network of
interconnected components.
A: True
B: False
ANSWER : A
Current distributed database management are subject to some problems such as
the complexity of management and control.
A: True
B: False
ANSWER :A
Databases that are stored on computers at multiple locations and are not
interconnected by a network are known as distributed databases.
A. True
B. False
Answer B
2. Data replication is favored where most process requests are read-only and where
the data are relatively static.
A. True
B. False
Answer A
3. The cost to perform a snapshot refresh may depend on whether the snapshot is
simple or complex.
A. True
B. False
ANSWER A
4. The semijoin approach saves network traffic.
A. True
B. False
Answer A
5. In a semijoin, only the joining attribute is sent from one site to another, and
then only the required rows are returned.
A. True
B. False
Answer A