New York City Computer Systems Analyst
Practice Exam Questions With Correct Answers
(Verified Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf
1. Which of the following best describes the primary role of a
computer systems analyst?
A. Writing end-user manuals
B. Maintaining computer hardware
C. Evaluating and improving computer systems to meet business
needs
D. Installing software updates
Rationale: A computer systems analyst primarily evaluates and
improves existing computer systems or designs new systems to meet
business objectives. While they may perform other tasks, the focus is on
analysis and improvement, not just documentation or maintenance.
2. In systems analysis, what is the main purpose of a feasibility
study?
A. To test the software for bugs
B. To determine if a proposed system is practical and achievable
C. To train end-users on the new system
D. To design the user interface
,Rationale: A feasibility study assesses whether a proposed system is
technically, economically, and operationally feasible before committing
resources to its development.
3. Which diagram is typically used to represent the flow of data
within a system?
A. Gantt Chart
B. Use Case Diagram
C. Data Flow Diagram (DFD)
D. Class Diagram
Rationale: A Data Flow Diagram (DFD) visually represents how data
moves through a system, including processes, data stores, and external
entities.
4. What is the primary purpose of normalization in database design?
A. To reduce server load
B. To increase query speed
C. To minimize data redundancy and improve data integrity
D. To make data human-readable
Rationale: Normalization organizes database tables to reduce
redundancy, prevent anomalies, and ensure consistent and reliable
data.
5. Which programming paradigm focuses on objects that contain
both data and behavior?
, A. Procedural programming
B. Object-oriented programming
C. Functional programming
D. Logic programming
Rationale: Object-oriented programming (OOP) organizes software
design around objects, which encapsulate both data (attributes) and
behavior (methods).
6. In project management, what does the acronym "PERT" stand for?
A. Project Evaluation and Resource Timing
B. Program Execution Review Tool
C. Program Evaluation and Review Technique
D. Performance Evaluation Resource Tracker
Rationale: PERT is a project management tool used to analyze and
represent the tasks involved in completing a project, including time
estimates and dependencies.
7. What is the main difference between primary memory and
secondary memory?
A. Primary memory is slower than secondary memory
B. Secondary memory is volatile
C. Primary memory is volatile and used for immediate access,
while secondary memory is non-volatile storage
D. Secondary memory is used only for temporary data
, Rationale: Primary memory (RAM) is volatile and provides fast access
for active processes, whereas secondary memory (hard drives, SSDs) is
persistent and stores data long-term.
8. Which of the following is an example of an input device?
A. Monitor
B. Keyboard
C. Printer
D. Speaker
Rationale: Input devices allow users to enter data into a computer.
Keyboards, mice, and scanners are common examples.
9. In a relational database, which SQL statement is used to retrieve
data from a table?
A. INSERT
B. UPDATE
C. SELECT
D. DELETE
Rationale: The SELECT statement is used to query and retrieve data from
relational database tables.
10. Which software development methodology emphasizes
iterative development and collaboration between cross-functional
teams?
A. Waterfall
Practice Exam Questions With Correct Answers
(Verified Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf
1. Which of the following best describes the primary role of a
computer systems analyst?
A. Writing end-user manuals
B. Maintaining computer hardware
C. Evaluating and improving computer systems to meet business
needs
D. Installing software updates
Rationale: A computer systems analyst primarily evaluates and
improves existing computer systems or designs new systems to meet
business objectives. While they may perform other tasks, the focus is on
analysis and improvement, not just documentation or maintenance.
2. In systems analysis, what is the main purpose of a feasibility
study?
A. To test the software for bugs
B. To determine if a proposed system is practical and achievable
C. To train end-users on the new system
D. To design the user interface
,Rationale: A feasibility study assesses whether a proposed system is
technically, economically, and operationally feasible before committing
resources to its development.
3. Which diagram is typically used to represent the flow of data
within a system?
A. Gantt Chart
B. Use Case Diagram
C. Data Flow Diagram (DFD)
D. Class Diagram
Rationale: A Data Flow Diagram (DFD) visually represents how data
moves through a system, including processes, data stores, and external
entities.
4. What is the primary purpose of normalization in database design?
A. To reduce server load
B. To increase query speed
C. To minimize data redundancy and improve data integrity
D. To make data human-readable
Rationale: Normalization organizes database tables to reduce
redundancy, prevent anomalies, and ensure consistent and reliable
data.
5. Which programming paradigm focuses on objects that contain
both data and behavior?
, A. Procedural programming
B. Object-oriented programming
C. Functional programming
D. Logic programming
Rationale: Object-oriented programming (OOP) organizes software
design around objects, which encapsulate both data (attributes) and
behavior (methods).
6. In project management, what does the acronym "PERT" stand for?
A. Project Evaluation and Resource Timing
B. Program Execution Review Tool
C. Program Evaluation and Review Technique
D. Performance Evaluation Resource Tracker
Rationale: PERT is a project management tool used to analyze and
represent the tasks involved in completing a project, including time
estimates and dependencies.
7. What is the main difference between primary memory and
secondary memory?
A. Primary memory is slower than secondary memory
B. Secondary memory is volatile
C. Primary memory is volatile and used for immediate access,
while secondary memory is non-volatile storage
D. Secondary memory is used only for temporary data
, Rationale: Primary memory (RAM) is volatile and provides fast access
for active processes, whereas secondary memory (hard drives, SSDs) is
persistent and stores data long-term.
8. Which of the following is an example of an input device?
A. Monitor
B. Keyboard
C. Printer
D. Speaker
Rationale: Input devices allow users to enter data into a computer.
Keyboards, mice, and scanners are common examples.
9. In a relational database, which SQL statement is used to retrieve
data from a table?
A. INSERT
B. UPDATE
C. SELECT
D. DELETE
Rationale: The SELECT statement is used to query and retrieve data from
relational database tables.
10. Which software development methodology emphasizes
iterative development and collaboration between cross-functional
teams?
A. Waterfall
