D426 (COMPUTERS SCIENCE) V2 QUESTIONS AND ANSWERS WESTERN GOVERNORS’ UNIVERSITY

D426 (COMPUTERS SCIENCE) V2 QUESTIONS AND ANSWERS WESTERN GOVERNORS’ UNIVERSITY
1. The relationship (within the relation) that describes
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
another attribute in the relation.
3. Value can be used to find the value of every other
non-key attribute in the table. Unique and minimal.
Functional Dependency
Determinant
Candidate Key
4. Define & manage database structures DDL
5. Adding, deleting, and modifying data - Manipulates
data stored in a database.
6. Used to create user accounts, manage permissions
and access.
7. Includes CREATE, DROP, ALTER,TRUNCATE, RENAME
8. A view created and stored on the database. Underlying data is changed and also updated in this view.
Uses memory space.
9. Not stored in memory. Only computed when used or
accessed.
10. The data about the data. Describes elements such as
columns, names, and data type.
DML
DCL
DDL
Materialized View
Virtual View
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