WGU D426 V2 QUESTIONS WITH
ANSWERS GRADED A+ 2025/2026
The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. - ANSWER Functional Dependency An attribute that can be used to find the value of another attribute in the relation. - ANSWER Determinant Value can be used to find the value of every other non-key attribute in the table.Unique and minimal. - ANSWER Candidate Key Define & manage database structures - ANSWER DDL Adding, deleting, and modifying data - Manipulates data stored in a database. -
ANSWER DML
Used to create user accounts, manage permissions and access. - ANSWER DCL Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - ANSWER
DDL 1 / 3
A view created and stored on the database. Underlying data is changed and also updated in this view. Uses memory space. - ANSWER Materialized View Not stored in memory. Only computed when used or accessed. - ANSWER Virtual View The data about the data. Describes elements such as columns, names, and data type. - ANSWER Metadata Ordered collection of elements in parentheses. - ANSWER Tuple % of table rows selected by a query - ANSWER Hit Ration Reads blocks directly, without accessing an index. - ANSWER Table Scan Reads index blocks sequentially in order to locate the needed table blocks. - ANSWER Index Scan Database repeatedly splits the index in two until it finds a match. - ANSWER Binary Search 2 / 3
Database object that maps one or more tables to a single file. - ANSWER Tablespace Specifies tables, columns, and keys. Implements database requirements in a specific database system. Also called a schema. - ANSWER Logical Design Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media. - ANSWER Physical Design Components of a computer system and the relationships between components. - ANSWER Architecture Interact directly with database users and administrators and send queries to the query processor. Includes Connectors & APIs, Workbench, and utility programs. - ANSWER Tools Interprets queries. Compiles queries into low-level instructions for the storage engine. Creates a plan to modify the database or retrieve data, and returns query results to the application. - ANSWER Query Processor Link between tools and query processor - ANSWER Connection Creates connections and manages communication between tools and query parser.
- ANSWER Connection Manager
- / 3