WGU D426 V LATEST UPDATE

WGU D426 V LATEST UPDATE 1. The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute.: Functional Dependency 2. An attribute that can be used to find the value of another attribute in the relation.: Determinant 3. Value can be used to find the value of every other non-key attribute in the table. Unique and minimal.: Candidate Key 4. Define & manage database structures: DDL 5. Adding, deleting, and modifying data - Manipulates data stored in a database.: DML 6. Used to create user accounts, manage permissions and access.: DCL 7. Includes CREATE, DROP, ALTER,TRUNCATE, RENAME: DDL 8. A view created and stored on the database. Underlying data is changed and also updated in this view. Uses memory space.: Materialized View 9. Not stored in memory. Only computed when used or accessed.: Virtual View 10. The data about the data. Describes elements such as columns, names, and data type.: 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 15. Database repeatedly splits the index in two until it finds a match.: Binary Search 16. Database object that maps one or more tables to a single file.: Tablespace 17. Specifies tables, columns, and keys. Implements database requirements in WGU D426 V LATEST UPDATE a specific database system. Also called a schema.: Logical Design 18. Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media.: Physical Design 19. Components of a computer system and the relationships between components.: Architecture 20. Interact directly with database users and administrators and send queries to the query processor. Includes Connectors & APIs, Workbench, and utility programs.: Tools 21. 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.: Query Processor 22. Link between tools and query processor: Connection