WGU C175 Data Management Foundations (WGUC175)

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...

ad hoc query - -A "spur-of-the-moment" question. analytical database - -A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. availability - -In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. centralized database - -A database located at a single site. cloud database - -A database that is created and maintained using cloud service...

What is a broad definition of data? a. Numbers that are captured on digital media b. Raw facts that are captured on printed or digital media c. Alphanumeric combinations that can be captured on media that a computer can read d. Any information that can be transferred from print to digital - -b. Raw facts that are captured on printed or digital media What is data? a. Facts that have been organized in a meaningful way b. Facts that are the result of a query of a database system c. Facts t...

ad hoc query A "spur-of-the-moment" question analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database A database located at a single site cloud database A database that is created and maintained using cloud services, such as Microso...

They can serve as a communication tool between the users and designers. Which of the following is true of business rules? entity A(n) _______ is anything about which data are to be collected and stored. XML/Hybrid data model Oracle 11g is an example of the _______. entity instance Each row in the relational table is known as a(n) relational data model MySQL is an example of the _______. attribute A(n) _______ is the equivalent of a field in a file system. entity relationship The _______ m...

ad hoc query A "spur-of-the-moment" question analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database A database located at a single site cloud database A database that is created and maintained using cloud services, such as Microso...