IT 231

IT and Applications

TU BBA-F · Semester 1 · BBA-F curriculum (2021 Common Core)

Requirement
required
Credits
3
Past papers
1 papers

Past exam papers

Complete papers are arranged by exam year (AD).

It And Applications 2024 Board Question Paper

Report problem

Tribhuvan University

Faculty of Management

Office of the Dean

2024 AD / Regular Examination

Course: IT 231 · IT and Applications

Level: Bachelor of Business Administration in Finance (BBA-F) · Semester 1

Full Marks: 100

Time: 3 hrs.

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

Section A

Brief Answer Questions.

[10*1=10]
  1. Define word length of a computer.

    [1]
    View model solution

    Word Length of a Computer

    Word length (or word size) is the number of bits that a computer’s Central Processing Unit (CPU) can process, transfer, and address simultaneously in a single operation or cycle (e.g., 32-bit or 64-bit architecture). A larger word length enables faster computing speed and wider direct memory addressing.

  2. Define Register.

    [1]
    View model solution

    Register Definition

    A register is a tiny, extremely high-speed, volatile storage location situated directly inside the CPU used to temporarily hold immediate data, memory addresses, or instructions currently being processed by the arithmetic logic unit (ALU) or control unit (CU).

  3. Mention any one difference between Application and System Software.

    [1]
    View model solution

    Application Software vs. System Software

    • System Software: Low-level software designed to manage, control, and operate computer hardware and provide a base platform for applications (e.g., Operating Systems like Windows/Linux, Device Drivers).
    • Application Software: End-user software designed to perform specific productive or recreational user tasks (e.g., Microsoft Excel, Web Browsers, Accounting software).
  4. List out four networking devices.

    [1]
    View model solution

    Four Essential Networking Devices

    1. Router: Directs data packets across interconnected networks using logical IP routing tables.
    2. Switch: Forwards data frames selectively to specific destination devices within a Local Area Network (LAN) using MAC addresses.
    3. Modem (Modulator-Demodulator): Converts digital signals from a computer into analog signals for transmission over telephone/cable lines and vice versa.
    4. Network Interface Card (NIC): Hardware component providing a physical and data-link connection between a computer and a network medium.
  5. What is IP address?

    [1]
    View model solution

    IP Address

    An Internet Protocol (IP) address is a unique numerical or hexadecimal identifier assigned to every device connected to a computer network that uses the Internet Protocol for communication. It serves two principal functions: host/interface identification and location addressing (e.g., IPv4: 192.168.1.1, IPv6: 2001:0db8:85a3::8a2e:0370:7334).

  6. Define any one Image File Format.

    [1]
    View model solution

    JPEG (Joint Photographic Experts Group) Image File Format

    JPEG (.jpg / .jpeg) is a widely used lossy compression image file format designed primarily for color photographic images. It significantly reduces file size by discarding visual data imperceptible to the human eye, making it the universal standard for digital web graphics and photography.

  7. What is data model?

    [1]
    View model solution

    Data Model

    A data model is an abstract conceptual framework that defines how data elements are structured, stored, related, and manipulated within a database management system (e.g., Relational Model, Entity-Relationship Model, Hierarchical Model, NoSQL Document Model).

  8. What is Spyware?

    [1]
    View model solution

    Spyware

    Spyware is malicious software (malware) covertly installed on a computing device without the user’s informed consent that tracks user behavior, logs keystrokes (keylogging), captures credentials, and transmits private data to unauthorized third parties.

  9. Define Data Analytics.

    [1]
    View model solution

    Data Analytics

    Data Analytics is the systematic computational process of inspecting, cleaning, transforming, and modeling raw data to discover hidden patterns, extract meaningful correlations, draw inferences, and support data-driven managerial decision-making.

  10. Define cache hit.

    [1]
    View model solution

    Cache Hit

    A cache hit occurs when the CPU requests a piece of data or instruction and finds it immediately available in the fast cache memory (L1L_1, L2L_2, or L3L_3), avoiding high-latency retrieval from the slower main memory (RAM).

Section B

Short Answer Questions: (Attempt any FIVE Questions)

