DATA MANAGEMENT FOUNDATIONS
EXAM | QUESTIONS & ANSWERS
(VERIFIED) | LATEST UPDATE | GRADED
A+
PR
file structure
Correct Answer: the format that data is arranged and stored in a file.
O
flat files
FD
Correct Answer: Files having no internal hierarchy
heap files
O
Correct Answer: Files containing an unsorted set of records that are uniquely
identified by a record id which allows them to be inserted or deleted using that id.
C
index files
Correct Answer: Files containing an unsorted set of records that are uniquely
identified by a record id which allows them to be inserted or deleted using that id.
hashed files
1
,Correct Answer: Files which use a hash function to decide where a record should be
placed on a disk. This allows for faster data lookup without the use of an index file.
data
Correct Answer: Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
information
PR
Correct Answer: The result of processing raw data to reveal its meaning. Information
consists of transformed data and facilitates decision making.
O
knowledge
FD
Correct Answer: The body of information and facts about a specific subject. A key
characteristic is that new knowledge can be derived from old knowledge.
O
database management
Correct Answer: A process that focuses on data collection, storage, and retrieval.
C
Common data management functions include addition, deletion, modification, and
listing.
database
2
,Correct Answer: A shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data (raw facts) and
metadata.
DBMS
Correct Answer: The collection of programs that manages the database structure and
controls access to the data stored in the database.
PR
data inconsistency
Correct Answer: A condition in which different versions of the same data yield different
(inconsistent) results.
O
FD
query
Correct Answer: A question or task asked by an end user of a database in the form of
SQL code. A specific request for data manipulation issued by the end user or the
O
application to the DBMS.
C
ad hoc query
Correct Answer: A "spur-of-the-moment" question.
query results set
Correct Answer: The collection of data rows returned by a query.
3
, data quality
Correct Answer: A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data.
DBMS advantages (7)
Correct Answer: - improved data sharing
- improved data security
- better data integration
PR
- minimized data inconsistency
- improved data access
- improved decision making
O
- increased end-user productivity
FD
single vs multiuser database
Correct Answer: supports single or multiple users
O
desktop database
C
Correct Answer: A single-user database that runs on a personal computer.
workgroup database
Correct Answer: A multiuser database that usually supports fewer than 50 users or is
used for a specific department in an organization.
4
EXAM | QUESTIONS & ANSWERS
(VERIFIED) | LATEST UPDATE | GRADED
A+
PR
file structure
Correct Answer: the format that data is arranged and stored in a file.
O
flat files
FD
Correct Answer: Files having no internal hierarchy
heap files
O
Correct Answer: Files containing an unsorted set of records that are uniquely
identified by a record id which allows them to be inserted or deleted using that id.
C
index files
Correct Answer: Files containing an unsorted set of records that are uniquely
identified by a record id which allows them to be inserted or deleted using that id.
hashed files
1
,Correct Answer: Files which use a hash function to decide where a record should be
placed on a disk. This allows for faster data lookup without the use of an index file.
data
Correct Answer: Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
information
PR
Correct Answer: The result of processing raw data to reveal its meaning. Information
consists of transformed data and facilitates decision making.
O
knowledge
FD
Correct Answer: The body of information and facts about a specific subject. A key
characteristic is that new knowledge can be derived from old knowledge.
O
database management
Correct Answer: A process that focuses on data collection, storage, and retrieval.
C
Common data management functions include addition, deletion, modification, and
listing.
database
2
,Correct Answer: A shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data (raw facts) and
metadata.
DBMS
Correct Answer: The collection of programs that manages the database structure and
controls access to the data stored in the database.
PR
data inconsistency
Correct Answer: A condition in which different versions of the same data yield different
(inconsistent) results.
O
FD
query
Correct Answer: A question or task asked by an end user of a database in the form of
SQL code. A specific request for data manipulation issued by the end user or the
O
application to the DBMS.
C
ad hoc query
Correct Answer: A "spur-of-the-moment" question.
query results set
Correct Answer: The collection of data rows returned by a query.
3
, data quality
Correct Answer: A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data.
DBMS advantages (7)
Correct Answer: - improved data sharing
- improved data security
- better data integration
PR
- minimized data inconsistency
- improved data access
- improved decision making
O
- increased end-user productivity
FD
single vs multiuser database
Correct Answer: supports single or multiple users
O
desktop database
C
Correct Answer: A single-user database that runs on a personal computer.
workgroup database
Correct Answer: A multiuser database that usually supports fewer than 50 users or is
used for a specific department in an organization.
4
