Wgu - D426: Objective Assessment Study Guide Questions And Correct Answers

The ______ keyword combines the two results into one table. {Ans: UNION (Keyword)}8 bytes {Ans: BIGINT}Sometimes called a nested query or inner query, is a query within another SQL query. {Ans: Subquery}Ensures transactions are properly executed. The transaction manager prevents conflicts between concurrent transactions. The transaction manager also restores the database to a consistent state in the event of a transaction or system failure. {Ans: Transaction Manager}An ______ _______ is a set of things. Ex: All employees in a company. {Ans: Entity Type}A _______ _______ contains an entry for every table row. {Ans: Dense index}COUNT() counts the number of rows in the set. MIN() finds the minimum value in the set. MAX() finds the maximum value in the set. SUM() sums all the values in the set. AVG() computes the arithmetic mean of all the values in the set. {Ans: Aggregate (Function)}Compares two values for equality. {Ans: =}A ________ _______ contains an entry for every table block. {Ans: Sparse index}Refers to maxima and minima of relationships and attributes. {Ans: Cardinality}The ___________ function is a simple hash function with four steps: 1. Convert the hash key by interpreting the key's bits