WGU D426 V2

The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Functional Dependency 3 multiple choice options An attribute that can be used to find the value of another attribute in the relation. Determinant 3 multiple choice options Value can be used to find the value of every other non-key attribute in the table. Unique and minimal. Candidate Key 3 multiple choice options Define & manage database structures DDL 2 multiple choice options Adding, deleting, and modifying data - Manipulates data stored in a database. DML 2 multiple choice options Used to create user accounts, manage permissions and access. DCL 2 multiple choice options Includes CREATE, DROP, ALTER, TRUNCATE, RENAME DDL 2 multiple choice options A view created and stored on the database. Underlying data is changed and also updated in this view. Uses memory space. Materialized View 2 multiple choice options Not stored in memory. Only computed when used or accessed. Virtual View 2 multiple choice options The data about the data. Describes elements such as columns, names, and data type. Metadata 3 multiple choice options Ordered collection of elements in parentheses. Tuple 3 multiple choice options % of table rows selected by a query Hit Ration 3 multiple choice options Reads blocks directly, without accessing an index. Table Scan 3 multiple choice options Reads index blocks sequentially in order to locate the needed table blocks. Index Scan 2 multiple choice options Database repeatedly splits the index in two until it finds a match. Binary Search 3 multiple choice options