Distributed Databases - General Questions Online Exam Quiz

Distributed Databases - General Questions GK Quiz. Question and Answers related to Distributed Databases - General Questions. MCQ (Multiple Choice Questions with answers about Distributed Databases - General Questions

A distributed database has which of the following advantages over a centralized database?

Options

A : Software cost

B : Software complexity

C : Slow Response

D : Modular growth

View Answer

An autonomous homogenous environment is which of the following?

Options

A : The same DBMS is at each node and each DBMS works independently.

B : The same DBMS is at each node and a central DBMS coordinates database access.

C : A different DBMS is at each node and each DBMS works independently.

D : A different DBMS is at each node and a central DBMS coordinates database access.

View Answer

A transaction manager is which of the following?

Options

A : Maintains a log of transactions

B : Maintains before and after database images

C : Maintains appropriate concurrency control

D : All of the above.

View Answer

Location transparency allows for which of the following?

Options

A : Users to treat the data as if it is at one location

B : Programmers to treat the data as if it is at one location

C : Managers to treat the data as if it is at one location

D : All of the above.

View Answer

A heterogeneous distributed database is which of the following?

Options

A : The same DBMS is used at each location and data are not distributed across all nodes.

B : The same DBMS is used at each location and data are distributed across all nodes.

C : A different DBMS is used at each location and data are not distributed across all nodes.

D : A different DBMS is used at each location and data are distributed across all nodes.

View Answer

Some of the columns of a relation are at different sites is which of the following?

Options

A : Data Replication

B : Horizontal Partitioning

C : Vertical Partitioning

D : Horizontal and Vertical Partitioning

View Answer

Which of the following is true concerning a global transaction?

Options

A : The required data are at one local site and the distributed DBMS routes requests as necessary.

B : The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.

C : The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.

D : The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

View Answer

A homogenous distributed database is which of the following?

Options

A : The same DBMS is used at each location and data are not distributed across all nodes.

B : The same DBMS is used at each location and data are distributed across all nodes.

C : A different DBMS is used at each location and data are not distributed across all nodes.

D : A different DBMS is used at each location and data are distributed across all nodes.

View Answer

Replication should be used when which of the following exist?

Options

A : When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.

B : When using many nodes with different operating systems and DBMSs and database designs.

C : The application's data can be somewhat out-of-date.

D : All of the above.

View Answer

Storing a separate copy of the database at multiple locations is which of the following?

Options

A : Data Replication

B : Horizontal Partitioning

C : Vertical Partitioning

D : Horizontal and Vertical Partitioning

View Answer

Advanced SQL - General Questions more Online Exam Quiz

Database Design Using Normalization - General Questions

Database Processing for BIS - General Questions

Database Redesign - General Questions

Data Modeling with ER Model - General Questions

Data Warehousing - General Questions

Introduction to Database - General Questions

Introduction to SQL - General Questions

JDBC, Java Server Pages, and MySQL - General Questions

Logical Database Design - General Questions

Managing Databases with Oracle - General Questions