ICSAN Pre-Professional - Management Information System (Nigeria)

Which of the following best describes the relationship between data and information within a Management Information System (MIS)?

• AData is processed information that has been contextualized for decision-making
• BData represents raw, unorganized facts, while information is data that has been processed…
• CData and information are synonymous terms and can be used interchangeably in MIS reporting
• DInformation is the raw input captured by transaction systems, whereas data is the final o…

A company's daily sales transaction recording system is an example of which type of information system?

• ADecision Support System (DSS)
• BExecutive Support System (ESS)
• CTransaction Processing System (TPS)
• DKnowledge Work System (KWS)

Which of the following characteristics is unique to a Decision Support System (DSS) compared to a traditional Transaction Processing System (TPS)?

• AIt focuses on processing large volumes of routine, repetitive transactions
• BIt utilizes mathematical models and data analysis tools to assist in solving semi-structu…
• CIt is primarily used by operational-level staff for day-to-day activity tracking
• DIt strictly produces rigid, scheduled historical reports with no interactive capabilities

In Porter's Five Forces Model, how can a firm use a Management Information System (MIS) to raise barriers to entry for new competitors?

• ABy reducing the switching costs for existing customers
• BBy increasing the bargaining power of buyers through open data access
• CBy deploying proprietary technology that locks in customers and creates high setup costs…
• DBy encouraging suppliers to diversify their customer base using open protocols

Which of the following features is most critical to an Executive Support System (ESS) designed for senior corporate administrators?

• ADetailed, low-level transaction logs
• BHigh-level summary dashboards with drill-down capabilities to explore aggregate data
• CRigid database schemas that prevent ad-hoc querying
• DSupport for automated assembly line machinery controls

Under Michael Porter's Value Chain Model, which of the following activities is classified as a 'Support Activity'?

• AInbound Logistics
• BOperations
• CTechnology Development (IT Infrastructure)
• DMarketing and Sales

What role does 'feedback' play in the cybernetic model of an organizational information system?

• AIt acts as the primary power source for hardware devices
• BIt refers to the output that is returned to appropriate members of the organization to he…
• CIt is the process of discarding obsolete archival tapes
• DIt is the direct entry of transactions by clients through mobile portals

Which of the following best defines 'strategic alignment' of information systems?

• AEnsuring that all servers are physically aligned in a data center rack
• BMatching the capabilities and goals of the information systems with the business strategy…
• CEnsuring that the database schema uses normalized tables for query efficiency
• DMandating that all employees use the same brand of mobile hardware

Which type of information system is specifically designed to create, store, and disseminate organizational expertise and tacit knowledge?

• ATransaction Processing System (TPS)
• BKnowledge Management System (KMS)
• CEnterprise Resource Planning (ERP)
• DSupply Chain Management (SCM)

In modern corporate governance, what is the primary responsibility of the Chief Information Officer (CIO)?

• AWriting code for routine applications and repairing broken PCs
• BBridging the gap between business strategy and IT operations, ensuring IT governance and…
• CManaging the physical security of the corporate headquarters building
• DOverseeing the legal drafting of employee contracts

During which phase of the traditional Systems Development Life Cycle (SDLC) are user requirements gathered and documented?

• ASystem Design
• BSystem Implementation
• CSystem Analysis
• DSystem Maintenance

An Information System is composed of several interactive components. Which component is responsible for defining the rules and procedures for using the system?

• ASoftware
• BHardware
• CProcesses / Procedures
• DTelecommunications

In the context of global MIS implementation, what does the term 'Digital Divide' refer to?

• AThe partition between database tables to avoid redundancy
• BThe gap between demographics and regions that have access to modern information technolog…
• CThe separation of roles between developers and database administrators
• DThe speed difference between CPU processing and hard drive access

Which of the following is the primary purpose of an Office Automation System (OAS)?

• ATo run complex mathematical simulations for geological data
• BTo facilitate communication, collaboration, and document management among office workers
• CTo automate physical inventory movements in a warehouse using robotics
• DTo control high-speed manufacturing lines

Which type of system is primarily used by engineers to design products and by manufacturers to control production machinery?

