Filters
Question type

Study Flashcards

Typically,the _________________________ scenario requires a network file server running conventional applications that are accessed through a network.

Correct Answer

verifed

verified

multiple-site proces...

View Answer

The ____________________ fragment condition indicates that each row is unique,regardless of the fragment in which it is located.

Correct Answer

verifed

verified

The ____ processor is the software component residing on each computer that stores and retrieves data located at the site.


A) transaction
B) network
C) data
D) management

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

The ____ rule requires that all copies of data fragments be identical.


A) shared fragment
B) mutual consistency
C) horizontal fragmentation
D) replication

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

If a DDBMS exhibits ____________________ transparency,the user does not need to know that the data are partitioned-meaning the table's rows and columns are split vertically or horizontally and stored among multiple sites.

Correct Answer

verifed

verified

In a DDBMS,____________________ occurs to determine the data location of local and remote fragments.

Correct Answer

verifed

verified

One of the advantages of a DDBMS is processor ____________________.

Correct Answer

verifed

verified

____ fragmentation refers to the division of a relation into attribute subsets.


A) Data
B) Horizontal
C) Vertical
D) Mixed

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

____ fragmentation refers to the division of a relation into subsets of tuples.


A) Vertical
B) Horizontal
C) Data
D) Mixed

E) None of the above
F) C) and D)

Correct Answer

verifed

verified

____ transparency ensures that the system will continue to operate in the event of a node failure.


A) Transaction
B) Distribution
C) Failure
D) Performance

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.


A) Data distribution
B) Replica transparency
C) Network latency
D) Network partitioning

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

What is transaction transparency? What are some of the basic concepts that you should know to understand how transactions are managed in a DDBMS?

Correct Answer

verifed

verified

Transaction transparency is a DDBMS prop...

View Answer

One of the advantages of a DDBMS is ____________________ operating cost.

Correct Answer

verifed

verified

A distributed database system requires functional characteristics that can be grouped and described as transparency features.

A) True
B) False

Correct Answer

verifed

verified

Describe performance transparency and heterogeneity transparency.

Correct Answer

verifed

verified

Performance transparency allows the syst...

View Answer

____ are an advantage of a DDBMS.


A) Reduced operating costs
B) Simplicity of management and control
C) Decreased storage requirements
D) Decreased training costs

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

____ is a disadvantage of a DDBMS.


A) Data is located near the "greatest demand" site
B) Growth facilitation
C) Danger of a single-point failure
D) Lack of standards

E) B) and C)
F) C) and D)

Correct Answer

verifed

verified

A ____ distributed database system will support different DBMSs that may even support different models running under different computer systems.


A) fully heterogeneous
B) fully homogeneous
C) homogeneous
D) heterogeneous

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

A DDBMS must be communications-media-dependent.

A) True
B) False

Correct Answer

verifed

verified

____ distributed database systems integrate only one type of centralized DBMS over a network.


A) Homogeneous
B) Heterogeneous
C) Fully heterogeneous
D) Combination

E) A) and D)
F) All of the above

Correct Answer

verifed

verified

Showing 21 - 40 of 70

Related Exams

Show Answer