INF 3703 TIPS SET ANSWERS AND QUESTIONS SET
A+
✔✔*A DDBMS is subject to which restriction?
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 - ✔✔d. Remote data access is
provided on a read-only basis
✔✔*_____ transparency allows a physically dispersed database to be managed as
though it were centralized.
a. Distribution
b. Transaction
c. Failure
d. Performance - ✔✔a. Distribution
✔✔*_____ transparency allows data to be updated simultaneously at several network
sites.
a. Transaction
b. Distribution
c. Failure
d. Performance - ✔✔a. Transaction
✔✔_____ transparency allows the system to operate as if it were a centralized
database management system.
a. Heterogeneity
b. Distribution
c. Performance
d. Failure - ✔✔c. Performance
✔✔_____ transparency is the highest level of transparency. The end user or
programmer does not need to know that a database is partitioned.
a. Performance
, b. Fragmentation
c. Location
d. Local mapping - ✔✔b. Fragmentation
✔✔_____ 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. Transaction
b. Location
c. Local mapping
d. Fragmentation - ✔✔b. Location
✔✔A distributed _____ contains the description of the entire database as seen by the
database administrator.
a. global index
b. data dictionary
c. global catalog
d. data thesaurus - ✔✔b. data dictionary
✔✔*A _____ lets a single SQL statement access the data that are to be processed by a
single remote database processor.
a. remote request
b. remote transaction
c. distributed request
d. distributed transaction - ✔✔a. remote request
✔✔A distributed _____ can reference several different local or remote data processing
sites.
a. request
b. site
c. data location
d. transaction - ✔✔d. transaction
✔✔A _____ request lets a single SQL statement reference data located at several
different local or remote DP sites.
a. distributed
b. transaction
c. fragmented
d. remote - ✔✔a. distributed
✔✔*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. DO-UNDO-REDO protocol
b. two-phase commit protocol (2PC)
A+
✔✔*A DDBMS is subject to which restriction?
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 - ✔✔d. Remote data access is
provided on a read-only basis
✔✔*_____ transparency allows a physically dispersed database to be managed as
though it were centralized.
a. Distribution
b. Transaction
c. Failure
d. Performance - ✔✔a. Distribution
✔✔*_____ transparency allows data to be updated simultaneously at several network
sites.
a. Transaction
b. Distribution
c. Failure
d. Performance - ✔✔a. Transaction
✔✔_____ transparency allows the system to operate as if it were a centralized
database management system.
a. Heterogeneity
b. Distribution
c. Performance
d. Failure - ✔✔c. Performance
✔✔_____ transparency is the highest level of transparency. The end user or
programmer does not need to know that a database is partitioned.
a. Performance
, b. Fragmentation
c. Location
d. Local mapping - ✔✔b. Fragmentation
✔✔_____ 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. Transaction
b. Location
c. Local mapping
d. Fragmentation - ✔✔b. Location
✔✔A distributed _____ contains the description of the entire database as seen by the
database administrator.
a. global index
b. data dictionary
c. global catalog
d. data thesaurus - ✔✔b. data dictionary
✔✔*A _____ lets a single SQL statement access the data that are to be processed by a
single remote database processor.
a. remote request
b. remote transaction
c. distributed request
d. distributed transaction - ✔✔a. remote request
✔✔A distributed _____ can reference several different local or remote data processing
sites.
a. request
b. site
c. data location
d. transaction - ✔✔d. transaction
✔✔A _____ request lets a single SQL statement reference data located at several
different local or remote DP sites.
a. distributed
b. transaction
c. fragmented
d. remote - ✔✔a. distributed
✔✔*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. DO-UNDO-REDO protocol
b. two-phase commit protocol (2PC)
