Wgu - D426: Objective Assessment Exam Questions (151 Terms) With Verified Definitions Updated 2024

Metadata {Ans: Data about the database, such as column names and the number of rows in each table.}HAVING (Clause) {Ans: The HAVING clause is used with the GROUP BY clause to filter group results.}OUTER JOIN {Ans: Any join that selects unmatched rows, including left, right, and full joins.}FULL JOIN {Ans: Selects all left and right table rows, regardless of match.}Logical Design Phase (First Step) {Ans: Each entity becomes a table and each attribute becomes a column. Tables and columns are revised in subsequent steps.}INNER JOIN {Ans: Selects only matching left and right table rows.}Column {Ans: A ______ has a name and a data type.}Normal forms {Ans: ________ ______ are rules for designing tables with less redundancy.}RESTRICT {Ans: ________ rejects an insert, update, or delete that violates referential integrity.}UNION (Keyword) {Ans: The ______ keyword combines the two results into one table.}NULL {Ans: A special value that represents either unknown or inapplicable data.}Index Scan {Ans: An ________ _________ is a database operation that reads index blocks sequentially, in order to locate the needed table blocks.}Table Scan {Ans: A _______ _________ is a database operation that reads table blocks directly,