- | P a g e
pg. 1
WGU D426 V2 EXAM NEWEST 2025 ACTUAL EXAM|
COMPLETE ACCURATE QUESTIONS | REAL EXAM
QUESTIONS AND CORRECT VERIFIED ANSWERS/
ALREADY GRADED A+
Database object that maps one or more tables to a single file.✓ Tablespace
Specifies tables, columns, and keys. Implements database requirements in a specific database system. Also called a schema.✓ Logical Design
Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media.✓ Physical Design
Components of a computer system and the relationships between components.✓ Architecture
Interact directly with database users and administrators and send queries to the query processor. Includes Connectors & APIs, Workbench, and utility programs.✓ Tools 1 / 4
- | P a g e
pg. 2 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
Creates connections and manages communication between tools and query parser.✓ Connection Manager
Translates the query processor instructions into low-level file system commands that modify or retrieve data.✓ Storage Engine
Accesses data on storage media. Data stored on storage media and
organized in files. Contains 3 types of data: - User data (tables &
indexes) - Log files (record of any changes) - Data dictionary (aka:
catalog directory of tables, columns, keys, indexes in a relational database). One row for each database object.✓ File System
A database that is packaged with a programming language. AKA: In-
Process Database (Database Architecture) - SQLite - SQL Server Compact ✓ Embedded Databases
- / 4
- | P a g e
pg. 3 Collection of two or more participating databases under a coordinating software layer called middleware.✓ Federated Database
Relationships are named and classified by their cardinalities, which means count (as in the number of items in a set). HAS-A relationship.Each of the three types of binary relationships has a different cardinality.Is the maximum number of entity instances that can participate in a relationship instance.✓ Maximum Cardinality
Minimum number of entity instances that must participate in a relationship instance. These values typically assume a value of zero (optional) or one (mandatory).✓ Minimum Cardinality
An entity whose instances cannot exist in the database without the existence of an instance of another entity.✓ Weak Entity
Can exist in the database independently.✓ Strong Entity
Stores reusable information in main memory.✓ Cache Manager 3 / 4
- | P a g e
pg. 4 Retains data blocks from the file system for possible reuse.✓ Buffer Manager
A conceptual framework for database systems with three parts: Data
Structures (prescribe how data is organized), Operations (manipulates data structures), Rules (govern valid data).✓ Database Model
An unordered collection of elements enclosed in braces.✓ Set
Retrieves data from the database.
✓ DQL
A string of operators, operands, and parentheses that evaluates to a single value.✓ Expression
A column, or group of columns, used to identify a row.✓ Primary Key
Rejects an insert, update, or delete that violates referential integrity.
✓ RESTRICT
- / 4