Question 1

Distribution transparency is supported by a distributed data dictionary.

Accepted Answer

A) True 
 B)False

Question 2

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

One of the advantages of a distributed database management system (DDBMS) is less danger of a single- failure.

Accepted Answer

The answer of One of the advantages of a distributed...

Question 5

The World Wide Web is the repository for distributed data.

Accepted Answer

A) True 
 B)False

Question 6

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

Accepted Answer

A) True 
 B)False

Question 7

A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Accepted Answer

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

Question 8

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

Accepted Answer

A) True 
 B)False

Question 9

The transaction processor (TP) is the software component found in each computer that requests data.

Accepted Answer

A) True 
 B)False

Question 10

A transaction processor is also known as the processor.

Accepted Answer

The answer of A transaction processor is also known as...

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

multiple-site proces

Question 13

A contains the description of the entire database as seen by the database administrator.

Accepted Answer

A)  distributed global dictionary 
B)  distributed data dictionary 
C)  distributed global schema 
D)  distributed data schema 
A)  distributed global dictionary 
B)  distributed data dictionary 
C)  distributed global schema 
D)  distributed data schema

Question 14

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

Accepted Answer

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

Question 15

A DDBMS is subject to which of the following restrictions?

Accepted Answer

A)  Multiple instances of the same database should be integrated over a network. 
B)  All database processing must be done at a single site. 
C)  Rapid ad hoc data access is not possible. 
D)  Remote data access is provided on a read-only basis. 
A)  Multiple instances of the same database should be integrated over a network. 
B)  All database processing must be done at a single site. 
C)  Rapid ad hoc data access is not possible. 
D)  Remote data access is provided on a read-only basis.

Question 16

The processor is the software component found in each computer that requests data. It receives and processes the application's data requests.

Accepted Answer

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

Question 17

Under the scenario, all record- and file-locking activities are performed at the end-user location.

Accepted Answer

A)  single-site processing, single-site data 
B)  multiple-site processing, single-site data 
C)  single-site processing, multiple-site data 
D)  multiple-site processing, multiple-site data 
A)  single-site processing, single-site data 
B)  multiple-site processing, single-site data 
C)  single-site processing, multiple-site data 
D)  multiple-site processing, multiple-site data

Question 18

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

Accepted Answer

A) True 
 B)False

Question 19

One of the advantages of a distributed database management system (DDBMS) is security.

Accepted Answer

A) True 
 B)False

Question 20

The forces the log entry to be written to permanent storage before the actual operation takes place.

Accepted Answer

write-ahea

Distribution transparency is supported by a distributed data dictionary.

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

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

One of the advantages of a distributed database management system (DDBMS) is less danger of a single- failure.

The World Wide Web is the repository for distributed data.

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

The transaction processor (TP) is the software component found in each computer that requests data.

A transaction processor is also known as the processor.

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

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

A contains the description of the entire database as seen by the database administrator.

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

A DDBMS is subject to which of the following restrictions?

The processor is the software component found in each computer that requests data. It receives and processes the application's data requests.

Under the scenario, all record- and file-locking activities are performed at the end-user location.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

One of the advantages of a distributed database management system (DDBMS) is security.

The forces the log entry to be written to permanent storage before the actual operation takes place.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

Distribution transparency is supported by a distributed data dictionary.

Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.

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

One of the advantages of a distributed database management system (DDBMS) is less danger of a single- failure.

The World Wide Web is the repository for distributed data.

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.

A distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Performance transparency ensures that the system finds the most cost-effective path to access remote data.

The transaction processor (TP) is the software component found in each computer that requests data.

A transaction processor is also known as the processor.

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

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

A contains the description of the entire database as seen by the database administrator.

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

A DDBMS is subject to which of the following restrictions?

The processor is the software component found in each computer that requests data. It receives and processes the application's data requests.

Under the scenario, all record- and file-locking activities are performed at the end-user location.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.

One of the advantages of a distributed database management system (DDBMS) is security.

The forces the log entry to be written to permanent storage before the actual operation takes place.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters