ACTUAL EXAM NEWEST VERSION 2025/2026 QUESTION AND
CORRECT DETAILED VERIFIED ANSWERS FROM VERIFIED
SOURCES RATED A GRADE.
Compiler - ANSWER-Improve language translator; requires that
the components of the software all be defined before
compilation can begin; code is more effcient
Structured Programming - ANSWER-Programmer is limited to
high level control constructs such as while loops, for loops, and
if/else statements and not allowed to use primitive GOTO
statements
Object Oriented Programming - ANSWER-Characterized by the
creation of windowed operating systems, easier real-world
object modeling in programming code, and the application of
inheritance in program code.
Interpreted Code - ANSWER-A type of programming language
for which most of its implementations execute instructions
directly and freely, without previously compiling a program into
machine-language instructions.
,Rolling up - ANSWER-Similar to drilling up but it collapses the
data from multiple items into a single value
Pivot - ANSWER-Rotates data to view the data from a different
perspective (being able to compare different sets of facts)
Online Data Processing (OLDP) - ANSWER-Deals with data in
real time
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
Batch Processing - ANSWER-Processing large amounts of data
all in one batch when the computer system is not busy
ODBC (Open Database Connectivity) - ANSWER-An interface for
accessing database management systems that can be ported to
other systems by using a driver.
Database Interacting Format - ANSWER-SELECT fields FROM
tables WHERE fields from tables match criteria
,SELECT - ANSWER-Used to inform the DBMS what fields or
attributes are of interest
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
WHERE - ANSWER-Used to inform the DBMS of the specific
criteria the data should match to be returned as the output of the
query
Project phases - ANSWER-Initiation, planning, executing and
controlling, and closing
Project Initiation - ANSWER-Problem definition, resource
allocation, risk assessment
Project Planning - ANSWER-Organize activities, time estimation,
cost estimation
Project Executing and Controlling Reports - ANSWER-Variance
reports, Status reports, Resource Allocation reports
Scope Creep - ANSWER-Adding to the scope of the project; can
impact the allocation of resources.
, Unnecessary Requirements - ANSWER-Requirements that are
not actually needed but are "nice to have"
System Development Life Cycle (SDLC) - ANSWER-A process for
planning, creating, testing, and deploying information systems,
including hardware and software
Common Steps in SDLC - ANSWER-Preliminary investigation,
Analysis, Logical design, Physical design, Implementation,
Maintenance
Preliminary investigation - ANSWER-Assesses the feasibility of
the proposed project and selects a development methodology
Analysis - ANSWER-Determines the user requirements for the
new system and develops logical models of the system
Logical design - ANSWER-Logical models are revised to ensure
that the new system will meet the user requirements identified in
the first step
Physical design - ANSWER-Logical models are converted into
physical models