WGU C170 - Data Management – Applications, 100% Accurate. VERIFIED 2024

Access plan - -A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias - -An alternative name for a column or table in a SQL statement. ALTER TABLE - -The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AREA - -In DB2, a named section of permanent storage space that is reserved to store the database. Atomic attribute - -An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided. Atomicity - -The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted. automatic query optimization - -A method by which a DBMS finds the most efficient access path for the execution of a query. B-tree index - -An ordered data structure organized as an upside-down tree. Base tables - -Tables on which the view is based