• ATransaction Processing System (TPS)
• BExecutive Support System (ESS)
• CCAD / CAM Systems
• DCustomer Relationship Management (CRM)

What is a key benefit of adopting an 'Open System' architecture in corporate information systems?

• AIt allows any anonymous user to modify database records without authentication
• BIt uses public standards and protocols to facilitate interoperability and integration bet…
• CIt requires all systems to run without any firewall or security boundaries
• DIt guarantees that software is free of charge

Which of the following is a common risk associated with relying on 'Legacy Systems' in an enterprise?

• AThey are too easy to modify and update
• BHigh maintenance costs, lack of vendor support, and difficulty in integrating with modern…
• CThey inherently consume zero electricity
• DThey automatically migrate themselves to the cloud

A company implements a real-time package tracking system for its customers to improve customer satisfaction. Which strategic business objective is the company primarily pursuing?

• ASurvival
• BCustomer and Supplier Intimacy
• CCompetitive Advantage
• DImproved Decision Making

What does 'Business Process Redesign (BPR)' typically entail when introducing new Management Information Systems?

• ASimply automating existing manual processes without changing their underlying workflows
• BThe radical redesign of business processes to achieve dramatic improvements in cost, qual…
• CReplacing all computer hardware with newer models without altering software
• DChanging the physical layout of the office furniture

When calculating the Total Cost of Ownership (TCO) of a new MIS project, which cost component is most frequently underestimated?

• AThe initial hardware acquisition price
• BThe software license purchase cost
• COngoing operational costs, including training, support, maintenance, and system downtime
• DThe physical server room electrical conduits

Which of the following computer hardware components is classified as 'volatile primary storage'?

• ASolid State Drive (SSD)
• BRandom Access Memory (RAM)
• CRead Only Memory (ROM)
• DMagnetic Tape

Which of the following is classified as 'System Software' rather than 'Application Software'?

• AEnterprise Resource Planning (ERP) database client
• BOperating System (e.g., Microsoft Windows, Linux)
• CWeb Browser (e.g., Google Chrome)
• DElectronic Spreadsheet (e.g., Microsoft Excel)

What is the defining characteristic of 'Open Source Software'?

• AIt can be accessed by anyone without any internet connection
• BThe source code is freely available for inspection, modification, and redistribution unde…
• CIt is developed exclusively by government agencies
• DIt does not require an operating system to run

In database design, what is the primary purpose of 'normalization'?

• ATo ensure that all text columns contain only uppercase characters
• BTo eliminate data redundancy and prevent update anomalies by organizing data logically in…
• CTo combine all database tables into a single giant flat file
• DTo encrypt data before transmitting it over the network

In a relational database, what is the function of a 'Foreign Key'?

• ATo serve as the unique identifier for every record in its own table
• BTo establish a link or relationship between two tables by referencing the primary key of…
• CTo store data from international customers only
• DTo serve as a password for administrative database access

Which SQL command is used to retrieve data from a relational database?

• AINSERT
• BUPDATE
• CSELECT
• DCREATE

Which of the following best distinguishes a 'Data Warehouse' from an 'Operational Database' (OLTP)?

• AA Data Warehouse is optimized for fast daily transaction writing, whereas an Operational…
• BA Data Warehouse aggregates historical, read-only data from multiple sources for business…
• COperational Databases are always cloud-based, while Data Warehouses must run on mainframe…
• DData Warehouses contain only unstructured audio files, while Operational Databases contai…

A company uses Microsoft 365 or Google Workspace for email and document editing. Which cloud service model does this represent?

• AInfrastructure as a Service (IaaS)
• BPlatform as a Service (PaaS)
• CSoftware as a Service (SaaS)
• DDatabase as a Service (DBaaS)

Which of the following devices acts as both an input and an output device in an enterprise MIS setup?

• ABarcode Scanner
• BInteractive Touchscreen Monitor
• CLaser Printer
• DCentral Processing Unit (CPU)

What is the primary function of a Database Management System (DBMS)?

• ATo generate electrical power back-up for server racks
• BTo act as a software interface between application programs and the physical database fil…
• CTo design physical hardware microchips
• DTo manage email communication protocols between mail servers

