WGU D426 V2 Exam Questions And Answers

WGU D426 V2 Exam Questions And Answers 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