C182 / D322 Objective Assessment (Latest Update 2025 / 2026) Introduction to IT | Questions and Answers | Grade A | 100% Correct - WGU
Question:
Online Data Processing (OLDP)
Answer:
Deals with data in real time
Question:
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
- / 4
Question:
Batch Processing
Answer:
Processing large amounts of data all in one batch when the computer system is not busy
Question:
ODBC (Open Database Connectivity)
Answer:
An interface for accessing database management systems that can be ported to other systems by using a driver.
Question:
Database Interacting Format
Answer:
SELECT fields FROM tables WHERE fields from tables match criteria
- / 4
Question:
SELECT * FROM Patient WHERE PatientID = '223344';
Answer:
The SELECT statement identifies the records that are being requested, and the asterisk (*) means everything from that table. The parameter after FROM identifies the table name (Patient). The next keyword, WHERE, is the condition the query is requesting.
Question:
SELECT
Answer:
Used to inform the DBMS what fields or attributes are of interest
Question:
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
- / 4
Question:
WHERE
Answer:
Used to inform the DBMS of the specific criteria the data should match to be returned as the output of the query
Question:
Project phases
Answer:
Initiation, planning, executing and controlling, and closing
Question:
Project Initiation
Answer:
Problem definition, resource allocation, risk assessment
Question:
Project Planning
Answer:
Organize activities, time estimation, cost estimation
- / 4