WGU D426 (v2) Revised 2024

WGU D426 (v2) Revised 2024 The relationship that describes how one attribute's value can determine another's - ANSWER Functional Dependency An attribute determining the value of another attribute - ANSWER Determinant Unique and minimal attribute determining non-key attributes - ANSWER Candidate Key Defines and manages database structures - ANSWER DDL Manipulates data: adding, deleting, modifying - ANSWER DML Manages user accounts and permissions - ANSWER DCL Commands: CREATE, DROP, ALTER, TRUNCATE, RENAME - ANSWER DDL Stored view that updates when underlying data changes - ANSWER Materialized View Computed view not stored in memory - ANSWER Virtual View Information describing data elements - ANSWER Metadata Ordered collection of elements in parentheses - ANSWER Tuple Percentage of table rows a query selects - ANSWER Hit Ratio