WGU D426 V2 QUESTIONS AND
ANSWERS WITH CERTIFIE D
SOLUTIONS
Question : The relationship (within the relation) that describes
how the value of one attribute may be used to find the value of another attribute.
CORRECT ANSWER : Functional Dependency
Question : An attribute that can be used to find the value of
another attribute in the relation.
CORRECT ANSWER : Determinant
Question : Value can be used to find the value of every other
non-key attribute in the table. Unique and minimal.
CORRECT ANSWER : Candidate Key
Question : Define & manage database structures
CORRECT ANSWER : DDL
Question : Adding, deleting, and modifying data -
Manipulates data stored in a database.
CORRECT ANSWER : DML
Question : Used to create user accounts, manage permissions
and access.
CORRECT ANSWER : DCL
Question : Includes CREATE, DROP, ALTER, TRUNCATE,
RENAME
CORRECT ANSWER : DDL
Question : A view created and stored on the database.
Underlying data is changed and also updated in this view.Uses memory space.
CORRECT ANSWER : Materialized View
Question : Not stored in memory. Only computed when used
or accessed.
CORRECT ANSWER : Virtual View
Question : The data about the data. Describes elements such
as columns, names, and data type.
CORRECT ANSWER : Metadata
Question : Ordered collection of elements in parentheses.
CORRECT ANSWER : Tuple
Question : % of table rows selected by a query
CORRECT ANSWER : Hit Ration
Question : Reads blocks directly, without accessing an index.
CORRECT ANSWER : Table Scan
Question : Reads index blocks sequentially in order to locate
the needed table blocks.
CORRECT ANSWER : Index Scan
Question : Database repeatedly splits the index in two until it
finds a match.
CORRECT ANSWER : Binary Search
Question : Database object that maps one or more tables to a
single file.
CORRECT ANSWER : Tablespace
Question : Specifies tables, columns, and keys. Implements
database requirements in a specific database system. Also called a schema.
CORRECT ANSWER : Logical Design
Question : Specifies indexes, table structures, and partitions.
Specifies how tables are organized on storage media.
CORRECT ANSWER : Physical Design
Question : Components of a computer system and the
relationships between components.