WGU D426 V2
1. The relationship (within the relation) that describes Functional Dependency
how the value of one attribute may be used to find the
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, RENAME DDL
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
, WGU D426 V2
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 data- Logical Design
base requirements in a specific database system. 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 administra- Tools
tors and send queries to the query processor. Includes
Connectors & APIs, Workbench, and utility programs.
21. Interprets queries. Compiles queries into low-level in- Query Processor
structions 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 Manager
between tools and query parser.
, WGU D426 V2
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-
tory of tables, columns, keys, indexes in a relational
database). One row for each database object.
26. Stores reusable information in main memory. Cache Manager
27. Retains data blocks from the file system for possible Buffer Manager
reuse.
28. Arranged in hierarchy Multi-tier architecture
29. Multi-tier consisting of web browsers and web servers Web architecture
communicating over the internet.
30. A software layer that emulates a complete, indepen- Virtual Machine
dent computing environment.
31. A database offered as a PaaS cloud service. Cloud Database
32. A statement or proposition from which another state- Premise
ment is inferred.
33. Multiple processors managed by a single operating Parallel Computer
system instance.
Shared memory - share the same memory and stor-
age media.
1. The relationship (within the relation) that describes Functional Dependency
how the value of one attribute may be used to find the
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, RENAME DDL
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
, WGU D426 V2
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 data- Logical Design
base requirements in a specific database system. 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 administra- Tools
tors and send queries to the query processor. Includes
Connectors & APIs, Workbench, and utility programs.
21. Interprets queries. Compiles queries into low-level in- Query Processor
structions 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 Manager
between tools and query parser.
, WGU D426 V2
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-
tory of tables, columns, keys, indexes in a relational
database). One row for each database object.
26. Stores reusable information in main memory. Cache Manager
27. Retains data blocks from the file system for possible Buffer Manager
reuse.
28. Arranged in hierarchy Multi-tier architecture
29. Multi-tier consisting of web browsers and web servers Web architecture
communicating over the internet.
30. A software layer that emulates a complete, indepen- Virtual Machine
dent computing environment.
31. A database offered as a PaaS cloud service. Cloud Database
32. A statement or proposition from which another state- Premise
ment is inferred.
33. Multiple processors managed by a single operating Parallel Computer
system instance.
Shared memory - share the same memory and stor-
age media.
