Tribhuvan University
Faculty of Management
Office of the Dean
2024 AD / Regular Examination
Time: 3 Hrs. | Full Marks: 60 | Pass Marks: 30
Section A
Brief Answer Questions. Attempt ALL questions.
[10 * 1 = 10]- [2]
What is an analog computer?
View model solution
Concept of Analog Computer:
An analog computer is a computing device that processes and represents data using continuous physical variables (such as electrical voltage, hydraulic pressure, mechanical motion, or temperature) rather than discrete binary numbers (0s and 1s).
Key Characteristics:
- Performs simultaneous parallel differential calculations in real time without analog-to-digital conversion.
- Common applications include flight simulators, seismic monitors, automobile speedometers, and industrial chemical process controllers.
- [2]
What are the components of information system?
View model solution
Components of an Information System (IS):
An Information System consists of five interrelated components that collect, process, store, and distribute information:
- Hardware: Physical electronic devices (CPUs, servers, workstations, storage drives, networking gear).
- Software: Programs and applications (operating systems, DBMS, productivity software) that instruct hardware.
- Data: Raw facts, figures, and transactional records stored in structured databases.
- People: End-users, systems analysts, database administrators, and software engineers.
- Procedures / Processes: Operational rules, workflows, security protocols, and business policies governing system usage.
- [2]
List the components of CPU.
View model solution
Components of the Central Processing Unit (CPU):
The CPU (the “brain” of the computer) consists of the following core components:
- Arithmetic Logic Unit (ALU): Executes arithmetic operations (addition, subtraction) and logical comparisons (AND, OR, NOT).
- Control Unit (CU): Directs the flow of data and instructions through the CPU, decoding instructions and synchronizing components.
- Registers: Ultra-high-speed internal memory storage locations (e.g., Program Counter, Accumulator, Instruction Register).
- Internal Cache Memory (L1/L2/L3): High-speed SRAM buffering frequently accessed instructions between the CPU core and main RAM.
- [2]
Define programming language.
View model solution
Definition of Programming Language:
A programming language is a formalized artificial language consisting of a vocabulary, syntactic rules, and semantic conventions used to write instructions (code) that control the behavior of a computer and implement computational algorithms.
Major Categories:
- Low-Level Languages: Machine language (pure binary 0s and 1s) and Assembly language (using symbolic mnemonics).
- High-Level Languages: Human-readable, portable languages abstracted from hardware architectures (e.g., Python, Java, C++, SQL).
- [2]
Define Data Warehouse.
View model solution
Definition of Data Warehouse:
According to W.H. Inmon, a data warehouse is a subject-oriented, integrated, time-variant, and non-volatile collection of consolidated historical data extracted from multiple disparate operational databases, designed to support executive managerial decision-making and business intelligence (BI) reporting.
Core Utility:
Separates analytical querying and online analytical processing (OLAP) workloads from daily transactional processing (OLTP) databases.
- [2]
Define topology.
View model solution
Definition of Network Topology:
Network topology refers to the physical or logical arrangement and geometric layout of nodes (computers, servers, switches, routers) and their connecting transmission links within a computer communication network.
Common Standard Topologies:
- Star Topology: All nodes connect to a central hub/switch.
- Bus Topology: Devices share a single linear central backbone cable.
- Ring, Mesh, and Hybrid Topologies: Offering redundant and resilient multi-path interconnections.
- [2]
List any two examples of search engine.
View model solution
Two Examples of Search Engines:
- Google Search: The globally dominant search engine developed by Google LLC, utilizing sophisticated PageRank algorithms, neural semantic matching, and web indexing crawlers.
- Microsoft Bing: A major web search engine developed and operated by Microsoft Corporation, integrated with conversational artificial intelligence models.
- [2]
List any two characteristics of multimedia.
View model solution
Two Key Characteristics of Multimedia:
- Integration of Multiple Media Formats: Seamlessly combines and synchronizes at least two diverse media types (text, graphics, audio, animation, and video) into a unified digital presentation.
- Interactivity and User Control: Empowers the user to navigate, control the sequence of playback, search content, and manipulate digital elements dynamically rather than passively observing.
- [2]
Define computer crime.
View model solution
Definition of Computer Crime (Cybercrime):
A computer crime is any unlawful, illegal, or unauthorized activity in which a computer, network, or electronic digital device serves as either the primary instrument, the targeted victim, or the storage repository of criminal offenses.
Examples:
Unauthorized system hacking, ransomware extortion, identity theft, financial phishing, distributed denial-of-service (DDoS) attacks, and intellectual property piracy (governed in Nepal under the Electronic Transactions Act, 2063).
- [2]
Define digital marketing.
View model solution
Definition of Digital Marketing:
Digital marketing encompasses all promotional and brand marketing activities executed through internet-connected electronic digital devices, online channels, and technological platforms.
Key Channels:
- Search Engine Optimization (SEO) & Search Engine Marketing (SEM).
- Social Media Marketing (Facebook, Instagram, LinkedIn).
- Email Marketing campaigns and Influencer Content Marketing.
Section B
Short Answer Questions. Attempt any FIVE questions.
[5 * 6 = 30]- [6]
Explain any three application of computer.
View model solution
Three Major Applications of Computers in Contemporary Society:
1. Banking and Financial Services (Fintech):
- Computers power 24/7 online banking, mobile payment gateways (eSewa, Khalti, Fonepay), and international interbank communications via the SWIFT network.
- Automated Teller Machines (ATMs) and Core Banking Software (CBS) process millions of multi-currency customer ledger transactions simultaneously with zero computational error.
- Algorithmic trading systems execute high-frequency stock trades on the Nepal Stock Exchange (NEPSE) in milliseconds.
2. Healthcare and Medical Informatics:
- Hospital Management Information Systems (HMIS) maintain digitized Electronic Health Records (EHR) accessible across specialist departments.
- Advanced diagnostic medical imaging hardware (Magnetic Resonance Imaging/MRI, Computerized Tomography/CT scans, ultrasound machines) relies on computer processors to render 3D anatomical images.
- Computer-assisted robotic surgery allows surgeons to execute microscopic, minimally invasive surgical procedures with sub-millimeter precision.
3. Education, Academia, and E-Learning:
- Learning Management Systems (LMS) such as Moodle and Google Classroom facilitate asynchronous virtual lecture delivery, automated assignment grading, and digital examinations.
- High-fidelity computational simulations allow students in physics, engineering, and aviation to practice flight maneuvers and complex structural stresses without physical danger.
- [6]
Explain any two types of Information System.
View model solution
Two Key Types of Information Systems:
1. Transaction Processing System (TPS):
- Purpose & Focus: Handles and records the routine, daily, high-volume transactions essential to conduct everyday operational business.
- Operational Characteristics: Highly structured, repetitive, operates at the operational/clerical level of the organization, prioritizing data integrity, rapid throughput, and ACID properties (Atomicity, Consistency, Isolation, Durability).
- Practical Examples: Supermarket barcode point-of-sale (POS) checkout counters, airline seat reservation systems, and automated bank teller ledger systems.
2. Decision Support System (DSS):
- Purpose & Focus: Provides analytical modeling tools, data simulations, and interactive capabilities to assist middle and senior executives in making semi-structured and unstructured managerial decisions.
- Operational Characteristics: Integrates internal transactional data from TPS with external market data, offering “What-If” scenario analyses, sensitivity modeling, and multidimensional data visualization.
- Practical Examples: Bank commercial credit scoring systems evaluating loan default risks, and corporate capital expenditure investment evaluation software.
- [6]
List and explain any three networking hardware used in computer network.
View model solution
Three Major Networking Hardware Devices Used in Computer Networks:
1. Router:
- Function: Operates at the Network Layer (Layer 3) of the OSI model, interconnecting distinct, disparate computer networks (such as connecting an enterprise local area network to the global internet).
- Core Mechanism: Inspects incoming data packets’ destination IP addresses and consults dynamic internal routing tables to forward the packet along the fastest and most efficient pathway.
- Additional Roles: Provides Network Address Translation (NAT) and hardware firewall packet filtering.
2. Network Switch:
- Function: Operates primarily at the Data Link Layer (Layer 2) of the OSI model, connecting multiple client devices together within a single Local Area Network (LAN).
- Core Mechanism: Uses hardware Media Access Control (MAC) addresses to intelligently forward incoming data frames strictly to the designated target port, preventing network collision and maximizing internal bandwidth efficiency.
3. Network Interface Card (NIC):
- Function: A dedicated hardware circuit board or chip installed in every computing device, operating at the Physical Layer (Layer 1) and Data Link Layer.
- Core Mechanism: Provides the physical connection interface (RJ-45 Ethernet port or Wi-Fi antenna) and converts digital computer data into electrical or radio signals for physical transmission across network cabling.
- [6]
Illustrate and explain Client-server Architecture.
View model solution
Client-Server Architecture: Illustration and Technical Explanation:
1. Concept and Diagrammatic Architecture
- Client Devices (Laptops, Desktops, Mobiles)
-
- Sends Service Request (HTTP / SQL) via Network ->
-
- Server Node (Database / Web / Application Server)
-
- Processes Request and Returns Response / Data -> Client Devices
-
2. Core Functional Components:
- The Client (Front-End Requester):
- Typically a personal computer, smartphone, or workstation running client-side applications (web browsers, ERP GUI).
- Responsible for presenting user interfaces, accepting user inputs, and transmitting structured service requests to the server.
- The Server (Back-End Provider):
- High-performance, high-capacity centralized computer dedicated to managing shared network resources, running complex business logic, and hosting databases.
- Listens continuously for incoming client connection requests, verifies security credentials, processes computational queries, and returns formatted data.
3. Key Advantages:
- Centralized Data Management: Data backups, user permissions, and updates occur in one central location.
- Scalability: Additional clients can be integrated into the network without interrupting operations.
- Client Devices (Laptops, Desktops, Mobiles)
- [6]
Explain the uses of Multimedia in Business.
View model solution
Uses of Multimedia in Contemporary Business:
Multimedia integrates diverse digital media to enrich commercial communications, operations, and marketing:
- Digital Advertising and Brand Promotion:
- Businesses deploy dynamic video advertisements, animated motion banners, and interactive web graphics across digital channels (YouTube, Instagram) to capture customer attention far more effectively than static text.
- Corporate Employee Training and Onboarding:
- Interactive Computer-Based Training (CBT) modules, instructional video simulations, and Virtual Reality (VR) modules deliver standardized, engaging corporate training while slashing physical coaching expenses.
- Interactive E-Commerce Product Visualization:
- Modern online retail portals incorporate 360-degree interactive product rotators, high-resolution zoomable imagery, and Augmented Reality (AR) previews (e.g., virtually visualizing furniture inside one’s living room before purchase).
- Investor Relations and Executive Presentations:
- Corporate leadership uses multimedia presentations combining voice narration, animated financial charts, and embedded video demos to pitch to venture capitalists and present annual shareholder reports.
- Virtual Customer Support and Video Conferencing:
- Video communication platforms (Zoom, MS Teams) and interactive multimedia chatbots deliver personalized customer care across global time zones.
- Digital Advertising and Brand Promotion:
- [6]
Discuss the importance of Artificial Intelligence.
View model solution
Importance of Artificial Intelligence (AI) in Modern Business:
Artificial Intelligence represents computer systems capable of performing cognitive tasks that historically required human intelligence, such as visual perception, natural language processing, decision-making, and pattern recognition:
- Automation of Repetitive and Complex Cognitive Workflows:
- Robotic Process Automation (RPA) powered by AI automates high-volume business data entry, invoice matching, compliance document parsing, and payroll processing with near-zero error rates.
- Predictive Analytics and Superior Business Intelligence:
- Machine learning algorithms analyze vast datasets to identify non-linear consumer buying trends, predict inventory supply shortages, and forecast market price volatility.
- 24/7 Personalized Customer Engagement:
- Conversational AI agents and natural language processing (NLP) chatbots provide instant, multi-lingual customer support, resolving routine queries without human agent intervention.
- Fraud Detection and Cybersecurity Defense:
- In banking and financial services, AI models monitor millions of credit card transactions in real-time, detecting anomalous fraud patterns and halting compromised transactions instantly.
- Optimized Supply Chain and Logistics Management:
- AI algorithms compute dynamic delivery routes, monitor warehouse inventory levels automatically, and minimize fuel expenditures for logistics carriers.
- Automation of Repetitive and Complex Cognitive Workflows:
Section C
Comprehensive Answer / Case Study Questions.
[2 * 10 = 20]- [10]
Define RAM and explain its types.
View model solution
Comprehensive Analysis of RAM (Random Access Memory) and its Types:
1. Definition and Role of RAM
Random Access Memory (RAM) is the primary internal working memory of a computer system. It directly interfaces with the CPU via the system memory bus to temporarily hold active operating system files, application programs, and intermediate data being processed:
- Random Access: The CPU can access any arbitrary physical memory location in the exact same amount of time, regardless of sequential order.
- Volatile Nature: RAM requires continuous electrical power to maintain its stored data; when the system is powered down, all data in RAM is instantly erased.
2. Major Types of RAM
A. Static RAM (SRAM):
- Internal Mechanism: Constructs each memory bit cell using 4 to 6 transistors configured as a bistable flip-flop latch.
- No Periodic Refreshing Required: Retains stored data indefinitely as long as electrical power is continuously supplied.
- Speed & Power: Extremely fast access times (1 to 10 nanoseconds) and low power consumption during idle states.
- Cost & Density: Physically complex, bulky, and significantly more expensive per megabyte.
- Primary Application: Used almost exclusively in ultra-fast CPU Cache memory (Level 1, Level 2, and Level 3 Cache).
B. Dynamic RAM (DRAM):
- Internal Mechanism: Constructs each memory bit cell using a single transistor paired with a microscopic capacitor.
- Mandatory Periodic Refreshing: The capacitor naturally leaks electrical charge over milliseconds; therefore, the memory controller must periodically recharge (refresh) the capacitor thousands of times per second to prevent data loss.
- Speed & Power: Slower access times (50 to 100 nanoseconds) compared to SRAM and requires active refresh circuitry.
- Cost & Density: Highly compact architecture allowing billions of bits on a single silicon die at a very low cost per gigabyte.
- Primary Application: Serves as the primary system main memory across PCs, laptops, and mobile smartphones.
3. Evolutionary Generations of Synchronous DRAM (SDRAM):
- DDR4 SDRAM: Standard operational frequency (2133 to 3200 MT/s) operating at 1.2 Volts.
- DDR5 SDRAM: Cutting-edge standard offering double the bandwidth (4800 to 8400+ MT/s), higher memory density, and improved power efficiency (1.1 Volts) with on-die Error-Correcting Code (ECC).
- [10]
Define Database management system. Explain the differences between database system and file system.
View model solution
Database Management System (DBMS) vs. Traditional File Processing System:
1. Definition of DBMS
A Database Management System (DBMS) is a comprehensive software suite that facilitates the definition, creation, querying, updating, and systematic administration of structured digital databases (e.g., Oracle, MySQL, Microsoft SQL Server, PostgreSQL).
2. In-Depth Comparative Matrix:
Evaluation Dimension Traditional File Processing System Modern Database Management System (DBMS) 1. Data Redundancy & Inconsistency High data duplication across independent departmental files; updating in one file leads to conflicting versions. Minimizes redundancy through database normalization; changes propagate consistently across the database. 2. Data Isolation & Formatting Data scattered across diverse file formats (txt, csv, dat), making cross-file correlation difficult. Data stored in unified, structured relational tables with standardized relations and data types. 3. Concurrent Access Anomalies Cannot safely manage concurrent multi-user access, resulting in lost updates and overwrites. Sophisticated concurrency control mechanisms (locking protocols, timestamps) ensure transaction isolation. 4. Transactional Integrity (ACID) Lacks native support for atomic transactions; system crashes during write operations corrupt files. Full enforcement of ACID Properties (Atomicity, Consistency, Isolation, Durability). 5. Security and Access Control Rudimentary OS-level file permissions; difficult to restrict access to specific rows or columns. Granular Role-Based Access Control (RBAC), multi-level authentication, and column-level encryption. 6. Querying and Data Retrieval Requires writing custom procedural programs (e.g., C/Java) to extract basic data records. Powerful declarative Structured Query Language (SQL) allows rapid, ad-hoc data querying. 7. Backup and Crash Recovery Manual, cumbersome full-file copy backups; difficult point-in-time recovery. Automated transaction logging and automated point-in-time rollbacks without data loss. - [10]
Write short notes on: Explain the differences between Application Software and System Software.
View model solution
Comparative Analysis: System Software vs. Application Software:
Software represents the intangible set of programs and instructions that direct hardware execution. Software is bifurcated into two primary classifications:
1. Comprehensive Comparative Breakdown:
Parameter System Software Application Software 1. Primary Objective Manages, coordinates, and controls physical computer hardware resources and provides a baseline execution platform. Helps end-users perform specific productive, business, educational, or entertainment tasks. 2. Interaction Level Directly interfaces with underlying hardware microprocessors, buses, memory, and peripherals. Interfaces with the user and relies on the underlying system software to communicate with hardware. 3. Installation & Dependency Installed automatically during OS setup; a computer cannot boot or operate without system software. Installed based on user requirement; computer functions normally even if no applications are installed. 4. Operational Execution Runs continuously in the background from system startup to shutdown. Executed and launched on-demand by the user when specific tasks are required. 5. Programming Language Developed using low-level or systems languages (C, C++, Assembly) for speed and direct memory access. Developed using high-level languages (Python, Java, C#, Swift, JavaScript). 6. Typical Categories - Operating Systems (Windows, Linux, macOS)<br>- Device Drivers (printer, GPU drivers)<br>- Compilers, Linkers, and Assemblers - Office Suites (Word, Excel)<br>- Accounting Software (Tally, Finacle)<br>- Graphic Design (Adobe Photoshop)<br>- Web Browsers (Chrome, Firefox) - [10]
How data can be secured? Explain with example.
View model solution
Comprehensive Framework for Data Security in Organizations:
Data security encompasses the protective digital policies, cryptographic tools, and organizational protocols deployed to safeguard sensitive information against unauthorized access, corruption, exfiltration, and cyberattacks (ensuring the CIA Triad: Confidentiality, Integrity, and Availability):
1. Core Data Security Mechanisms with Practical Examples:
- Cryptographic Data Encryption:
- Data in Transit: Encrypts data traversing external networks using Transport Layer Security (TLS/HTTPS), preventing man-in-the-middle eavesdropping.
- Example: Banking applications encrypting online credit card transactions via 256-bit AES encryption.
- Data at Rest: Encrypting physical hard disks, database storage files, and cloud backups so that even if storage media is stolen, files cannot be read without cryptographic keys.
- Data in Transit: Encrypts data traversing external networks using Transport Layer Security (TLS/HTTPS), preventing man-in-the-middle eavesdropping.
- Multi-Factor Authentication (MFA / 2FA):
- Requires users to verify their identity through two or more independent factors:
- Something you know (password/PIN).
- Something you have (SMS One-Time Password, hardware token key).
- Something you are (biometric fingerprint or facial recognition).
- Requires users to verify their identity through two or more independent factors:
- Role-Based Access Control (RBAC) and Principle of Least Privilege:
- System access rights are partitioned strictly by job responsibility.
- Example: In a hospital database, a billing clerk can view insurance invoices but is barred from opening confidential patient psychiatric medical records.
- System access rights are partitioned strictly by job responsibility.
- Network Firewalls and Intrusion Prevention Systems (IPS):
- Deploys hardware and software firewalls at network boundaries to filter inbound and outbound traffic, blocking unauthorized port scans and distributed denial-of-service (DDoS) attempts.
- Automated Redundant Backups & Disaster Recovery (3-2-1 Rule):
- Maintaining three copies of critical data on two distinct media types, with at least one off-site cloud replica, protecting against catastrophic ransomware attacks and natural disasters.
- Cryptographic Data Encryption:
- [10]
What factors should you consider when purchasing a computer for your organization? Explain.
View model solution
Key Factors to Consider When Purchasing Computers for an Organization:
Procuring computing hardware for an enterprise requires evaluating technical specifications, financial outlays, and long-term business goals:
1. Hardware Performance Specifications:
- Processor (CPU): Selecting processor tier based on employee roles (e.g., multi-core Intel Core i7 / AMD Ryzen 7 for software developers vs. Core i3/i5 for clerical spreadsheet operators).
- RAM Capacity: Minimum 16 GB to ensure smooth multitasking without memory paging bottlenecks.
- Primary Storage (SSD): High-speed NVMe Solid State Drives (SSDs) rather than legacy mechanical HDDs to ensure rapid boot times and quick application loading.
2. Operating System and Software Compatibility:
- Verifying whether target enterprise applications (ERP systems, specialized CAD tools, Core Banking software) run optimally on Windows, macOS, or Enterprise Linux distributions.
3. Total Cost of Ownership (TCO):
- Evaluates capital acquisition costs alongside operating expenses: power consumption, routine maintenance, software licensing, and eventual hardware disposal value.
4. Vendor Warranty, Reliability, and Service Level Agreements (SLAs):
- Securing enterprise commercial warranties offering next-business-day on-site support, guaranteed spare parts availability, and proactive hardware replacement terms to minimize business downtime.
5. Security and Remote Management Features:
- Procuring business-class workstations supporting hardware-level Trusted Platform Module (TPM 2.0) chips for drive encryption, Intel vPro for remote IT administrative troubleshooting, and biometric authentication.
6. Scalability, Form Factor, and Ergonomics:
- Evaluating whether desktop tower units (for easy future component upgrades) or lightweight business laptops (for mobile sales executives) best serve workforce operational needs.
- [10]
Define Operating System. List and explain different functions of OS.
View model solution
Definition and Core Functions of an Operating System (OS):
1. Definition of Operating System
An Operating System (OS) is the fundamental system software that manages physical computer hardware, orchestrates memory and process execution, provides common services for application programs, and acts as an intuitive intermediary between the computer hardware and human users.
2. Core Functions of an Operating System:
- Processor and Process Management:
- Manages CPU allocation among competing concurrent processes using scheduling algorithms (Round Robin, Priority Scheduling, Shortest Job First).
- Handles process creation, execution, synchronization, inter-process communication, and termination.
- Main Memory Management:
- Tracks every byte of physical memory, allocating memory blocks when programs launch and deallocating memory upon program exit.
- Implements Virtual Memory (paging and segmentation) to allow programs larger than physical RAM to execute smoothly.
- File System Management:
- Organizes physical storage into logical hierarchies of files and directories (NTFS, ext4, APFS).
- Manages read/write permissions, access control lists, file creation, deletion, and directory navigation.
- Device (I/O) Management:
- Manages communication with peripheral hardware devices (printers, keyboards, disk drives) using specialized device drivers and I/O buffering.
- Security and Protection:
- Enforces user authentication (passwords, biometrics) and prevents unauthorized processes from reading or altering the memory space of other processes or the operating system kernel.
- User Interface Provision:
- Provides either a Graphical User Interface (GUI) featuring windows, icons, and menus, or a Command Line Interface (CLI) for system administration.
- Processor and Process Management: