WGU D426 V2 QUESTIONS AND ANSWERS WITH CERTIFIED SOLUTIONS

WGU D426 V2 QUESTIONS AND ANSWERS WITH CERTIFIED SOLUTIONS 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 Database object that maps one or more tables to a single file. Tablespace 3 MULTIPLE CHOICE OPTIONS Specifies tables, columns, and keys. Implements database requirements in a specific database system. Also called a schema. Logical Design 3 MULTIPLE CHOICE OPTIONS Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media. Physical Design 3 MULTIPLE CHOICE OPTIONS Components of a computer system and the relationships between components. Architecture 3 MULTIPLE CHOICE OPTIONS Interact directly with database users and administrators and send queries to the query processor. Includes Connectors & APIs, Workbench, and utility programs