Exam 10: Distributed Databases

The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

(Short Answer)

4.8/5

(36)

Question 41

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

(True/False)

4.9/5

(45)

Question 42

A remote transaction, composed of several requests, may access data at multiple sites.

(True/False)

4.9/5

(29)

Question 43

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

(Multiple Choice)

4.9/5

(31)

Question 44

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

(Multiple Choice)

4.8/5

(43)

Question 45

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

(Short Answer)

4.8/5

(31)

Question 46

____ transparency allows the integration of several different local DBMSs under a common, or global, schema.

(Multiple Choice)

4.9/5

(32)

Question 47

____ distributed database systems integrate different types of centralized DBMSs over a network.

(Multiple Choice)

4.8/5

(33)

Question 48

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

(Multiple Choice)

4.9/5

(31)

Question 49

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

(True/False)

4.7/5

(41)

Question 50

A user-friendly ____________________ is one advantage of a DDBMS.

(Short Answer)

4.7/5

(29)

Question 51

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

(True/False)

4.8/5

(35)

Question 52

A(n) ____ database stores each database fragment at a single site.

(Multiple Choice)

4.8/5

(38)

Question 53

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

(Short Answer)

4.9/5

(31)

Question 54

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

(Multiple Choice)

4.7/5

(31)

Question 55

A DDBMS must be communications-media-dependent.

(True/False)

4.8/5

(32)

Question 56

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

(Short Answer)

5.0/5

(32)

Question 57

In a DDBMS, query ____________________ is used to find the best access strategy.

(Short Answer)

4.9/5

(37)

Question 58

A transaction processor is also known as the ____________________ processor.

(Short Answer)

4.8/5

(35)

Question 59

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

(Multiple Choice)

4.8/5

(27)

Question 60

Showing 41 - 60 of 70

The database description, known as the distributed ____________________ schema, is the common database schema used by local TPs to translate user requests into subqueries (remote requests) that will be processed by different DPs.

A DDBMS governs the storage and processing of logically related data over interconnected computer systems.

A remote transaction, composed of several requests, may access data at multiple sites.

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

____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

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

____ transparency allows the integration of several different local DBMSs under a common, or global, schema.

____ distributed database systems integrate different types of centralized DBMSs over a network.

The ability to execute a ____ request provides fully distributed database processing because you can partition a database table into several fragments.

One of the advantages of a DDBMS is that the data is located near the site with the least demand.

A user-friendly ____________________ is one advantage of a DDBMS.

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

A(n) ____ database stores each database fragment at a single 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.

A DDBMS must be communications-media-dependent.

One of the advantages of a DDBMS is less danger of a single-____________________ failure.

In a DDBMS, query ____________________ is used to find the best access strategy.

A transaction processor is also known as the ____________________ processor.

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters