WGU D024 PRACTICE EXAMINATION 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ Reads blocks directly, without accessing an index..
Answer: Table Scan
◍ The table specified in the view query's FROM clause..
Answer: Base Table
◍ Multiple values removed. Only one value in each cell..
Answer: First Normal Form
◍ What system assists in ensuring patient safety by utilizing a computer to
collect and manage data?.
Answer: Database management system
◍ Grid of bits.
Answer: Bitmap Index
◍ Ensures transactions are properly executed..
Answer: Transaction Manager
◍ List of partition expression values using VALUES IN keywords..
Answer: List Partition
◍ A nurse performs a patient assessment and documents the pain level as acute
within the electronic health record. Which patient care benefit does this
provide?.
Answer: Support data exchange with internal systems
◍ Returns only matching values..
Answer: Inner Join
◍ A physician's office wants to adopt an electronic medical record. The
providers and staff are unsure which system will best suit the needs of the
, office.Which system development life cycle approach suits this practice?.
Answer: Adaptive
◍ Sequence of columns in which each column has a one-many relationship to
the next column..
Answer: Dimension Hierarchy
◍ Single or multi-level index where pointers to table blocks are replaced with
primary key values.
Answer: Logical Index
◍ A directory of participating database objects such as tables, columns, and
indexes..
Answer: Global Catalog
◍ Relates an entity to itself.
Answer: Reflexive Relationship
◍ Which example demonstrates an outcome of the implementation of a
point-of-care alert/number?.
Answer: Triggers care providers' awareness of patient's necessary care
◍ Which standardized clinical terminology provides the official names and
standardized codes for laboratory and other clinical observations?.
Answer: Logical Observation Identifier Names and Codes (LOINC)
◍ Why do healthcare facilities favor purchased information systems over
organization-developed information systems?.
Answer: System enhancements are provided
◍ Specifies an expression on one or more columns of a table. Violated when
the expression is false and satisfied when the expression is true or null..
Answer: Check
◍ An unordered collection of elements enclosed in braces..
Answer: Set
◍ AKA: Nonclustering Index. Index that is not on the sort column. Always
dense..
, Answer: Secondary Index
◍ A database that is packaged with a programming language. AKA:
In-Process Database (Database Architecture) - SQLite - SQL Server
Compact.
Answer: Embedded Databases
◍ AKA: Hard-Disk Drive. Used to share large amounts of data. Groups data in
sectors, traditionally 512 bytes per sector, but 4 kb with newer disk formats..
Answer: Magnetic Disk
◍ Adding, deleting, and modifying data - Manipulates data stored in a
database..
Answer: DML
◍ An electronic medical record project has been implemented. The executive
team has approved the system and signed for payment to the vendor. The
information technology manager has verified that items on the issues list
have been resolved.In which phase is the project management team
working?.
Answer: Closing the project
◍ Multiple processors managed by a single operating system instance. Shared
memory - share the same memory and storage media. Shared storage - share
storage media only. Shared nothing.
Answer: Parallel Computer
◍ A subset of table data, usually a subset of rows rather than columns. Stored
on different computers of a distributed database..
Answer: Shard
◍ AKA: Multi-tables. Interleave rows of two or more tables in the same
storage area. They contain cluster keys..
Answer: Table Clusters
◍ All indexed values appear in the bottom level.
Answer: B+Tree
QUESTIONS WITH ANSWERS GRADED A+
◍ Reads blocks directly, without accessing an index..
Answer: Table Scan
◍ The table specified in the view query's FROM clause..
Answer: Base Table
◍ Multiple values removed. Only one value in each cell..
Answer: First Normal Form
◍ What system assists in ensuring patient safety by utilizing a computer to
collect and manage data?.
Answer: Database management system
◍ Grid of bits.
Answer: Bitmap Index
◍ Ensures transactions are properly executed..
Answer: Transaction Manager
◍ List of partition expression values using VALUES IN keywords..
Answer: List Partition
◍ A nurse performs a patient assessment and documents the pain level as acute
within the electronic health record. Which patient care benefit does this
provide?.
Answer: Support data exchange with internal systems
◍ Returns only matching values..
Answer: Inner Join
◍ A physician's office wants to adopt an electronic medical record. The
providers and staff are unsure which system will best suit the needs of the
, office.Which system development life cycle approach suits this practice?.
Answer: Adaptive
◍ Sequence of columns in which each column has a one-many relationship to
the next column..
Answer: Dimension Hierarchy
◍ Single or multi-level index where pointers to table blocks are replaced with
primary key values.
Answer: Logical Index
◍ A directory of participating database objects such as tables, columns, and
indexes..
Answer: Global Catalog
◍ Relates an entity to itself.
Answer: Reflexive Relationship
◍ Which example demonstrates an outcome of the implementation of a
point-of-care alert/number?.
Answer: Triggers care providers' awareness of patient's necessary care
◍ Which standardized clinical terminology provides the official names and
standardized codes for laboratory and other clinical observations?.
Answer: Logical Observation Identifier Names and Codes (LOINC)
◍ Why do healthcare facilities favor purchased information systems over
organization-developed information systems?.
Answer: System enhancements are provided
◍ Specifies an expression on one or more columns of a table. Violated when
the expression is false and satisfied when the expression is true or null..
Answer: Check
◍ An unordered collection of elements enclosed in braces..
Answer: Set
◍ AKA: Nonclustering Index. Index that is not on the sort column. Always
dense..
, Answer: Secondary Index
◍ A database that is packaged with a programming language. AKA:
In-Process Database (Database Architecture) - SQLite - SQL Server
Compact.
Answer: Embedded Databases
◍ AKA: Hard-Disk Drive. Used to share large amounts of data. Groups data in
sectors, traditionally 512 bytes per sector, but 4 kb with newer disk formats..
Answer: Magnetic Disk
◍ Adding, deleting, and modifying data - Manipulates data stored in a
database..
Answer: DML
◍ An electronic medical record project has been implemented. The executive
team has approved the system and signed for payment to the vendor. The
information technology manager has verified that items on the issues list
have been resolved.In which phase is the project management team
working?.
Answer: Closing the project
◍ Multiple processors managed by a single operating system instance. Shared
memory - share the same memory and storage media. Shared storage - share
storage media only. Shared nothing.
Answer: Parallel Computer
◍ A subset of table data, usually a subset of rows rather than columns. Stored
on different computers of a distributed database..
Answer: Shard
◍ AKA: Multi-tables. Interleave rows of two or more tables in the same
storage area. They contain cluster keys..
Answer: Table Clusters
◍ All indexed values appear in the bottom level.
Answer: B+Tree
