WGU D426 V2 Actual Exam Questions and Answers 100%
Solved
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
, WGU D426 V2 Actual Exam Questions and Answers 100%
Solved
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.
, WGU D426 V2 Actual Exam Questions and Answers 100%
Solved
Answer - Binary Search
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
Solved
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
, WGU D426 V2 Actual Exam Questions and Answers 100%
Solved
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.
, WGU D426 V2 Actual Exam Questions and Answers 100%
Solved
Answer - Binary Search
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
