WGU D426 ACTUAL EXAM WELL EQUIPED ANSWERS
2024-2025 NEW VERSION
1. The relationship (within the relation) that describes Functional Depen-
how the value of one attribute may be used to find the dency
value of another attribute.
2. An attribute that can be used to find the value of Determinant
another attribute in the relation.
3. Value can be used to find the value of every other Candidate Key
non-key attribute in the table. Unique and minimal.
4. Define & manage database structures DDL
5. Adding, deleting, and modifying data - Manipulates DML
data stored in a database.
6. Used to create user accounts, manage permissions DCL
and access.
7. Includes CREATE, DROP, ALTER, TRUNCATE, RE- DDL
NAME
8. A view created and stored on the database. Under- Materialized View
lying data is changed and also updated in this view.
Uses memory space.
9. Not stored in memory. Only computed when used or Virtual View
accessed.
10. The data about the data. Describes elements such as Metadata
columns, names, and data type.
11. Ordered collection of elements in parentheses. Tuple
12. % of table rows selected by a query Hit Ration
13. Reads blocks directly, without accessing an index. Table Scan
14. Reads index blocks sequentially in order to locate the Index Scan
needed table blocks.
, 15. Database repeatedly splits the index in two until it Binary Search
finds a match.
16. Database object that maps one or more tables to a Tablespace
single file.
17. Specifies tables, columns, and keys. Implements Logical Design
database requirements in a specific database sys-
tem. Also called a schema.
18. Specifies indexes, table structures, and partitions. Physical Design
Specifies how tables are organized on storage media.
19. Components of a computer system and the relation- Architecture
ships between components.
20. Interact directly with database users and adminis- Tools
trators and send queries to the query processor. In-
cludes Connectors & APIs, Workbench, and utility
programs.
21. Interprets queries. Compiles queries into low-level Query Processor
instructions for the storage engine. Creates a plan
to modify the database or retrieve data, and returns
query results to the application.
22. Link between tools and query processor Connection
23. Creates connections and manages communication Connection Man-
between tools and query parser. ager
24. Translates the query processor instructions into Storage Engine
low-level file system commands that modify or re-
trieve data.
25. Accesses data on storage media. Data stored on stor- File System
age media and organized in files. Contains 3 types of
data: - User data (tables & indexes) - Log files (record
of any changes) - Data dictionary (aka: catalog direc-
2024-2025 NEW VERSION
1. The relationship (within the relation) that describes Functional Depen-
how the value of one attribute may be used to find the dency
value of another attribute.
2. An attribute that can be used to find the value of Determinant
another attribute in the relation.
3. Value can be used to find the value of every other Candidate Key
non-key attribute in the table. Unique and minimal.
4. Define & manage database structures DDL
5. Adding, deleting, and modifying data - Manipulates DML
data stored in a database.
6. Used to create user accounts, manage permissions DCL
and access.
7. Includes CREATE, DROP, ALTER, TRUNCATE, RE- DDL
NAME
8. A view created and stored on the database. Under- Materialized View
lying data is changed and also updated in this view.
Uses memory space.
9. Not stored in memory. Only computed when used or Virtual View
accessed.
10. The data about the data. Describes elements such as Metadata
columns, names, and data type.
11. Ordered collection of elements in parentheses. Tuple
12. % of table rows selected by a query Hit Ration
13. Reads blocks directly, without accessing an index. Table Scan
14. Reads index blocks sequentially in order to locate the Index Scan
needed table blocks.
, 15. Database repeatedly splits the index in two until it Binary Search
finds a match.
16. Database object that maps one or more tables to a Tablespace
single file.
17. Specifies tables, columns, and keys. Implements Logical Design
database requirements in a specific database sys-
tem. Also called a schema.
18. Specifies indexes, table structures, and partitions. Physical Design
Specifies how tables are organized on storage media.
19. Components of a computer system and the relation- Architecture
ships between components.
20. Interact directly with database users and adminis- Tools
trators and send queries to the query processor. In-
cludes Connectors & APIs, Workbench, and utility
programs.
21. Interprets queries. Compiles queries into low-level Query Processor
instructions for the storage engine. Creates a plan
to modify the database or retrieve data, and returns
query results to the application.
22. Link between tools and query processor Connection
23. Creates connections and manages communication Connection Man-
between tools and query parser. ager
24. Translates the query processor instructions into Storage Engine
low-level file system commands that modify or re-
trieve data.
25. Accesses data on storage media. Data stored on stor- File System
age media and organized in files. Contains 3 types of
data: - User data (tables & indexes) - Log files (record
of any changes) - Data dictionary (aka: catalog direc-
