Wgu - D426: Objective Assessment |151 Questions| With Correct Answers.

Constraint {Ans: A __________ is a rule that governs allowable values in a database based on relational and business rules.}WITH CHECK OPTION {Ans: When ______ ______ __________ is specified, the database rejects inserts and updates that do not satisfy the view query WHERE clause.}CREATE TABLE (Statement) {Ans: A statement that creates a new table by specifying the table and column names. Each column is assigned a data type that indicates the format of column values. Data types can be numeric, textual, or complex.}Partition {Ans: A __________ of a supertype entity is a group of mutually exclusive subtype entities.}Aggregate {Ans: Computes functions over multiple table rows, such as sum and count.}Relationship Type {Ans: A _____________ _____ is a set of related things.}CROSS-JOIN {Ans: A __________ combines two tables without comparing columns without an ON clause. This is the only JOIN that does not require a condition.}Last Step {Ans: Creating supertype and subtype entities is the _____ of four analysis steps: 1. Discover entities, relationships, and attributes 2. Determine cardinality 3. Distinguish strong and weak entities 4. Create supertype and subtype entities}Tuple {Ans: An ORDERED collection of elements enclosed in parentheses.}LEFT JOIN