WGU D426 V2 Complete Answers 100% Correct (Latest 2024) STUDY GUIDE

Document Content and Description Below

1. The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. Answer: Functional Dependency 2. An attribute that can be... used to find the value of another attribute in therelation. Answer: Determinant 3. Value can be used to find the value of every other non-key attribute in thetable. Unique and minimal. Answer: Candidate Key 4. Define & manage database structures Answer: DDL 5. Adding, deleting, and modifying data - Manipulates data stored in a data-base. Answer: DML 6. Used to create user accounts, manage permissions and access. Answer: DCL 7. Includes CREATE, DROP, ALTER,TRUNCATE, RENAME Answer: DDL 8. A view created and stored on the database. Underlying data is changed andalso updated in this view. Uses memory space. Answer: Materialized View 9. Not stored in memory. Only computed when used or accessed. Answer: Virtual View 10. The data about the data.Describes elementssuch as columns,names, anddata type. Answer: Metadata 11. Ordered collection of elements in parentheses. Answer: Tuple 12. % of table rows selected by a query Answer: Hit Ration [Show More]

Last updated: 1 week ago

Preview 1 out of 9 pages