All Free Software Engineering MCQs with Answers

• A. DBMS
• B. CPU
• C. DASD
• D. CAI

Explanation: A DBMS is the complete software system that defines, creates, stores, maintains, and provides controlled access to databases.

• A. Disk drive
• B. Keyboard
• C. Monitor
• D. Printer

Explanation: A disk drive stores information on magnetic or solid-state media and allows it to be retrieved later.

• A. Contains only current data
• B. Organised around important subject areas
• C. Contains numerous naming conventions and formats
• D. Can be updated by end users

Explanation: A data warehouse is organised around major subject areas such as sales, customers, or products to support analysis.

• A. cell address
• B. cell coordinates
• C. cell position
• D. cell location

Explanation: A cell address combines the column letter and row number, such as B4 or C10, to identify a spreadsheet cell.

• A. Magnetic storage
• B. Optical storage
• C. Solid-state storage
• D. Storage capacity

Explanation: Storage capacity is the maximum amount of data a storage medium can hold, usually measured in bytes such as GB or TB.

• A. hardware problem
• B. record organisation problems
• C. heavy computational demands
• D. loss of comments

Explanation: Record organisation is a data problem because the structure, format, or arrangement of stored records can hinder processing and…

• A. Data Extraction Transformation & Loading
• B. Data Execution Transformation & Loading
• C. Extraction Transformation & Loading
• D. Execution Transformation & Loading

Explanation: ETL means Extract, Transform, Load: data is taken from sources, converted into the required form, and loaded into a target store such as a…

• A. Programmers
• B. Project managers
• C. Technical writers
• D. Database administrators

Explanation: Database administrators design, implement, maintain, and secure database structures.

• A. Asset
• B. Threat
• C. Vulnerability
• D. Control

Explanation: Patient treatment records have value to the healthcare organisation and therefore qualify as information assets requiring protection.

• A. SQL
• B. PROLOG
• C. C
• D. JAVA

Explanation: SQL, originally developed at IBM, became the widely adopted standard language for defining, querying, and manipulating structured…

• A. stay on schedule
• B. allow for ample breaks
• C. brainstorm technical alternatives to problems identified in a JRP session
• D. none of these

Explanation: A JRP session should remain focused on eliciting and agreeing on requirements, with a schedule and suitable breaks.

• A. decision analysis phase
• B. requirements analysis phase
• C. design analysis phase
• D. problem analysis phase

Explanation: The conventional systems-analysis phases include problem analysis, requirements analysis, and decision analysis.

• A. system analysts
• B. system designers
• C. system owners
• D. none of the above

Explanation: The people who directly operate a system or use it to support their work are system users.

• A. Value
• B. Decision making
• C. Business
• D. Re-engineering

Explanation: A business process transforms inputs into outputs through activities such as measurement, analysis, processing, storage, and…

• A. requirements management
• B. sampling of existing documentation, forms and files
• C. requirements discovery
• D. problem discovery and analysis

Explanation: Sampling existing documents, forms, and files is a technique used during requirements investigation, not one of the main activities in the…

• A. rapid architected analysis
• B. object-oriented analysis
• C. data modeling
• D. discovery prototyping

Explanation: Rapid architected analysis derives system models by examining an existing system or a discovery prototype, helping analysts understand its…

• A. Sales
• B. Service
• C. Manufacturing
• D. Benefits and Compensation

Explanation: Sales, service, and manufacturing are commonly treated as major business functions.

• A. Input
• B. Processing
• C. Control and feedback
• D. All of the above

Explanation: Control and feedback are most directly used to monitor a business process, compare results with targets, and correct poor performance.

• A. business process redesign
• B. knowledge asset management
• C. proliferation of networks and the Internet
• D. security and privacy

Explanation: Business process redesign, knowledge-asset management, and security or privacy concerns can motivate an information system.

• A. scope
• B. functional requirement
• C. preliminary requirement
• D. nonfunctional requirement

Explanation: A nonfunctional requirement specifies a required quality or constraint, such as security, speed, reliability, or usability.