Wgu D426 Exam Questions (300 Terms) With Verified Definitions Updated 2024

relationship type {Ans: a set of related things}simply primary key {Ans: this kind of primary key consists of a single column}non-volatile memory {Ans: memory that is retained without power}INNER JOIN {Ans: selects only matching left and right table rows (common join)}BETWEEN {Ans: This operator provides an alternative way to determine if a value is between two other values. (Syntax: value BETWEEN minValue AND maxValue is the same as value >= minValue AND value <= maxValue)}file system {Ans: access data on storage media. the ____________ contains both system and user data, such as log files, tables and indexes.}database model {Ans: a conceptual framework for database systems, with three parts}root account {Ans: the administrative account that has full control of MySQL}multi-level index {Ans: stores column values and row pointers in a hierarchy}TRUNCATE {Ans: this statement deletes all rows from a table}NOT NULL {Ans: a constraint that prevents a column from having a NULL value.}AS {Ans: This keyword follows a column or table name to create an alias}LIMIT {Ans: a SQL clause that limits the number of rows returned by a SELECT statement}candidate key {Ans: a simple or composite