Wgu Data Management - Foundations - D426 Already Passed

48. Which term describes the process of denormalization? Merging tables Candidate key Trivial dependency Third normal form {Ans: Merging tables}24. Which phrase refers to the view in which data is persisted and is automatically changed as the underlying data is changed? Virtual View Snapshot View Denormalized View Materialized View {Ans: Materialized View}27. Which term identifies an ordered collection of elements enclosed in parenthesis in a tablespace? Cell Field Column Tuple {Ans: Tuple}20. Which function is considered an aggregating function in SQL? TRIM REPLACE MIN SUBSTRING {Ans: MIN}60. How should an entity relationship phrase be read to correctly understand how one entity relates to another entity in an entity-relationship diagram (ER diagram)? From top to bottom In the direction the entity box is facing In the direction the relationship verb is facing From left to right {Ans: In the direction the relationship verb is facing}25. Which SQL command uses the correct syntax to update the salary of an employee in the Employee table? CHANGE Employee Salary = 50000 WHERE ID = 1; UPDATE Employee SET Salary = 50000 WHERE ID = 1; ALTER Employee SET Salary = 50000 WHERE ID = 1; UPDATE Employee (Salary) =