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