WGU C175 Data Management Foundations. Full Coverage. Questions and answers. Graded A+ 2024

Flat files - -What is a file having no internal hierarchy Heap 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 Index 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. Hashed 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 -What are some advantages of a DBMS