Wgu C170 - Data Management - Applications Study Guide Rated A+

JOIN ON {Ans: A way to express a join when the tables have no common attribute. The query will return only the rows that meet the indicated join condition. The join condition will typically include an equality comparison expression of two columns.}CEIL/CEILING/FLOOR {Ans: Returns the smallest integer greater than or equal to a number or returns the largest integer equal to or less than a number, respectively}Updatable view {Ans: A view that can update attributes in base tables that are used in the view.}Binary relationship {Ans: An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS.}DIFFERENCE {Ans: An operator used to yield all rows from one table that are not found in another union-compatible table. supplier - vendor}Input/output (I/O) request {Ans: A low-level data access operation that reads or writes data to and from computer devices.}