CSCI 4400 MIDTERM REVIEW
QUESTIONS AND ANSWERS
T-or-F:-A-data-warehouse-can-store-data-derived-from-many-sources.---ans-✔✔True
What-is-the-result-of-revealing-the-meaning-of-raw-facts?
A.-End-User-Data
B.-An-encoded-sample
C.-An-encrypted-bit
D.-Information---ans-✔✔D.-Information
A-desktop-database-is-a-___-database.
A.-Single-User
B.-Multiuser
C.-Workgroup
D.-Distributed---ans-✔✔A.-Single-User
T-or-F:-One-advantage-of-a-database-system-over-previous-data-management-
approaches-is-that-the-database-system-is-considerably-less-complex.---ans-✔✔False
Accurate,-relevant,-and-timely-information-is-the-key-to-___.
A.-Data-Management
B.-Good-decision-making
C.-Knowledge
D.-Understanding---ans-✔✔B.-Good-decision-making
T-or-F:-Database-programming-languages-receive-all-application-requests-and-translate-
them-into-the-complex-operations-required-to-fulfill-those-requests.---ans-✔✔False
Data-is-said-to-be-verifiable-if:
A.-the-data-always-yields-consistent-results
B.-the-data-cannot-be-changed-or-manipulated
C.-the-data-is-obtained-from-trusted-sources
D.-the-data-is-stored-in-different-places-within-the-database---ans-✔✔A.-the-data-always-
yields-consistent-results
A(n)-____-database-is-used-by-an-organization-and-supports-many-users-across-many-
departments.-
,A.-desktop
B.-workgroup
C.-enterprise
D.-transactional---ans-✔✔C.-enterprise
A-workgroup-database-is-a(n)-____-database.
A.-single-user
B.-multiuser
C.-desktop
D.-distributed---ans-✔✔B.-multiuser
T-or-F:-Metadata-describe-the-data-characteristics-and-the-set-of-the-relationships-that-
links-the-data-found-within-the-database.---ans-✔✔True
A-____-is-a-collection-of-related-records.-
A.-schema
B.-field
C.-column
D.-file---ans-✔✔D.-file
A(n)-_____-database-supports-a-relatively-small-number-of-users-(usually-fewer-than-50)-
or-a-specific-department-within-an-organization.
A.-desktop
B.-workgroup
C.-enterprise
D.-transactional---ans-✔✔B.-workgroup
_____-are-the-result-of-formatting-disorganized-data-in-order-to-facilitate-storage,-use-and-
generation-of-information.-
A.-Structured-Data
B.-Raw-Data
C.-Unstructured-Data
D.-Obsolete-Data---ans-✔✔A.-Structured-Data
T-or-F:-One-disadvantage-of-a-database-system-over-previous-data-management-
approaches-is-increased-costs.---ans-✔✔True
The-organization-of-data-within-folders-in-a-manual-file-system-is-determined-by-____.
A.-its-date-creation
B.-its-expected-use
C.-the-title-of-the-documents-in-the-folder
D.-the-data-processing-specialist---ans-✔✔B.-its-expected-use
T-or-F:-One-disadvantage-of-the-DBMS-is-that-it-increases-the-risk-of-data-security-
breaches.---ans-✔✔False
, T-or-F:-Data-and-information-are-essentially-the-same-thing.---ans-✔✔False
The-database-structure-in-a-DBMS-is-stored-as-a-____.
A.-single-file
B.-collection-of-files
C.-set-of-key/value-pairs
D.-collection-of-queries---ans-✔✔B.-collection-of-files
____-data-exists-in-the-format-in-which-they-were-collected.
A.-Structured
B.-Semistructured
C.-Unstructured
D.-Historical---ans-✔✔C.-Unstructured
____-provides-a-description-of-the-data-characteristics-and-the-set-of-relationships-that-
link-the-data-found-within-the-database.-
A.-Queries
B.-End-user-data
C.-Metadata
D.-Schemas---ans-✔✔C.-Metadata
T-or-F:-The-hierarchical-model-is-software-independent.---ans-✔✔False
T-or-F:-Business-rules-must-be-rendered-in-writing.---ans-✔✔True
T-or-F:-The-relational-model-is-hardware-dependent-and-software-independent.---ans-
✔✔False
T-or-F:-The-external-model-is-the-representation-of-the-database-as-"seen"-by-the-
DBMS.---ans-✔✔False
T-or-F:-Today,-most-relational-database-products-can-be-classified-as-object/relational.---
ans-✔✔True
In-the-____-model,-the-basic-logical-structure-is-represented-as-an-upside-down-tree.
A.-hierarchical
B.-network
C.-relational
D.-entity-relationship---ans-✔✔A.-hierarchical
T-or-F:-Database-designers-determine-the-data-and-information-that-yield-the-required-
understanding-of-the-entire-business.---ans-✔✔False
A-noun-in-a-business-rule-translates-to-a(n)-___-in-the-data-model.
A.-entity
B.-attribute
QUESTIONS AND ANSWERS
T-or-F:-A-data-warehouse-can-store-data-derived-from-many-sources.---ans-✔✔True
What-is-the-result-of-revealing-the-meaning-of-raw-facts?
A.-End-User-Data
B.-An-encoded-sample
C.-An-encrypted-bit
D.-Information---ans-✔✔D.-Information
A-desktop-database-is-a-___-database.
A.-Single-User
B.-Multiuser
C.-Workgroup
D.-Distributed---ans-✔✔A.-Single-User
T-or-F:-One-advantage-of-a-database-system-over-previous-data-management-
approaches-is-that-the-database-system-is-considerably-less-complex.---ans-✔✔False
Accurate,-relevant,-and-timely-information-is-the-key-to-___.
A.-Data-Management
B.-Good-decision-making
C.-Knowledge
D.-Understanding---ans-✔✔B.-Good-decision-making
T-or-F:-Database-programming-languages-receive-all-application-requests-and-translate-
them-into-the-complex-operations-required-to-fulfill-those-requests.---ans-✔✔False
Data-is-said-to-be-verifiable-if:
A.-the-data-always-yields-consistent-results
B.-the-data-cannot-be-changed-or-manipulated
C.-the-data-is-obtained-from-trusted-sources
D.-the-data-is-stored-in-different-places-within-the-database---ans-✔✔A.-the-data-always-
yields-consistent-results
A(n)-____-database-is-used-by-an-organization-and-supports-many-users-across-many-
departments.-
,A.-desktop
B.-workgroup
C.-enterprise
D.-transactional---ans-✔✔C.-enterprise
A-workgroup-database-is-a(n)-____-database.
A.-single-user
B.-multiuser
C.-desktop
D.-distributed---ans-✔✔B.-multiuser
T-or-F:-Metadata-describe-the-data-characteristics-and-the-set-of-the-relationships-that-
links-the-data-found-within-the-database.---ans-✔✔True
A-____-is-a-collection-of-related-records.-
A.-schema
B.-field
C.-column
D.-file---ans-✔✔D.-file
A(n)-_____-database-supports-a-relatively-small-number-of-users-(usually-fewer-than-50)-
or-a-specific-department-within-an-organization.
A.-desktop
B.-workgroup
C.-enterprise
D.-transactional---ans-✔✔B.-workgroup
_____-are-the-result-of-formatting-disorganized-data-in-order-to-facilitate-storage,-use-and-
generation-of-information.-
A.-Structured-Data
B.-Raw-Data
C.-Unstructured-Data
D.-Obsolete-Data---ans-✔✔A.-Structured-Data
T-or-F:-One-disadvantage-of-a-database-system-over-previous-data-management-
approaches-is-increased-costs.---ans-✔✔True
The-organization-of-data-within-folders-in-a-manual-file-system-is-determined-by-____.
A.-its-date-creation
B.-its-expected-use
C.-the-title-of-the-documents-in-the-folder
D.-the-data-processing-specialist---ans-✔✔B.-its-expected-use
T-or-F:-One-disadvantage-of-the-DBMS-is-that-it-increases-the-risk-of-data-security-
breaches.---ans-✔✔False
, T-or-F:-Data-and-information-are-essentially-the-same-thing.---ans-✔✔False
The-database-structure-in-a-DBMS-is-stored-as-a-____.
A.-single-file
B.-collection-of-files
C.-set-of-key/value-pairs
D.-collection-of-queries---ans-✔✔B.-collection-of-files
____-data-exists-in-the-format-in-which-they-were-collected.
A.-Structured
B.-Semistructured
C.-Unstructured
D.-Historical---ans-✔✔C.-Unstructured
____-provides-a-description-of-the-data-characteristics-and-the-set-of-relationships-that-
link-the-data-found-within-the-database.-
A.-Queries
B.-End-user-data
C.-Metadata
D.-Schemas---ans-✔✔C.-Metadata
T-or-F:-The-hierarchical-model-is-software-independent.---ans-✔✔False
T-or-F:-Business-rules-must-be-rendered-in-writing.---ans-✔✔True
T-or-F:-The-relational-model-is-hardware-dependent-and-software-independent.---ans-
✔✔False
T-or-F:-The-external-model-is-the-representation-of-the-database-as-"seen"-by-the-
DBMS.---ans-✔✔False
T-or-F:-Today,-most-relational-database-products-can-be-classified-as-object/relational.---
ans-✔✔True
In-the-____-model,-the-basic-logical-structure-is-represented-as-an-upside-down-tree.
A.-hierarchical
B.-network
C.-relational
D.-entity-relationship---ans-✔✔A.-hierarchical
T-or-F:-Database-designers-determine-the-data-and-information-that-yield-the-required-
understanding-of-the-entire-business.---ans-✔✔False
A-noun-in-a-business-rule-translates-to-a(n)-___-in-the-data-model.
A.-entity
B.-attribute
