Question 1

A user-friendly is one advantage of a distributed database management system (DDBMS).

Accepted Answer

interface

Question 2

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

Accepted Answer

point

Question 3

Discuss the CAP Theorem and the three desirable properties it mentions.

Accepted Answer

According to Dr.Eric Brewer,there are three commonly desirable properties in any highly distributed data system - consistency,availability,and partition tolerance.However,it is impossible for a system to provide all three at the same time.Consistency takes a bigger role in a distributed database.All nodes should see the same data at the same time which means the replicas should be immediately undated.This involves dealing with latency and network partitioning delays.Availability is a paramount requirement of all web-centric organizations.No received request should ever be lost and requests should always be filled by the system.Partition tolerance means the system continues to operate even in the event of a node failure and will fail only if all nodes fail.

Question 4

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 5

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 6

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

Accepted Answer

Transaction transparency is a DDBMS prop

Question 7

A transaction processor is also known as the processor.

Accepted Answer

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

Question 8

In the single-site processing,single-site data (SPSD)scenario,all processing must be done on the end user's side of the system.

Accepted Answer

A) True 
 B)False

Question 9

In theory,a(n)can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

Accepted Answer

A) transaction processor 
B) application processor 
C) transaction manager 
D) data processor 
A) transaction processor 
B) application processor 
C) transaction manager 
D) data processor

Question 10

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 11

A database management system (DBMS)must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.

Accepted Answer

A) True 
 B)False

Question 14

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 15

One of the advantages of a distributed database management system (DDBMS)is that the data is located near the site with the least demand.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

Accepted Answer

DO-UNDO-REDO DO UNDO

Question 18

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 19

management ensures that data move from one consistent state to another.

Accepted Answer

The answer of management ensures that data move from one...

Question 20

fragmentation allows a user to break a single object into two or more segments,or fragments.

Accepted Answer

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

A user-friendly is one advantage of a distributed database management system (DDBMS).

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

Discuss the CAP Theorem and the three desirable properties it mentions.

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

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

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

A transaction processor is also known as the processor.

In the single-site processing,single-site data (SPSD)scenario,all processing must be done on the end user's side of the system.

In theory,a(n)can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

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

A database management system (DBMS)must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

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

Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.

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

One of the advantages of a distributed database management system (DDBMS)is that the data is located near the site with the least demand.

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

The protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

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

management ensures that data move from one consistent state to another.

fragmentation allows a user to break a single object into two or more segments,or fragments.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 12: Distributed Database Management Systems

A user-friendly is one advantage of a distributed database management system (DDBMS).

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

Discuss the CAP Theorem and the three desirable properties it mentions.

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

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

What is transaction transparency? What are some of the basic concepts that one should know to understand how transactions are managed in a distributed database management system (DDBMS)?

A transaction processor is also known as the processor.

In the single-site processing,single-site data (SPSD)scenario,all processing must be done on the end user's side of the system.

In theory,a(n)can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

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

A database management system (DBMS)must have validation,transformation,and mapping functions,as well as other functions,in order to be classified as distributed.

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

Distributed processing does not require a distributed database,and a distributed database does not require distributed processing.

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

One of the advantages of a distributed database management system (DDBMS)is that the data is located near the site with the least demand.

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

The protocol is used by a DP to roll transactions back and forward with the help of the system's transaction log entries.

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

management ensures that data move from one consistent state to another.

fragmentation allows a user to break a single object into two or more segments,or fragments.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters