Wgu C170 - Data Management - Applications |202 Questions| With Correct Answers.

Automatic query optimization {Ans: A method by which a DBMS finds the most efficient access path for the execution of a query.}Fourth Normal Form (4NF) {Ans: A table is in this form if it contains no multiple independent sets of multivalued dependencies. No row may contain two or more multivalued facts about an entity.}Boolean algebra {Ans: A branch of mathematics that uses the logical operators OR, AND, and NOT.}IN operator {Ans: In SQL, a comparison (equality) operator used to check whether a value is among a list of specified values. Can be used in place of INTERSECT if the DBMS does not support it.}Index access (unique) {Ans: Used when a table has a unique index in a column}NOT operator {Ans: A SQL logical operator that negates a given predicate.}