WGU D120 PRACTICE EXAMINATION 2026
QUESTIONS WITH ANSWERS GRADED A+
◍ Processing.
Answer: Raw data is organized or structured for usefulness.
◍ Primary Key.
Answer: A field in the relations that contains a unique value, such as a
license plate, phone number, or Social Security Number.
◍ Web Administrator.
Answer: Installs, configures, maintains, secures, and troubleshoots web
severs.
◍ Database Management System (DBMS).
Answer: Used to create, manipulate, and access the data in a database
◍ Evolution of Storage.
Answer: Punch cards, magnetic tape, hard disks, floppy disks, optical discs,
flash memory, cloud storage
◍ Project Executing and Controlling Reports.
Answer: Variance reports, Status reports, Resource Allocation reports
◍ Model-View-Controller (MVC).
Answer: A development technique used in the implementation of user
interfaces
◍ Anti-virus Software.
Answer: Attempts to identify if a file contains a virus or some form of
malware
◍ Flat File Database.
Answer: One large single table; used if the amount of data that is being
, recorded is fairly minimal
◍ Open Source.
Answer: Created in the Open Source Community and made freely available
as source code
◍ FROM.
Answer: Used to inform the DBMS what tables are to be interrogated by the
query and if more than one table, how they are to be combined or joined
◍ Compiler.
Answer: Improve language translator; requires that the components of the
software all be defined before compilation can begin; code is more effcient
◍ Machine/Low-level Language.
Answer: Written for a specific machine by the engineers who built and ran
the computers; no need for OS since only one program could run at a time
◍ Rolling up.
Answer: Similar to drilling up but it collapses the data from multiple items
into a single value
◍ Event-driven Processing.
Answer: Uses business event to trigger messages to be sent by middleware
between software modules that are completely independent of one another
◍ Waterfall Model.
Answer: Used during the system development life cycle (SDLC) to denote
the fact that each step should be completed one at a time.
◍ Hacking.
Answer: When an individual obtains unauthorized access to a host
◍ Implementation.
Answer: Begin converting the models from the previous steps into the actual
system; this step also includes installing hardware, testing the system, and
training the end users
◍ Drilling up and down.
, Answer: Shifts the view of the data; down provides more detail, up provides
summarized data
◍ Preliminary investigation.
Answer: Assesses the feasibility of the proposed project and selects a
development methodology
◍ String Data.
Answer: Alphanumeric or text character
◍ The Model.
Answer: Can take on different forms depending on the complexity of the
application; in certain instances, it is an actual object that is an actual
implementation of the application
◍ FTP Server.
Answer: Like web server or file server in that requests are for files and
responses are the files; data delivered between client and server.
◍ SQL Injection.
Answer: An attacker issues a SQL command to a web server as part of the
URL or as input to a form on a company's website; web server might pass
the command onto the database which then allows potentially anything to be
done to the database
◍ User Acceptance Testing.
Answer: Employed to assess whether the system does what the user expects
and to ensure that it functions in a way that is useful to the user
◍ Script.
Answer: A computer language with a series of commands within a file that
is capable of being executed without being compiled.
◍ Compiled Language.
Answer: Translates the entire program using a compiler, creating an
executable program which can be run at a later time; the program can then
be run as many times as one likes, without having to re-translate each time.
QUESTIONS WITH ANSWERS GRADED A+
◍ Processing.
Answer: Raw data is organized or structured for usefulness.
◍ Primary Key.
Answer: A field in the relations that contains a unique value, such as a
license plate, phone number, or Social Security Number.
◍ Web Administrator.
Answer: Installs, configures, maintains, secures, and troubleshoots web
severs.
◍ Database Management System (DBMS).
Answer: Used to create, manipulate, and access the data in a database
◍ Evolution of Storage.
Answer: Punch cards, magnetic tape, hard disks, floppy disks, optical discs,
flash memory, cloud storage
◍ Project Executing and Controlling Reports.
Answer: Variance reports, Status reports, Resource Allocation reports
◍ Model-View-Controller (MVC).
Answer: A development technique used in the implementation of user
interfaces
◍ Anti-virus Software.
Answer: Attempts to identify if a file contains a virus or some form of
malware
◍ Flat File Database.
Answer: One large single table; used if the amount of data that is being
, recorded is fairly minimal
◍ Open Source.
Answer: Created in the Open Source Community and made freely available
as source code
◍ FROM.
Answer: Used to inform the DBMS what tables are to be interrogated by the
query and if more than one table, how they are to be combined or joined
◍ Compiler.
Answer: Improve language translator; requires that the components of the
software all be defined before compilation can begin; code is more effcient
◍ Machine/Low-level Language.
Answer: Written for a specific machine by the engineers who built and ran
the computers; no need for OS since only one program could run at a time
◍ Rolling up.
Answer: Similar to drilling up but it collapses the data from multiple items
into a single value
◍ Event-driven Processing.
Answer: Uses business event to trigger messages to be sent by middleware
between software modules that are completely independent of one another
◍ Waterfall Model.
Answer: Used during the system development life cycle (SDLC) to denote
the fact that each step should be completed one at a time.
◍ Hacking.
Answer: When an individual obtains unauthorized access to a host
◍ Implementation.
Answer: Begin converting the models from the previous steps into the actual
system; this step also includes installing hardware, testing the system, and
training the end users
◍ Drilling up and down.
, Answer: Shifts the view of the data; down provides more detail, up provides
summarized data
◍ Preliminary investigation.
Answer: Assesses the feasibility of the proposed project and selects a
development methodology
◍ String Data.
Answer: Alphanumeric or text character
◍ The Model.
Answer: Can take on different forms depending on the complexity of the
application; in certain instances, it is an actual object that is an actual
implementation of the application
◍ FTP Server.
Answer: Like web server or file server in that requests are for files and
responses are the files; data delivered between client and server.
◍ SQL Injection.
Answer: An attacker issues a SQL command to a web server as part of the
URL or as input to a form on a company's website; web server might pass
the command onto the database which then allows potentially anything to be
done to the database
◍ User Acceptance Testing.
Answer: Employed to assess whether the system does what the user expects
and to ensure that it functions in a way that is useful to the user
◍ Script.
Answer: A computer language with a series of commands within a file that
is capable of being executed without being compiled.
◍ Compiled Language.
Answer: Translates the entire program using a compiler, creating an
executable program which can be run at a later time; the program can then
be run as many times as one likes, without having to re-translate each time.
