COMPLETE WGU D426 V2 ACTUAL EXAM Complete
Questions with Certified Answers.
,
The data about the data. Describes elements such as columns, names, and data type.
Metadata
An attribute that can be used to find the value of another attribute in the relation.
Determinant
,
Value can be used to find the value of every other non-key attribute in the table. Unique and minimal.
Candidate Key
,
Define & manage database structures
DDL
,
Adding, deleting, and modifying data - Manipulates data stored in a database.
DML
,
Used to create user accounts, manage permissions and access.
DCL
,,
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
A view created and stored on the database. Underlying data is changed and also updated in this view.
Uses memory space.
Materialized View
,
Not stored in memory. Only computed when used or accessed.
Virtual View
,
,
Ordered collection of elements in parentheses.
Tuple
,
% of table rows selected by a query
Hit Ration
,
, Reads blocks directly, without accessing an index.
Table Scan
,
Reads index blocks sequentially in order to locate the needed table blocks.
Index Scan
,
Database repeatedly splits the index in two until it finds a match.
Binary Search
,
Database object that maps one or more tables to a single file.
Tablespace
,
Specifies tables, columns, and keys. Implements database requirements in a specific database system.
Also called a schema.
Logical Design
,
Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media.
Physical Design
Questions with Certified Answers.
,
The data about the data. Describes elements such as columns, names, and data type.
Metadata
An attribute that can be used to find the value of another attribute in the relation.
Determinant
,
Value can be used to find the value of every other non-key attribute in the table. Unique and minimal.
Candidate Key
,
Define & manage database structures
DDL
,
Adding, deleting, and modifying data - Manipulates data stored in a database.
DML
,
Used to create user accounts, manage permissions and access.
DCL
,,
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
A view created and stored on the database. Underlying data is changed and also updated in this view.
Uses memory space.
Materialized View
,
Not stored in memory. Only computed when used or accessed.
Virtual View
,
,
Ordered collection of elements in parentheses.
Tuple
,
% of table rows selected by a query
Hit Ration
,
, Reads blocks directly, without accessing an index.
Table Scan
,
Reads index blocks sequentially in order to locate the needed table blocks.
Index Scan
,
Database repeatedly splits the index in two until it finds a match.
Binary Search
,
Database object that maps one or more tables to a single file.
Tablespace
,
Specifies tables, columns, and keys. Implements database requirements in a specific database system.
Also called a schema.
Logical Design
,
Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media.
Physical Design
