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 1 / 3
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 Directly reads blocks without using an index - ANSWER Table Scan Reads index blocks to locate table blocks - ANSWER Index Scan 2 / 3
Database splits the index until a match is found - ANSWER Binary Search Database object mapping tables to a file - ANSWER Tablespace Specifies tables and keys, also called a schema - ANSWER Logical Design Specifies how tables are stored on media - ANSWER Physical Design Components and relationships in a computer system - ANSWER Architecture Direct interface with database users, includes APIs - ANSWER Tools Interprets and compiles queries - ANSWER Query Processor Link between tools and query processor - ANSWER Connection
- / 3