WGU D426 (v2) Revised exam Questions
with 100% Correct Answers | Verified | Updated 2024
The relationship that describes how one attribute's value can determine another's - Correct Answer-Functional Dependency
An attribute determining the value of another attribute - Correct Answer-Determinant
Unique and minimal attribute determining non-key attributes - Correct Answer-
Candidate Key
Defines and manages database structures - Correct Answer-DDL
Manipulates data: adding, deleting, modifying - Correct Answer-DML
Manages user accounts and permissions - Correct Answer-DCL
Commands: CREATE, DROP, ALTER, TRUNCATE, RENAME - Correct Answer-DDL
Stored view that updates when underlying data changes - Correct Answer-Materialized View
Computed view not stored in memory - Correct Answer-Virtual View
Information describing data elements - Correct Answer-Metadata
Ordered collection of elements in parentheses - Correct Answer-Tuple
Percentage of table rows a query selects - Correct Answer-Hit Ratio
Directly reads blocks without using an index - Correct Answer-Table Scan
Reads index blocks to locate table blocks - Correct Answer-Index Scan
Database splits the index until a match is found - Correct Answer-Binary Search
Database object mapping tables to a file - Correct Answer-Tablespace
Specifies tables and keys, also called a schema - Correct Answer-Logical Design
Specifies how tables are stored on media - Correct Answer-Physical Design Components and relationships in a computer system - Correct Answer-Architecture
Direct interface with database users, includes APIs - Correct Answer-Tools
Interprets and compiles queries - Correct Answer-Query Processor
Link between tools and query processor - Correct Answer-Connection
Manages communication between tools and query parser - Correct Answer-Connection Manager
Translates query instructions to file system commands - Correct Answer-Storage Engine
Accesses data on storage media, includes logs and user data - Correct Answer-File System
Stores reusable information in memory - Correct Answer-Cache Manager
Retains file system data blocks for reuse - Correct Answer-Buffer Manager
Hierarchical arrangement - Correct Answer-Multi-tier architecture
Multi-tier with web browsers and servers over the internet - Correct Answer-Web architecture
Software emulating a complete computing environment - Correct Answer-Virtual Machine
Database offered as a cloud service - Correct Answer-Cloud Database
Statement from which another is inferred - Correct Answer-Premise
A system with multiple processors that can run multiple tasks simultaneously. They can be configured to have shared memory, shared storage, or neither - Correct Answer-
Parallel Computer
Any device, such as a computer or printer, connected to a network - Correct Answer-
Node
Group of nodes on a LAN with separate OS instances - Correct Answer-Cluster
Database on a parallel computer or cluster - Correct Answer-Parallel Database
Database on multiple computers connected by a WAN - Correct Answer-Distributed Database
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 professoraxel. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.