HOSMERIT
WGU D426 V2 ACTUAL QUESTIONS AND
ANSWERS 2024 GRADED A+
1. 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
2. An attribute that can be used to find the value of another attribute in the
relation.
Answer - Determinant
3. Value can be used to find the value of every other non-key attribute in the table.
Unique and minimal.
Answer - Candidate Key
4. Define & manage database structures
Answer - DDL
5. Adding, deleting, and modifying data - Manipulates data stored in a database.
Answer - DML
6. Used to create user accounts, manage permissions and access.
Answer - DCL
7. Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
, Answer - DDL
8. A view created and stored on the database. Underlying data is changed and
also updated in this view. Uses memory space.
Answer - Materialized View
9. Not stored in memory. Only computed when used or accessed.
Answer - Virtual View
10. The data about the data. Describes elements such as columns, names, and
data type.
Answer - Metadata
11. Ordered collection of elements in parentheses.
Answer - Tuple
12. % of table rows selected by a query
Answer - Hit Ration
13. Reads blocks directly, without accessing an index.
Answer - Table Scan
14. Reads index blocks sequentially in order to locate the needed table blocks.
Answer - Index Scan
15. Database repeatedly splits the index in two until it finds a match.
Answer - Binary Search
, 16. Database object that maps one or more tables to a single file.
Answer - Tablespace
17. Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema.
Answer - Logical Design
18. Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Answer - Physical Design
19. Components of a computer system and the relationships between
components.
Answer - Architecture
20. Interact directly with database users and administrators and send queries to
the query processor. Includes Connectors & APIs, Workbench, and utility
programs.
Answer - Tools
21. 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
22. Link between tools and query processor
Answer - Connection
23. Creates connections and manages communication between tools and query
parser.
WGU D426 V2 ACTUAL QUESTIONS AND
ANSWERS 2024 GRADED A+
1. 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
2. An attribute that can be used to find the value of another attribute in the
relation.
Answer - Determinant
3. Value can be used to find the value of every other non-key attribute in the table.
Unique and minimal.
Answer - Candidate Key
4. Define & manage database structures
Answer - DDL
5. Adding, deleting, and modifying data - Manipulates data stored in a database.
Answer - DML
6. Used to create user accounts, manage permissions and access.
Answer - DCL
7. Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
, Answer - DDL
8. A view created and stored on the database. Underlying data is changed and
also updated in this view. Uses memory space.
Answer - Materialized View
9. Not stored in memory. Only computed when used or accessed.
Answer - Virtual View
10. The data about the data. Describes elements such as columns, names, and
data type.
Answer - Metadata
11. Ordered collection of elements in parentheses.
Answer - Tuple
12. % of table rows selected by a query
Answer - Hit Ration
13. Reads blocks directly, without accessing an index.
Answer - Table Scan
14. Reads index blocks sequentially in order to locate the needed table blocks.
Answer - Index Scan
15. Database repeatedly splits the index in two until it finds a match.
Answer - Binary Search
, 16. Database object that maps one or more tables to a single file.
Answer - Tablespace
17. Specifies tables, columns, and keys. Implements database requirements in a
specific database system. Also called a schema.
Answer - Logical Design
18. Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Answer - Physical Design
19. Components of a computer system and the relationships between
components.
Answer - Architecture
20. Interact directly with database users and administrators and send queries to
the query processor. Includes Connectors & APIs, Workbench, and utility
programs.
Answer - Tools
21. 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
22. Link between tools and query processor
Answer - Connection
23. Creates connections and manages communication between tools and query
parser.
