Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Ch 12 MySQL

memorize.ai (lvl 286)

(0)

25 cards

()

Section 1

Preview this deck

A distributed database is composed of several parts known as database _____. a. sections b. parts c. partitions d. fragments

Front

1 / 25

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (25)

Section 1

(25 cards)

A distributed database is composed of several parts known as database _____. a. sections b. parts c. partitions d. fragments

Front

d. fragments

Back

The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state. a. two-phase commit protocol (2PC) b. DO-UNDO-REDO protocol c. write-ahead protocol d. coordinator protocol

Front

a. two-phase commit protocol (2PC)

Back

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. a. data processor b. application processor c. transaction manager d. transaction processor

Front

a. data processor

Back

_____ transparency ensures that the system will continue to operate in the event of a node or network malfunction. a. Failure b. Distribution c. Transaction d. Performance

Front

a. Failure

Back

Distributed processing does not require: a. a network of interconnected components. b. multiple sites to share processing chores. c. an existing distributed database. d. database processing functions to be distributed to all data storage sites.

Front

c. an existing distributed database.

Back

_____ transparency allows the system to operate as if it were a centralized database management system. a. Distribution b. Heterogeneity c. Performance d. Failure

Front

c. Performance

Back

_____ fragmentation refers to the division of a relation into subsets of tuples. a. Data b. Vertical c. Mixed d. Horizontal

Front

d. Horizontal

Back

A centralized database management is subject to a problem such as _____. a. maintaining and operating small database systems b. dependence on multiple sites c. a growing number of remote locations d. organizational flexibility of the database

Front

c. a growing number of remote locations

Back

A _____ contains the description of the entire database as seen by the database administrator. a. distributed global dictionary b. distributed data dictionary c. distributed data schema d. distributed global schema

Front

b. distributed data dictionary

Back

The _____ rule requires that all copies of data fragments be identical. a. replication b. mutual consistency c. horizontal fragmentation d. shared fragment

Front

b. mutual consistency

Back

_____ transparency allows data to be updated simultaneously at several network sites. a. Transaction b. Distribution c. Performance d. Failure

Front

a. Transaction

Back

_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B. a. Network latency b. Data distribution c. Replica transparency d. Network partitioning

Front

a. Network latency

Back

_____ is a disadvantage of a distributed database management system (DDBMS). a. Increased danger of a single-point failure b. Processor dependence c. Security lapse d. Lack of graphical user interface

Front

c. Security lapse

Back

A(n) _____ database stores each database fragment at a single site. a. partially replicated b. partitioned c. unreplicated d. fully replicated

Front

c. unreplicated

Back

_____ transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema. a. Distribution b. Transaction c. Heterogeneity d. Performance

Front

c. Heterogeneity

Back

_____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned. a. Local mapping b. Location c. Performance d. Fragmentation

Front

d. Fragmentation

Back

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor. a. distributed transaction b. remote transaction c. remote request d. distributed request

Front

c. remote request

Back

A database management system needs _____ to prepare the data for presentation to the end user or to an application program. a. concurrency control b. I/O interface c. formatting d. security

Front

c. formatting

Back

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location. a. multiple-site processing, multiple-site data b. multiple-site processing, single-site data c. single-site processing, multiple-site data d. single-site processing, single-site data

Front

b. multiple-site processing, single-site data

Back

The _____ processor is the software component residing on each computer that stores and retrieves data located at the site. a. data b. transaction c. management d. network

Front

a. data

Back

_____ transparency allows a physically dispersed database to be managed as though it were centralized. a. Distribution b. Transaction c. Performance d. Failure

Front

a. Distribution

Back

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located. a. Fragmentation b. Transaction c. Local mapping d. Location

Front

d. Location

Back

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems. a. fully heterogeneous b. homogeneous c. heterogeneous d. fully homogeneous

Front

a. fully heterogeneous

Back

_____ distributed database systems integrate different types of centralized database management systems (DBMS) over a network. a. Homogeneous b. Combination c. Fully homogeneous d. Heterogeneous

Front

d. Heterogeneous

Back

_____ transparency exists when the end user or programmer must specify both the fragment names and their locations. a. Local mapping b. Fragmentation c. Location d. Performance

Front

a. Local mapping

Back