WGU D426 V2 ACTUAL MIDTERM QUESTIONS AND
CORRECT DETAILED ANSWERS\ACTUAL EXAM
COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS (100% CORRECT VERIFIED SOLUTIONS) A
NEW UPDATED VERSION |ALREADY GRADED A+ 2026-
2027
% of table rows selected by a query
Hit Ration
3 multiple choice options
Reads blocks directly, without accessing an index.
Table Scan
3 multiple choice options
Reads index blocks sequentially in order to locate the needed table
blocks.
Index Scan
2 multiple choice options
,Database repeatedly splits the index in two until it finds a match.
Binary Search
3 multiple choice options
Database object that maps one or more tables to a single file.
Tablespace
3 multiple choice options
Specifies tables, columns, and keys. Implements database
requirements in a specific database system. Also called a schema.
Logical Design
3 multiple choice options
Specifies indexes, table structures, and partitions. Specifies how tables
are organized on storage media.
Physical Design
3 multiple choice options
,Components of a computer system and the relationships between
components.
Architecture
3 multiple choice options
Interact directly with database users and administrators and send
queries to the query processor. Includes Connectors & APIs,
Workbench, and utility programs.
Tools
3 multiple choice options
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
3 multiple choice options
Link between tools and query processor
Connection
3 multiple choice options
, Creates connections and manages communication between tools
and query parser.
Connection Manager
3 multiple choice options
Translates the query processor instructions into low-level file
system commands that modify or retrieve data.
Storage Engine
3 multiple choice options
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
2 multiple choice options
Stores reusable information in main memory.
Cache Manager
3 multiple choice options
CORRECT DETAILED ANSWERS\ACTUAL EXAM
COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS (100% CORRECT VERIFIED SOLUTIONS) A
NEW UPDATED VERSION |ALREADY GRADED A+ 2026-
2027
% of table rows selected by a query
Hit Ration
3 multiple choice options
Reads blocks directly, without accessing an index.
Table Scan
3 multiple choice options
Reads index blocks sequentially in order to locate the needed table
blocks.
Index Scan
2 multiple choice options
,Database repeatedly splits the index in two until it finds a match.
Binary Search
3 multiple choice options
Database object that maps one or more tables to a single file.
Tablespace
3 multiple choice options
Specifies tables, columns, and keys. Implements database
requirements in a specific database system. Also called a schema.
Logical Design
3 multiple choice options
Specifies indexes, table structures, and partitions. Specifies how tables
are organized on storage media.
Physical Design
3 multiple choice options
,Components of a computer system and the relationships between
components.
Architecture
3 multiple choice options
Interact directly with database users and administrators and send
queries to the query processor. Includes Connectors & APIs,
Workbench, and utility programs.
Tools
3 multiple choice options
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
3 multiple choice options
Link between tools and query processor
Connection
3 multiple choice options
, Creates connections and manages communication between tools
and query parser.
Connection Manager
3 multiple choice options
Translates the query processor instructions into low-level file
system commands that modify or retrieve data.
Storage Engine
3 multiple choice options
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
2 multiple choice options
Stores reusable information in main memory.
Cache Manager
3 multiple choice options
