WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA PRE-TEST EXAM NEWEST
2025 ACTUAL LATEST VERSIONS |ALREADY GRADED A+
What is a file having no internal hierarchy - (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 - (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. - (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 - (ANSWER)Hashed files
What are some advantages of a DBMS - (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 - (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 - (ANSWER)Analytical database
What are the two components of a analytical database - (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. - (ANSWER)A Field
, WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA PRE-TEST EXAM NEWEST
2025 ACTUAL LATEST VERSIONS |ALREADY GRADED A+
What is a logically connected set of one or more fields that describes a person, place, or
thing. - (ANSWER)A Record
What is a collection of related records - (ANSWER)File
What exists when you can change the file structure without affecting the application's
ability to access the data - (ANSWER)structural independence !@#$%^&*(*
&^%$
What exists when you can change the data storage characteristics without affecting the
program's ability to access the data - (ANSWER)data independence
What is another word for a tuple - (ANSWER)A row
Another word for a column - (ANSWER)A field
What data model has both data and its relationships are contained in a single structure
known as an object - (ANSWER)Object-oriented data model
What are the components of an object-oriented data model - (ANSWER)An object is an
abstraction of a real-world entity
Attributes describe the properties of an object
Objects that share similar characteristics are grouped in classes
Classes are organized in a class hierarchy
Inheritance is the ability of an object within the class hierarchy to inherit the attributes and
methods of the classes above it
Object-oriented data models are typically depicted using Unified Modeling Language (UML)
class diagrams
What are the characteristics of a NoSQL database - (ANSWER)They are not based on the
relational model and SQL, hence the name NoSQL.
They support distributed database architectures.
2025 ACTUAL LATEST VERSIONS |ALREADY GRADED A+
What is a file having no internal hierarchy - (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 - (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. - (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 - (ANSWER)Hashed files
What are some advantages of a DBMS - (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 - (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 - (ANSWER)Analytical database
What are the two components of a analytical database - (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. - (ANSWER)A Field
, WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA PRE-TEST EXAM NEWEST
2025 ACTUAL LATEST VERSIONS |ALREADY GRADED A+
What is a logically connected set of one or more fields that describes a person, place, or
thing. - (ANSWER)A Record
What is a collection of related records - (ANSWER)File
What exists when you can change the file structure without affecting the application's
ability to access the data - (ANSWER)structural independence !@#$%^&*(*
&^%$
What exists when you can change the data storage characteristics without affecting the
program's ability to access the data - (ANSWER)data independence
What is another word for a tuple - (ANSWER)A row
Another word for a column - (ANSWER)A field
What data model has both data and its relationships are contained in a single structure
known as an object - (ANSWER)Object-oriented data model
What are the components of an object-oriented data model - (ANSWER)An object is an
abstraction of a real-world entity
Attributes describe the properties of an object
Objects that share similar characteristics are grouped in classes
Classes are organized in a class hierarchy
Inheritance is the ability of an object within the class hierarchy to inherit the attributes and
methods of the classes above it
Object-oriented data models are typically depicted using Unified Modeling Language (UML)
class diagrams
What are the characteristics of a NoSQL database - (ANSWER)They are not based on the
relational model and SQL, hence the name NoSQL.
They support distributed database architectures.
