Wgu D426 - Data Management Foundations Study Guide Graded A+

Magnetic disk / hard-disk drive (HDD) {Ans: used to store large amounts of data.}sparse index {Ans: contains an entry for every table block.}independent / dependent {Ans: Refer to strong entities as independent and weak entities as dependent.}replicated catalog {Ans: a copy of the catalog resides on each node.}SQLite {Ans: the dominant embedded relational database.}pages {Ans: Flash memory groups data in pages, usually between 2 kilobytes and 16 kilobytes per page.}LIMIT {Ans: limits the number of rows returned by a SELECT statement.}Entity {Ans: a person, place, product, concept, or activity.}SUM() {Ans: sums all the values in the set.}file system {Ans: The fi le system accesses data on storage media. The fi le system contains both system and user data, such as log fi les, tables, and indexes.}SQL is divided into five sublanguages: {Ans: - DDL defines the structure of the database. - DQL retrieves data from the database. - DML manipulates data stored in a database. - DCL controls database user access. - DTL manages database transactions}result table {Ans: The SELECT statement returns a set of rows, called the result table.}fully NULL {Ans: a simple or composite foreign