(Top QUALITY 2024/2025 EXAM REVIEW) WGU C175 Data ManagementFoundations. Full Coverage. Questions and answers. Graded A+

WGU C175 Data ManagementFoundations. Full Coverage. Questions and answers. Graded A+ 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 2 -Improved data sharing -Improved data security -Better data integration -Minimized data inconsistency -Improved data access -Improved decision making -Increased end-user productivity - Operational database, also known as an online transaction processing (OLTP) database, transactional database, or production database - -What is a database that is designed primarily to support a company's day-to-day operation