Question 1

One of the tasks that must be performed by all client-server architectures is workflow.Which statement below best describes this task?

Accepted Answer

A)  code to ensure the consistency of the database and user inputs. 
B)  code to perform business functions such as payroll calculations, eligibility requirements, and interest calculations. 
C)  code to ensure completion of business processes 
D)  code to maintain the graphical user interface. 
A)  code to ensure the consistency of the database and user inputs. 
B)  code to perform business functions such as payroll calculations, eligibility requirements, and interest calculations. 
C)  code to ensure completion of business processes 
D)  code to maintain the graphical user interface.

Question 2

In a distributed database environment,a(n)___________________ can be a query that combines data from more than one site or a transaction that updates data at more than one site.

Accepted Answer

The answer of In a distributed database environment,a(n)___________________ can be...

Question 3

Which of the following statement is not true of loosely integrated DBMS?

Accepted Answer

A)  All local DBMS must be relational 
B)  Some local DBMS may be hierarchical 
C)  A local mapping schema provides information to use local data in the distributed database 
D)  A local mapping schema may provide information to use data of a non-standard data type 
A)  All local DBMS must be relational 
B)  Some local DBMS may be hierarchical 
C)  A local mapping schema provides information to use local data in the distributed database 
D)  A local mapping schema may provide information to use data of a non-standard data type

Question 4

Which of the following statements is not true about distributed concurrency control?

Accepted Answer

A)  It is simpler when coordination is centralized rather than distributed 
B)  It has the same type of problems with replicated data when coordination is centralized or is distributed 
C)  It is more reliable when coordination is centralized rather than distributed 
D)  It is more complex than centralized concurrency control 
A)  It is simpler when coordination is centralized rather than distributed 
B)  It has the same type of problems with replicated data when coordination is centralized or is distributed 
C)  It is more reliable when coordination is centralized rather than distributed 
D)  It is more complex than centralized concurrency control

Question 5

Flexibility,scalability,and simplicity are all advantages of distributed processing.

Accepted Answer

A) True 
 B)False

Question 6

Horizontal fragments can be defined using restriction or outer-join operations.

Accepted Answer

A) True 
 B)False

Question 7

In a loosely integrated distributed DBMS environment,a(n)___________________ describes the exportable data at the site and provides conversion rules to translate data from a local format into a global format.

Accepted Answer

local mapp

Question 8

With location transparency,a SELECT query must use the intersection operator to collect the rows from the various fragments.

Accepted Answer

A) True 
 B)False

Question 9

A relational algebra operator that is useful for distributed database processing,in which only the rows of the first table appear in the result,is a(n)________________.

Accepted Answer

The answer of A relational algebra operator that is useful...

Question 10

Which of the following is one of the types of client server architectures discussed?

Accepted Answer

A)  two-tier architecture 
B)  three-tier architecture 
C)  web services architecture 
D)  hyper object broker architecture 
A)  two-tier architecture 
B)  three-tier architecture 
C)  web services architecture 
D)  hyper object broker architecture

Question 11

In a distributed DBMS,the distributed data manager:

Accepted Answer

A)  Optimizes global query execution 
B)  Coordinates global concurrency control 
C)  Coordinates recovery from failures across all sites 
D)  All of the above 
A)  Optimizes global query execution 
B)  Coordinates global concurrency control 
C)  Coordinates recovery from failures across all sites 
D)  All of the above

Question 12

Which one of the following is not true about distributed query processing?

Accepted Answer

A)  Minimizing resources allows for minimizing response time 
B)  For wide area networks, communication costs are often the dominant cost 
C)  For local area networks, communication costs are often comparable to local costs 
D)  Distributed query processing is much more complex than centralized query processing 
A)  Minimizing resources allows for minimizing response time 
B)  For wide area networks, communication costs are often the dominant cost 
C)  For local area networks, communication costs are often comparable to local costs 
D)  Distributed query processing is much more complex than centralized query processing

Question 13

Middleware is a software component in a client-server architecture that performs process management.

Accepted Answer

A) True 
 B)False

Question 14

In a parallel database architecture with clustering,which of the following statements is true about the clustered nothing (CN)architecture?

Accepted Answer

A)  In the CN architecture, the processors in each cluster share all disks, but nothing is shared across clusters. 
B)  In the CN architecture, the processors in each cluster share no resources, but each cluster can be manipulated to work in parallel to perform a task. 
C)  Clustering has no impact on resource sharing or processing of tasks 
D)  All of the above 
A)  In the CN architecture, the processors in each cluster share all disks, but nothing is shared across clusters. 
B)  In the CN architecture, the processors in each cluster share no resources, but each cluster can be manipulated to work in parallel to perform a task. 
C)  Clustering has no impact on resource sharing or processing of tasks 
D)  All of the above

