WGU D426 V2 Exam Test Questions with Answers 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.: Functional Depen-
dency
2. An attribute that can be used to find the value of another attribute in the
relation.: Determinant
3. Value can be used to find the value of every other non-key attribute in the
table. Unique and minimal.: Candidate Key
4. Define & manage database structures: DDL
5. Adding, deleting, and modifying data - Manipulates data stored in a data-
base.: DML
6. Used to create user accounts, manage permissions and access.: DCL
7. Includes CREATE, DROP, ALTER, TRUNCATE, RENAME: DDL
8. A view created and stored on the database. Underlying data is changed and
also updated in this view. Uses memory space.: Materialized View
9. Not stored in memory. Only computed when used or accessed.: Virtual View
10. The data about the data. Describes elements such as columns, names, and
data type.: Metadata
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 needed table
blocks.: Index Scan
15. Database repeatedly splits the index in two until it finds a match.: Binary
Search
16. Database object that maps one or more tables to a single file.: Tablespace
1/
13
, WGU D426 V2 Exam Test Questions with Answers Graded A
17. Specifies tables, columns, and keys. Implements database requirements in
a specific database system. Also called a schema.: Logical Design
18. Specifies indexes, table structures, and partitions. Specifies how tables
are organized on storage media.: Physical Design
19. Components of a computer system and the relationships between compo-
nents.: Architecture
20. Interact directly with database users and administrators and send queries
to the query processor. Includes Connectors & APIs, Workbench, and utility
programs.: 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.: Query Processor
22. Link between tools and query processor: Connection
23. Creates connections and manages communication between tools and
query parser.: Connection Manager
24. Translates the query processor instructions into low-level file system
commands that modify or retrieve data.: Storage Engine
25. Accesses data on storage media. Data stored on storage media and orga-
nized in files. Contains 3 types of data: - User data (tables & indexes) - Log
files (record of any changes) - Data dictionary (aka: catalog directory of tables,
columns, keys, indexes in a relational database). One row for each database
object.: File System
26. Stores reusable information in main memory.: Cache Manager
27. Retains data blocks from the file system for possible reuse.: Buffer Manager
28. Arranged in hierarchy: Multi-tier architecture
2/
13
1. The relationship (within the relation) that describes how the value of one
attribute may be used to find the value of another attribute.: Functional Depen-
dency
2. An attribute that can be used to find the value of another attribute in the
relation.: Determinant
3. Value can be used to find the value of every other non-key attribute in the
table. Unique and minimal.: Candidate Key
4. Define & manage database structures: DDL
5. Adding, deleting, and modifying data - Manipulates data stored in a data-
base.: DML
6. Used to create user accounts, manage permissions and access.: DCL
7. Includes CREATE, DROP, ALTER, TRUNCATE, RENAME: DDL
8. A view created and stored on the database. Underlying data is changed and
also updated in this view. Uses memory space.: Materialized View
9. Not stored in memory. Only computed when used or accessed.: Virtual View
10. The data about the data. Describes elements such as columns, names, and
data type.: Metadata
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 needed table
blocks.: Index Scan
15. Database repeatedly splits the index in two until it finds a match.: Binary
Search
16. Database object that maps one or more tables to a single file.: Tablespace
1/
13
, WGU D426 V2 Exam Test Questions with Answers Graded A
17. Specifies tables, columns, and keys. Implements database requirements in
a specific database system. Also called a schema.: Logical Design
18. Specifies indexes, table structures, and partitions. Specifies how tables
are organized on storage media.: Physical Design
19. Components of a computer system and the relationships between compo-
nents.: Architecture
20. Interact directly with database users and administrators and send queries
to the query processor. Includes Connectors & APIs, Workbench, and utility
programs.: 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.: Query Processor
22. Link between tools and query processor: Connection
23. Creates connections and manages communication between tools and
query parser.: Connection Manager
24. Translates the query processor instructions into low-level file system
commands that modify or retrieve data.: Storage Engine
25. Accesses data on storage media. Data stored on storage media and orga-
nized in files. Contains 3 types of data: - User data (tables & indexes) - Log
files (record of any changes) - Data dictionary (aka: catalog directory of tables,
columns, keys, indexes in a relational database). One row for each database
object.: File System
26. Stores reusable information in main memory.: Cache Manager
27. Retains data blocks from the file system for possible reuse.: Buffer Manager
28. Arranged in hierarchy: Multi-tier architecture
2/
13
