WGU D426 V2 Exam Ques ons and answers new!!
2025/2026 RATED A+
The rela onship (within the rela on) that describes how the value of one a ribute may be used
to find the value of another a ribute.
Func onal Dependency
3 mul ple choice op ons
An a ribute that can be used to find the value of another a ribute in the rela on.
Determinant
3 mul ple choice op ons
Value can be used to find the value of every other non-key a ribute in the table. Unique and
minimal.
Candidate Key
3 mul ple choice op ons
Define & manage database structures
DDL
2 mul ple choice op ons
Adding, dele ng, and modifying data - Manipulates data stored in a database.
DML
2 mul ple choice op ons
Used to create user accounts, manage permissions and access.
DCL
2 mul ple choice op ons
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
2 mul ple choice op ons
,A view created and stored on the database. Underlying data is changed and also updated in this
view. Uses memory space.
Materialized View
2 mul ple choice op ons
Not stored in memory. Only computed when used or accessed.
Virtual View
2 mul ple choice op ons
The data about the data. Describes elements such as columns, names, and data type.
Metadata
3 mul ple choice op ons
Ordered collec on of elements in parentheses.
Tuple
3 mul ple choice op ons
% of table rows selected by a query
Hit Ra on
3 mul ple choice op ons
AD
Reads blocks directly, without accessing an index.
Table Scan
3 mul ple choice op ons
Reads index blocks sequen ally in order to locate the needed table blocks.
Index Scan
2 mul ple choice op ons
Database repeatedly splits the index in two un l it finds a match.
Binary Search
3 mul ple choice op ons
, Database object that maps one or more tables to a single file.
Tablespace
3 mul ple choice op ons
Specifies tables, columns, and keys. Implements database requirements in a specific database
system. Also called a schema.
Logical Design
3 mul ple choice op ons
Specifies indexes, table structures, and par ons. Specifies how tables are organized on storage
media.
Physical Design
3 mul ple choice op ons
Components of a computer system and the rela onships between components.
Architecture
3 mul ple choice op ons
Interact directly with database users and administrators and send queries to the query
processor. Includes Connectors & APIs, Workbench, and u lity programs.
Tools
3 mul ple choice op ons
Interprets queries. Compiles queries into low-level instruc ons for the storage engine. Creates a
plan to modify the database or retrieve data, and returns query results to the applica on.
Query Processor
3 mul ple choice op ons
Link between tools and query processor
Connec on
3 mul ple choice op ons
AD
Creates connec ons and manages communica on between tools and query parser.
2025/2026 RATED A+
The rela onship (within the rela on) that describes how the value of one a ribute may be used
to find the value of another a ribute.
Func onal Dependency
3 mul ple choice op ons
An a ribute that can be used to find the value of another a ribute in the rela on.
Determinant
3 mul ple choice op ons
Value can be used to find the value of every other non-key a ribute in the table. Unique and
minimal.
Candidate Key
3 mul ple choice op ons
Define & manage database structures
DDL
2 mul ple choice op ons
Adding, dele ng, and modifying data - Manipulates data stored in a database.
DML
2 mul ple choice op ons
Used to create user accounts, manage permissions and access.
DCL
2 mul ple choice op ons
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
2 mul ple choice op ons
,A view created and stored on the database. Underlying data is changed and also updated in this
view. Uses memory space.
Materialized View
2 mul ple choice op ons
Not stored in memory. Only computed when used or accessed.
Virtual View
2 mul ple choice op ons
The data about the data. Describes elements such as columns, names, and data type.
Metadata
3 mul ple choice op ons
Ordered collec on of elements in parentheses.
Tuple
3 mul ple choice op ons
% of table rows selected by a query
Hit Ra on
3 mul ple choice op ons
AD
Reads blocks directly, without accessing an index.
Table Scan
3 mul ple choice op ons
Reads index blocks sequen ally in order to locate the needed table blocks.
Index Scan
2 mul ple choice op ons
Database repeatedly splits the index in two un l it finds a match.
Binary Search
3 mul ple choice op ons
, Database object that maps one or more tables to a single file.
Tablespace
3 mul ple choice op ons
Specifies tables, columns, and keys. Implements database requirements in a specific database
system. Also called a schema.
Logical Design
3 mul ple choice op ons
Specifies indexes, table structures, and par ons. Specifies how tables are organized on storage
media.
Physical Design
3 mul ple choice op ons
Components of a computer system and the rela onships between components.
Architecture
3 mul ple choice op ons
Interact directly with database users and administrators and send queries to the query
processor. Includes Connectors & APIs, Workbench, and u lity programs.
Tools
3 mul ple choice op ons
Interprets queries. Compiles queries into low-level instruc ons for the storage engine. Creates a
plan to modify the database or retrieve data, and returns query results to the applica on.
Query Processor
3 mul ple choice op ons
Link between tools and query processor
Connec on
3 mul ple choice op ons
AD
Creates connec ons and manages communica on between tools and query parser.