[5*3=15]
  1. How Information Technology have transformed business? Explain with example.

    [3]
    View model solution

    How Information Technology Transforms Business (with Example)

    Information Technology (IT) has radically re-engineered business paradigms across operations, marketing, supply chains, and customer relationship management:

    1. Automation and Operational Velocity: Eliminates manual paperwork, reduces human error, and accelerates processing speeds across payroll, inventory, and accounting through Enterprise Resource Planning (ERP) systems.
    2. Global Market Access & E-Commerce: Overcomes geographical barriers, allowing businesses to operate 24/724/7 and serve international markets at negligible marginal distribution costs.
    3. Data-Driven Strategic Intelligence: Leverages real-time data analytics and Customer Relationship Management (CRM) tools to personalize product recommendations and forecast demand.
    • Real-World Example:
      • Retail Banking in Nepal: The adoption of Mobile Banking and QR payment gateways (e.g., Fonepay, connectIPS) transformed retail banking from physical brick-and-mortar queues into instantaneous digital self-service, reducing branch overhead costs and democratizing financial access nationwide.
  2. Explain any two types of computer.

    [3]
    View model solution

    Two Major Types of Computers

    1. Supercomputers:
      • The most powerful, high-performance computing systems designed to execute trillions of floating-point operations per second (FLOPS).
      • Applications: Complex mathematical simulations, climate modeling, nuclear research, molecular genetics, and quantum physics (e.g., Frontier, Fugaku).
    2. Mainframe Computers:
      • Large-scale, ultra-reliable enterprise computers designed for high-volume concurrent input/output processing and massive transaction throughput.
      • Applications: Mission-critical enterprise processing, such as national census computation, airline reservation backbones, and inter-bank clearing systems (e.g., IBM zSeries).
  3. Explain about any two types of output device.

    [3]
    View model solution

    Two Major Types of Output Devices

    1. Visual Display Monitors (Soft-Copy Output):
      • Provide immediate visual output by displaying processed text, graphics, video, and user interfaces on a screen using technologies such as LED, LCD, or OLED.
      • Enables interactive real-time user-computer collaboration.
    2. Printers (Hard-Copy Output):
      • Produce permanent tangible physical copies of digital documents and graphics on paper.
      • Types: Impact printers (e.g., Dot Matrix for multipart billing receipts) and Non-impact printers (e.g., Laser printers for high-speed crisp office text and Inkjet printers for high-resolution graphics).
  4. Discuss the Importance of search engine.

    [3]
    View model solution

    Importance of Search Engines in Modern Business and Society

    A search engine (e.g., Google, Bing) is a web-based software tool that searches database indices of web pages to retrieve relevant information based on user queries:

    1. Instantaneous Information Access: Empowers students, researchers, and professionals to locate academic literature, market reports, and competitive intelligence within milliseconds.
    2. Digital Marketing & Customer Discovery: Search Engine Optimization (SEO) and Search Engine Marketing (SEM) enable businesses to attract high-intent customers at the exact moment they search for a product or service.
    3. E-Commerce and Product Comparison: Facilitates market transparency by allowing consumers to compare product specifications, prices, and customer reviews across global suppliers.
  5. Explain any three application area of multimedia.

    [3]
    View model solution

    Three Key Application Areas of Multimedia

    1. Education and E-Learning:
      • Interactive virtual classrooms, computer-based training (CBT), interactive tutorials, and educational simulations that combine video, animation, and audio to enhance student retention.
    2. Entertainment and Media:
      • High-definition video streaming (Netflix, YouTube), video game development, visual special effects (CGI) in film, and digital music production.
    3. Corporate Advertising and Marketing:
      • Interactive digital advertisements, product launch animated demonstrations, commercial kiosks, and engaging social media multimedia campaigns that drive brand engagement.
  6. Discuss the importance of Data warehousing in decision making.

    [3]
    View model solution

    Importance of Data Warehousing in Managerial Decision-Making

    A Data Warehouse is a centralized, subject-oriented, integrated, time-variant, and non-volatile repository of structured data extracted from multiple disparate operational databases:

    1. Integrated Historical Perspective: Consolidates sales, inventory, and financial records across decades, allowing executive managers to identify multi-year longitudinal market trends.
    2. Separation of Analytics from Operational OLTP: Analytical queries do not degrade the performance of daily transaction-processing systems (OLTP).
    3. Enhanced Data Quality and Consistency: Pre-cleanses, standardizes, and reconciles inconsistent data from different branch systems before loading, providing a single version of the truth for Business Intelligence (BI) dashboards.