Question 15

The allocation of tasks between clients and servers is known as __________________.

Accepted Answer

division o

Question 16

Which of the following is an advantage of Parallel database processing?

Accepted Answer

A)  speedup 
B)  availability 
C)  scalability for predictive performance improvements 
D)  all of the above 
A)  speedup 
B)  availability 
C)  scalability for predictive performance improvements 
D)  all of the above

Question 17

In multiple-tier client-server database architecture,software maintenance is difficult,it is complex to implement,and it relies mostly on proprietary software rather than open standards.

Accepted Answer

A) True 
 B)False

Question 18

Distributed query processing involves both local and global optimization,so there are more access plans to choose from in distributed query processing than in centralized query processing.

Accepted Answer

A) True 
 B)False

Question 19

In a distributed DBMS environment,the ______________________ optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.

Accepted Answer

distribute

Question 20

Scalability refers to the ability to add and remove capacity in small units.Horizontal scalability refers to the ability to add capacity on the server side.Vertical scalability refers to the ability to add capacity on the client side through additional workstations and movement of work between clients and servers.

Accepted Answer

A) True 
 B)False

One of the tasks that must be performed by all client-server architectures is workflow.Which statement below best describes this task?

In a distributed database environment,a(n)___________________ can be a query that combines data from more than one site or a transaction that updates data at more than one site.

Which of the following statement is not true of loosely integrated DBMS?

Which of the following statements is not true about distributed concurrency control?

Flexibility,scalability,and simplicity are all advantages of distributed processing.

Horizontal fragments can be defined using restriction or outer-join operations.

In a loosely integrated distributed DBMS environment,a(n)___________________ describes the exportable data at the site and provides conversion rules to translate data from a local format into a global format.

With location transparency,a SELECT query must use the intersection operator to collect the rows from the various fragments.

A relational algebra operator that is useful for distributed database processing,in which only the rows of the first table appear in the result,is a(n)________________.

Which of the following is one of the types of client server architectures discussed?

In a distributed DBMS,the distributed data manager:

Which one of the following is not true about distributed query processing?

Middleware is a software component in a client-server architecture that performs process management.

In a parallel database architecture with clustering,which of the following statements is true about the clustered nothing (CN)architecture?

The allocation of tasks between clients and servers is known as __________________.

Which of the following is an advantage of Parallel database processing?

In multiple-tier client-server database architecture,software maintenance is difficult,it is complex to implement,and it relies mostly on proprietary software rather than open standards.

Distributed query processing involves both local and global optimization,so there are more access plans to choose from in distributed query processing than in centralized query processing.

In a distributed DBMS environment,the ______________________ optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Object Database Management Systems

Filters

Exam 17: Client-Server Processing and Distributed Databases

One of the tasks that must be performed by all client-server architectures is workflow.Which statement below best describes this task?

In a distributed database environment,a(n)___________________ can be a query that combines data from more than one site or a transaction that updates data at more than one site.

Which of the following statement is not true of loosely integrated DBMS?

Which of the following statements is not true about distributed concurrency control?

Flexibility,scalability,and simplicity are all advantages of distributed processing.

Horizontal fragments can be defined using restriction or outer-join operations.

In a loosely integrated distributed DBMS environment,a(n)___________________ describes the exportable data at the site and provides conversion rules to translate data from a local format into a global format.

With location transparency,a SELECT query must use the intersection operator to collect the rows from the various fragments.

A relational algebra operator that is useful for distributed database processing,in which only the rows of the first table appear in the result,is a(n)________________.

Which of the following is one of the types of client server architectures discussed?

In a distributed DBMS,the distributed data manager:

Which one of the following is not true about distributed query processing?

Middleware is a software component in a client-server architecture that performs process management.

In a parallel database architecture with clustering,which of the following statements is true about the clustered nothing (CN)architecture?

The allocation of tasks between clients and servers is known as __________________.

Which of the following is an advantage of Parallel database processing?

In multiple-tier client-server database architecture,software maintenance is difficult,it is complex to implement,and it relies mostly on proprietary software rather than open standards.

Distributed query processing involves both local and global optimization,so there are more access plans to choose from in distributed query processing than in centralized query processing.

In a distributed DBMS environment,the ______________________ optimizes query execution across sites,coordinates concurrency control and recovery across sites,and controls access to remote data.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Object Database Management Systems

Filters