Data Management - Foundations - D426 Wgu 183 Correctly Answered Questions Latest Update

Subtype Entity/Supertype Entity {Ans: A subset of another entity type.}Table Constraint {Ans: Appears in a SEPARATE clause of a CREATE TABLE statement.}FULL JOIN {Ans: Selects ALL left and right table rows, regardless of match.}ORDER BY {Ans: This clause orders selected rows by one or more columns in ascending (alphabetical) order.}NoSQL {Ans: A new generation of DBMS that is NOT based on the traditional relational database model.}Query Processor {Ans: Interprets queries, creates a plan to modify the database or retrieve the data, and returns query results to the application. Performs query optimization.}DROP TABLE {Ans: This statement deletes a table, along with all the table's rows, from a database.}Column {Ans: Has a name and a data type.}Weak Entity {Ans: This entity doesn't have an identifying attribute. Usually has a relationship called an identifying relationship, to another entity, called an identifying entity.}Architecture {Ans: Describes the internal components AND the relationships between components.}INNER JOIN {Ans: Selects ONLY matching left and right table rows.}Database Designer {Ans: What role am I? Determines the format of each data element AND the overall database STRUCTURE. Must balance priorities like including storage, response time, and support for