WGU D426 ACTUAL EXAM WELL EQUIPED ANSWERS NEW VERSION
3 views 0 purchase
Course
WGU D426 ACTUAL
Institution
WGU D426 ACTUAL
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 fin...
WGU D426 ACTUAL EXAM WELL EQUIPED ANSWERS
2024-2025 NEW VERSION
1. The relationship (within the relation) that describes Functional Depen-
how the value of one attribute may be used to find the dency
value of another attribute.
2. An attribute that can be used to find the value of Determinant
another attribute in the relation.
3. Value can be used to find the value of every other Candidate Key
non-key attribute in the table. Unique and minimal.
4. Define & manage database structures DDL
5. Adding, deleting, and modifying data - Manipulates DML
data stored in a database.
6. Used to create user accounts, manage permissions DCL
and access.
7. Includes CREATE, DROP, ALTER, TRUNCATE, RE- DDL
NAME
8. A view created and stored on the database. Under- Materialized View
lying data is changed and also updated in this view.
Uses memory space.
9. Not stored in memory. Only computed when used or Virtual View
accessed.
10. The data about the data. Describes elements such as Metadata
columns, names, and data type.
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 Index Scan
needed table blocks.
, 15. Database repeatedly splits the index in two until it Binary Search
finds a match.
16. Database object that maps one or more tables to a Tablespace
single file.
17. Specifies tables, columns, and keys. Implements Logical Design
database requirements in a specific database sys-
tem. Also called a schema.
18. Specifies indexes, table structures, and partitions. Physical Design
Specifies how tables are organized on storage media.
19. Components of a computer system and the relation- Architecture
ships between components.
20. Interact directly with database users and adminis- Tools
trators and send queries to the query processor. In-
cludes Connectors & APIs, Workbench, and utility
programs.
21. Interprets queries. Compiles queries into low-level Query Processor
instructions for the storage engine. Creates a plan
to modify the database or retrieve data, and returns
query results to the application.
22. Link between tools and query processor Connection
23. Creates connections and manages communication Connection Man-
between tools and query parser. ager
24. Translates the query processor instructions into Storage Engine
low-level file system commands that modify or re-
trieve data.
25. Accesses data on storage media. Data stored on stor- File System
age media and organized in files. Contains 3 types of
data: - User data (tables & indexes) - Log files (record
of any changes) - Data dictionary (aka: catalog direc-
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ANTONYCARLOS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.99. You're not tied to anything after your purchase.
