HOSMERIT
WGU D426 V2 EXAM 2025 QUESTIONS WITH
VERIFIED ANSWERS A+ GRADE
The relationship (within the relation) that describes howthe value of one attribute may be
used to find the value ofanother attribute.: Functional Dependency
An attribute that can be used to find the value of anotherattribute in the relation.:
Determinant
Value can be used to find the value of every other non-keyattribute in the table. Unique and
minimal.: Candidate Key
Define & manage database structures: DDL
Adding, deleting, and modifying data - Manipulates datastored in a data- base.: DML
Used to create user accounts, manage permissions andaccess.: DCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME:
DDL
A view created and stored on the database. Underlying datais changed and also updated
in this view. Uses memory space.: Materialized View
Not stored in memory. Only computed when used oraccessed.: Virtual View
The data about the data. Describes elements such ascolumns, names, and data type.:
Metadata
,Ordered collection of elements in parentheses.: Tuple
% of table rows selected by a query: Hit Ration
Reads blocks directly, without accessing an index.: TableScan
Reads index blocks sequentially in order to locate theneeded table blocks.: Index Scan
Database repeatedly splits the index in two until it finds amatch.: Binary Search
Database object that maps one or more tables to a singlefile.: Tablespace
Specifies tables, columns, and keys. Implements databaserequirements 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 relationshipsbetween compo- nents.: Architecture
Interact directly with database users and administratorsand send queries to the query
processor. Includes Connectors & APIs, Workbench, and utility programs.: Tools
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
Link between tools and query processor: Connection
, Creates connections and manages communicationbetween tools and query parser.:
Connection Manager
Translates the query processor instructions into low-levelfile system commands that modify
or retrieve data.: Storage Engine
Accesses data on storage media. Data stored on storagemedia and orga- nized 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 foreach database object.: File System
Stores reusable information in main memory.: CacheManager
Retains data blocks from the file system for possiblereuse.: Buffer Manager
Arranged in hierarchy: Multi-tier architecture
Multi-tier consisting of web browsers and web serverscommunicating over the internet.:
Web architecture
A software layer that emulates a complete, independentcomputing envi- ronment.: Virtual
Machine
A database offered as a PaaS cloud service.: CloudDatabase
A statement or proposition from which another statementis inferred.: -Premise
Multiple processors managed by a single operating system instance. Shared memory -
share the same memoryand storage media.
WGU D426 V2 EXAM 2025 QUESTIONS WITH
VERIFIED ANSWERS A+ GRADE
The relationship (within the relation) that describes howthe value of one attribute may be
used to find the value ofanother attribute.: Functional Dependency
An attribute that can be used to find the value of anotherattribute in the relation.:
Determinant
Value can be used to find the value of every other non-keyattribute in the table. Unique and
minimal.: Candidate Key
Define & manage database structures: DDL
Adding, deleting, and modifying data - Manipulates datastored in a data- base.: DML
Used to create user accounts, manage permissions andaccess.: DCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME:
DDL
A view created and stored on the database. Underlying datais changed and also updated
in this view. Uses memory space.: Materialized View
Not stored in memory. Only computed when used oraccessed.: Virtual View
The data about the data. Describes elements such ascolumns, names, and data type.:
Metadata
,Ordered collection of elements in parentheses.: Tuple
% of table rows selected by a query: Hit Ration
Reads blocks directly, without accessing an index.: TableScan
Reads index blocks sequentially in order to locate theneeded table blocks.: Index Scan
Database repeatedly splits the index in two until it finds amatch.: Binary Search
Database object that maps one or more tables to a singlefile.: Tablespace
Specifies tables, columns, and keys. Implements databaserequirements 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 relationshipsbetween compo- nents.: Architecture
Interact directly with database users and administratorsand send queries to the query
processor. Includes Connectors & APIs, Workbench, and utility programs.: Tools
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
Link between tools and query processor: Connection
, Creates connections and manages communicationbetween tools and query parser.:
Connection Manager
Translates the query processor instructions into low-levelfile system commands that modify
or retrieve data.: Storage Engine
Accesses data on storage media. Data stored on storagemedia and orga- nized 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 foreach database object.: File System
Stores reusable information in main memory.: CacheManager
Retains data blocks from the file system for possiblereuse.: Buffer Manager
Arranged in hierarchy: Multi-tier architecture
Multi-tier consisting of web browsers and web serverscommunicating over the internet.:
Web architecture
A software layer that emulates a complete, independentcomputing envi- ronment.: Virtual
Machine
A database offered as a PaaS cloud service.: CloudDatabase
A statement or proposition from which another statementis inferred.: -Premise
Multiple processors managed by a single operating system instance. Shared memory -
share the same memoryand storage media.
