DATA MANAGEMENT FOUNDATIONS STUDY GUIDE C175 QUESTIONS WITH CORRECT DETAILED ANSWERS A+ (2025&2026)

DATA MANAGEMENT FOUNDATIONS STUDY GUIDE C175 QUESTIONS WITH CORRECT DETAILED ANSWERS A+ (2025&2026) Why databases? - correct answers-·Helps organizations use data / information as a resource to make decisions File based structure (Prior to BDMS) - correct answers-o Attempt to computerize old manual filing system o Was easy to retrieve small amounts of information from o As data grew, it became difficult to locate and retrieve information o Retrieval speed depended on file structure and how data was organized within the structure File types that utilized file based structure - correct answers-Flat files, heap files, Index files, hashed files Flat files - correct answers-no internal hierarchy and data is unstructured Heap files - correct answers-unsorted set of records uniquely identified by record ID -allows heap files to be inserted or deleted using ID index files - correct answers-· File that stores a list of Look Up Field values from data file that includes the location (address) in the data file of the corresponding record · Smaller than the entire record, usually fits in main memory for quick look up · Lists keywords and phrases that are in a particular file · Becomes a pointer to the location in the file where the information can be found when stored with keywords and phrases hashed files - correct answers-· Uses hash functions to decide where records should be placed on a disk · Allows for faster data look up without the use of an index file