What is the role of a 'Data Dictionary' (or metadata repository) within a DBMS?

• ATo translate SQL queries into foreign languages
• BTo store definitions, descriptions, types, and relationships of all data elements in the…
• CTo index websites for search engine optimization
• DTo check spelling errors in user-entered data

What is 'virtualization' in the context of enterprise IT infrastructure?

• ASimulating physical products in virtual reality for customers
• BThe process of running multiple operating systems and virtual machines on a single physic…
• CConverting physical paper files into PDF documents
• DDesigning a corporate office layout virtually before construction

Which of the following best defines 'Data Mining'?

• APhysically extracting minerals with computerized drills
• BAnalyzing large datasets to discover hidden patterns, trends, and relationships to predic…
• CBacking up database files onto magnetic media
• DEntering new rows of data into a spreadsheet manually

For which scenario would a NoSQL database be more suitable than a traditional relational database (RDBMS)?

• AHandling rigid, highly structured financial ledger records requiring ACID compliance
• BManaging massive volumes of unstructured or semi-structured data with highly dynamic sche…
• CGenerating simple static monthly reports
• DConnecting only two users in a local area network

What are the three core characteristics of 'Big Data' (often referred to as the 3 Vs)?

• AValidity, Verification, Value
• BVolume, Velocity, Variety
• CVirtualization, Volatility, Vulnerability
• DVector, Variable, View

What does Moore's Law predict regarding computer hardware components?

• AThe cost of software will double every year
• BThe number of transistors on a microchip doubles roughly every two years, while the cost…
• CNetwork transmission speeds will decrease as user numbers grow
• DPhysical hard drive platters will be replaced by optical storage in five years

What is the key difference between a compiler and an interpreter?

• AA compiler translates code line-by-line during runtime, while an interpreter translates t…
• BA compiler translates the entire source code into machine code files before execution, wh…
• CCompilers are hardware components, whereas interpreters are software programs
• DCompilers are only used for databases, while interpreters are only used for operating sys…

Which of the following is a key concept of Object-Oriented Programming (OOP)?

• AFlat-file data modeling
• BEncapsulation (combining data and behavior into a single class)
• CSequential instruction execution without functions
• DAnalog signal conversion

Why are Solid State Drives (SSDs) increasingly preferred over Hard Disk Drives (HDDs) in corporate laptops?

• ASSDs contain moving platters that are easier to repair
• BSSDs use flash memory with no moving parts, offering significantly faster read/write spee…
• CSSDs are always cheaper per gigabyte than HDDs
• DSSDs require magnetic tape drives to write data

What is a 'multi-core processor'?

• AA processor that requires multiple physical power supplies to operate
• BAn integrated circuit containing two or more independent processing units (cores) that ex…
• CA database structure that divides tables across different countries
• DA software application that coordinates multiple database servers

Which of the following best describes the difference between a Local Area Network (LAN) and a Wide Area Network (WAN)?

• ALANs connect computers across multiple continents, while WANs are confined to a single ro…
• BLANs cover a small geographic area, such as a single office building, while WANs connect…
• CLANs transmit only voice signals, while WANs transmit only database files
• DLANs do not require cables, while WANs are strictly wired

Why is the global IT industry transitioning from IPv4 to IPv6?

• AIPv6 is slower and allows governments to restrict internet access more easily
• BIPv4 has a limited address space (32-bit) and has run out of unique addresses, whereas IP…
• CIPv4 is incompatible with fiber optic cables
• DIPv6 is free of licensing costs, while IPv4 requires annual fees

What is the primary purpose of a Virtual Private Network (VPN) in corporate networks?

• ATo speed up physical printing queues
• BTo create a secure, encrypted connection (tunnel) over a public network (like the interne…
• CTo host public marketing websites
• DTo physically isolate computers in different rooms

What is the function of the Domain Name System (DNS) on the Internet?

• ATo assign email addresses to new employees automatically
• BTo translate human-readable domain names (e.g., www.icsan.org.ng) into machine-readable I…
• CTo block spam emails at the gateway router
• DTo charge website owners for hosting services