Section C

Long Answer Questions: (Attempt any THREE Questions)

[3*5=15]
  1. Define network topology. Explain any four types of network topology.

    [5]
    View model solution

    Network Topology and Four Major Topologies


    1. Definition of Network Topology

    Network topology defines the physical or logical geometric layout and arrangement in which computers, networking devices, and communication cables are interconnected within a network.


    2. Four Major Types of Network Topology

    1. Star Topology:

      • All network nodes are connected independently through dedicated point-to-point cables to a central device (Hub or Switch).
      • Advantage: Failure of one node or cable does not disrupt the rest of the network; easy to troubleshoot and scale.
      • Disadvantage: If the central switch fails, the entire network collapses.
    2. Bus Topology:

      • All workstations share and connect sequentially to a single central linear transmission cable called the backbone, with terminators at both ends.
      • Advantage: Minimal cable required; low installation cost.
      • Disadvantage: A break in the main backbone disables the whole network; high data collision under heavy traffic.
    3. Ring Topology:

      • Each device is connected to exactly two neighboring devices, forming a continuous circular data path where tokens travel in a single direction.
      • Advantage: Orderly network traffic with no packet collisions due to token passing.
      • Disadvantage: Failure of a single workstation or intermediate cable breaks the loop and halts network communication.
    4. Mesh Topology:

      • Every device has a dedicated point-to-point physical connection to every other device in the network (n(n1)/2n(n-1)/2 connections for nn nodes).
      • Advantage: Maximum fault tolerance, absolute redundancy, and dedicated privacy.
      • Disadvantage: Extremely expensive to install and complex to cable.
  2. Explain any five advantages of Database System over File System.

    [5]
    View model solution

    Five Key Advantages of a Database System (DBMS) Over Traditional File Systems

    1. Minimization of Data Redundancy and Inconsistency:
      • In file systems, different departments maintain duplicate files (e.g., student address stored in both billing and library files), leading to conflicting updates. DBMS stores data centrally, eliminating unauthorized duplicate entries.
    2. Data Independence (Separation of Data and Programs):
      • File processing tightly couples file structures to application code. In a DBMS, structural database modifications (e.g., adding a table column) do not require rewriting application programs.
    3. Enforcement of Data Integrity and Business Constraints:
      • DBMS enables administrators to declare integrity constraints (e.g., primary keys, foreign key referential integrity, NOT NULL constraints) that the database engine validates automatically.
    4. Data Security and Granular Access Control:
      • File systems offer blunt file-level access. DBMS enforces granular view-level permissions (e.g., a cashier views only customer account balances, while the credit manager views loan approvals).
    5. Robust Concurrency Control and Transaction Recovery (ACID Properties):
      • Traditional files risk data corruption when multiple users write concurrently. DBMS implements locking mechanisms and transaction logging that guarantee Atomicity, Consistency, Isolation, and Durability (ACID).
  3. Explain any five functions of operating system.

    [5]
    View model solution

    Five Primary Functions of an Operating System (OS)

    The Operating System acts as the core system software intermediary between computer hardware and end-user application programs:

    1. Process Management (Processor Scheduling):
      • Manages concurrent task execution, allocates CPU clock time across running processes using scheduling algorithms (e.g., Round Robin, Priority Scheduling), and handles process synchronization and deadlock prevention.
    2. Memory Management:
      • Dynamically tracks, allocates, and deallocates primary memory (RAM) to active applications. Implements Virtual Memory techniques (paging and segmentation) to allow execution of processes larger than physical RAM.
    3. File System Management:
      • Organizes digital information into hierarchical files and directories. Controls file creation, deletion, renaming, access permissions, and disk storage allocation (e.g., NTFS, FAT32, ext4).
    4. Device (I/O) Management:
      • Coordinates communication between the CPU and diverse peripheral hardware (keyboards, printers, disk drives) using device drivers and input/output buffering.
    5. Security and User Authentication:
      • Protects system resources against unauthorized intrusion through user authentication (passwords, biometrics), access control lists (ACLs), and firewall logging.