WGU D426 V2 EXAM QUESTIONS AND
CORRECT ANSWERS FOR 2025
, The relationship (within the relation) that describes how the value of one attribute may
be used to find the value of another attribute. - ANSWERFunctional Dependency
An attribute that can be used to find the value of another attribute in the relation. -
ANSWERDeterminant
Value can be used to find the value of every other non-key attribute in the table. Unique
and minimal. - ANSWERCandidate Key
Define & manage database structures - ANSWERDDL
Adding, deleting, and modifying data - Manipulates data stored in a database. -
ANSWERDML
Used to create user accounts, manage permissions and access. - ANSWERDCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - ANSWERDDL
A view created and stored on the database. Underlying data is changed and also
updated in this view. Uses memory space. - ANSWERMaterialized View
Not stored in memory. Only computed when used or accessed. - ANSWERVirtual View
The data about the data. Describes elements such as columns, names, and data type. -
ANSWERMetadata
Ordered collection of elements in parentheses. - ANSWERTuple
% of table rows selected by a query - ANSWERHit Ration
Reads blocks directly, without accessing an index. - ANSWERTable Scan
Reads index blocks sequentially in order to locate the needed table blocks. -
ANSWERIndex Scan
Database repeatedly splits the index in two until it finds a match. - ANSWERBinary
Search
Database object that maps one or more tables to a single file. - ANSWERTablespace
CORRECT ANSWERS FOR 2025
, The relationship (within the relation) that describes how the value of one attribute may
be used to find the value of another attribute. - ANSWERFunctional Dependency
An attribute that can be used to find the value of another attribute in the relation. -
ANSWERDeterminant
Value can be used to find the value of every other non-key attribute in the table. Unique
and minimal. - ANSWERCandidate Key
Define & manage database structures - ANSWERDDL
Adding, deleting, and modifying data - Manipulates data stored in a database. -
ANSWERDML
Used to create user accounts, manage permissions and access. - ANSWERDCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - ANSWERDDL
A view created and stored on the database. Underlying data is changed and also
updated in this view. Uses memory space. - ANSWERMaterialized View
Not stored in memory. Only computed when used or accessed. - ANSWERVirtual View
The data about the data. Describes elements such as columns, names, and data type. -
ANSWERMetadata
Ordered collection of elements in parentheses. - ANSWERTuple
% of table rows selected by a query - ANSWERHit Ration
Reads blocks directly, without accessing an index. - ANSWERTable Scan
Reads index blocks sequentially in order to locate the needed table blocks. -
ANSWERIndex Scan
Database repeatedly splits the index in two until it finds a match. - ANSWERBinary
Search
Database object that maps one or more tables to a single file. - ANSWERTablespace
