WGU C175 Data Management-Foundations
UPDATED ACTUAL Exam Questions and
CORRECT Answers
What is a file having no internal hierarchy - CORRECT ANSWER - Flat files
What are 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 - CORRECT ANSWER - Heap
files
What are files that store a list of lookup field values from a data file - along with the location
(address) in the data file of the corresponding record. Because the lookup field is much smaller
than the entire record, the entire index will usually fit in main memory for quick look up. Once
the address of the record is obtained from the index, the entire record can then be directly
accessed from the data file instead of reading in the entire data file - record by record, in order to
locate the desired one. - CORRECT ANSWER - Index files
What are files are encrypted using hash functions that convert data consisting of various formats
into numeric values. This allows for faster data lookup without the use of an index file -
CORRECT ANSWER - Hashed files
What are some advantages of a DBMS - CORRECT ANSWER - -Improved data sharing
-Improved data security
-Better data integration
-Minimized data inconsistency
-Improved data access
-Improved decision making
-Increased end-user productivity
, What is a database that is designed primarily to support a company's day-to-day operations -
CORRECT ANSWER - Operational database, also known as an online transaction
processing (OLTP) database, transactional database, or production database
What type of database focuses primarily on storing historical data and business metrics used
exclusively for tactical or strategic decision making - CORRECT ANSWER - Analytical
database
What are the two components of a analytical database - CORRECT ANSWER - Data
warehouse, Online analytical processing (OLAP) front end
What is a character or group of characters (alphabetic or numeric) that has a specific meaning. -
CORRECT ANSWER - A Field
What is a logically connected set of one or more fields that describes a person, place, or thing. -
CORRECT ANSWER - A Record
What is a collection of related records - CORRECT ANSWER - File
What exists when you can change the file structure without affecting the application's ability to
access the data - CORRECT ANSWER - structural independence
What exists when you can change the data storage characteristics without affecting the program's
ability to access the data - CORRECT ANSWER - data independence
What is another word for a tuple - CORRECT ANSWER - A row
Another word for a column - CORRECT ANSWER - A field
What data model has both data and its relationships are contained in a single structure known as
an object - CORRECT ANSWER - Object-oriented data model
UPDATED ACTUAL Exam Questions and
CORRECT Answers
What is a file having no internal hierarchy - CORRECT ANSWER - Flat files
What are 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 - CORRECT ANSWER - Heap
files
What are files that store a list of lookup field values from a data file - along with the location
(address) in the data file of the corresponding record. Because the lookup field is much smaller
than the entire record, the entire index will usually fit in main memory for quick look up. Once
the address of the record is obtained from the index, the entire record can then be directly
accessed from the data file instead of reading in the entire data file - record by record, in order to
locate the desired one. - CORRECT ANSWER - Index files
What are files are encrypted using hash functions that convert data consisting of various formats
into numeric values. This allows for faster data lookup without the use of an index file -
CORRECT ANSWER - Hashed files
What are some advantages of a DBMS - CORRECT ANSWER - -Improved data sharing
-Improved data security
-Better data integration
-Minimized data inconsistency
-Improved data access
-Improved decision making
-Increased end-user productivity
, What is a database that is designed primarily to support a company's day-to-day operations -
CORRECT ANSWER - Operational database, also known as an online transaction
processing (OLTP) database, transactional database, or production database
What type of database focuses primarily on storing historical data and business metrics used
exclusively for tactical or strategic decision making - CORRECT ANSWER - Analytical
database
What are the two components of a analytical database - CORRECT ANSWER - Data
warehouse, Online analytical processing (OLAP) front end
What is a character or group of characters (alphabetic or numeric) that has a specific meaning. -
CORRECT ANSWER - A Field
What is a logically connected set of one or more fields that describes a person, place, or thing. -
CORRECT ANSWER - A Record
What is a collection of related records - CORRECT ANSWER - File
What exists when you can change the file structure without affecting the application's ability to
access the data - CORRECT ANSWER - structural independence
What exists when you can change the data storage characteristics without affecting the program's
ability to access the data - CORRECT ANSWER - data independence
What is another word for a tuple - CORRECT ANSWER - A row
Another word for a column - CORRECT ANSWER - A field
What data model has both data and its relationships are contained in a single structure known as
an object - CORRECT ANSWER - Object-oriented data model
