Computer - II : Previous Year Questions (2024)

PART – A

Q1. Why files are kept in directories?

Ans. Files are kept in directories (folders) to organize and manage data systematically, making it easier to locate, retrieve, and store information while preventing clutter and naming conflicts.

Q2. What is Adobe PageMaker?

Ans. Adobe PageMaker 7.0 is a sophisticated page layout software used to design and produce documents for printing. It is versatile enough to create anything from a simple business card to a complex, multi-page book. It allows users to:

• Position text and graphics with precision.
• Create professional newsletters, brochures, and reports.
• Integrate elements from other software (like MS Word or Excel) into a single layout.

Q3. What is Excel?

Ans. Microsoft Excel is a spreadsheet application for creating tables to store, organize, and analyse numerical and statistical data using formulas and functions. It features a grid of cells organized in rows and columns, where data can be entered and manipulated to perform calculations, create charts, and visualize information.

Q4. How do you edit a cell in Excel?

Ans. Editing a cell means changing the data or formula inside it.

Steps to edit a cell include: -

1. Double-click on the cell you want to edit. The cell becomes active, and the cursor appears inside.
2. Make your changes.
3. Press Enter to confirm or Esc to cancel.

Alternatively,

1. Click once on the cell to select it.
2. Click in the Formula Bar (above the worksheet, next to the Name Box).
3. Edit the content.
4. Press Enter to save the changes.

Q5. What is RDBMS?

Ans. A Relational Database Management System (RDBMS) is a database type that stores data in tables so it can be used in relation to other datasets. Most business databases today are relational rather than flat-file or hierarchical. In an RDBMS, tables are often referred to as "relations". Data is organized into horizontal records (rows) and vertical fields (columns). RDBMS systems are capable of handling massive amounts of data and complex queries.

Q6. Define Multimedia.

Ans. The term Multimedia is a linguistic blend of two words: "Multi," meaning many, and "Media," referring to the material or medium through which information is transmitted or sent. It is defined as the integration of various media elements, such as text, graphics, audio, and video, to present information in a more effective, engaging, and attractive manner.

Q7. What do you mean by Thesaurus?

Ans. Thesaurus is a built-in tool used to find synonyms (words with similar meanings) and antonyms (words with opposite meanings) for a selected word.

Q8. What is an IP address?

Ans. An Internet Protocol address (IP address) is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication.

Q9. What is Router?

Ans. Routers are networking devices operating at layer 3 or a network layer of the OSI model. They are responsible for receiving, analysing, and forwarding data packets among the connected computer networks. When a data packet arrives, the router inspects the destination address, consults its routing tables to decide the optimal route and then transfers the packet along this route.

Q10. Can reports in DBMS be customized?

Ans. Yes, reports in a Database Management System (DBMS) can be customized.

Users can tailor reports by selecting specific fields, applying filters to show only relevant data, sorting records, and modifying the visual layout (such as adding headers, footers, logos, or charts) to suit their specific needs.

PART – B

Q11. Write syntax of DIR, DEL, REN, and MD commands in DOS.

Ans. Internal commands are built directly into the Command Interpreter (COMMAND.COM). They are loaded into RAM when the system boots and do not require external files to run.

Syntax for the given commands:

1. DIR [drive:][path]
2. DEL [filename]
3. REN [oldname] [newname]
4. MD [directory_name]

Q12. Explain the types of functions in MS Excel.

Ans. In MS Excel, a function is a predefined formula that performs a specific calculation or operation using arguments (inputs) and returns a single output value. Excel offers a vast library of functions categorized by type, such as mathematical, statistical, logical, and text functions, to help automate complex calculations and data manipulation. 

Types of functions in MS Excel:

MS Excel provides a variety of functions. Some relevant categories of functions include: -

1. Text Functions –

• UPPER() – Converts text to uppercase (e.g., case names).
• LOWER() – Converts text to lowercase.
• PROPER() – Capitalizes the first letter of each word.
• CONCAT() or TEXTJOIN() – Combine text from multiple cells.
• LEFT(), RIGHT(), MID() – Extract parts of text (e.g., dates or codes).
• LEN() – Counts characters in a text.
• TRIM() – Removes extra spaces.

2. Date and Time Functions –

• TODAY() – Returns current date (auto-updated).
• NOW() – Returns current date and time.
• DATEDIF() – Calculates difference between two dates (e.g., days until a deadline).
• DAY(), MONTH(), YEAR() – Extracts parts of a date.

3. Lookup and Reference Functions –

• VLOOKUP() – Searches for a value in a table vertically.
• HLOOKUP() – Searches horizontally.
• XLOOKUP() – A modern and flexible lookup tool.
• INDEX() – Returns a value at a given position.
• MATCH() – Finds the position of an item in a range.

4. Mathematical Functions –

• SUM() – Adds numbers.
• AVERAGE() – Finds the mean.
• COUNT() – Counts numeric entries.
• COUNTA() – Counts all non-empty entries.
• ROUND() – Rounds numbers.

5. Logical Functions –

• IF() – Returns values based on a condition.
• AND() / OR() – Combines multiple conditions.
• NOT() – Reverses a logical value.
• IFERROR() – Handles errors in formulas.

6. Information Functions –

• ISBLANK() – Checks if a cell is empty.
• ISNUMBER() – Checks if the value is a number.
• ISTEXT() – Checks if the value is text.

Q13. Write modes of Data Communication.

Ans. A Data Communication System is the collection of hardware and software designed to transfer information from one location to another. For communication to occur, the entities must be part of a communication system made up of a specific set of components.

Modes of Data Communication

Transmission mode (also known as data communication mode) refers to the direction of signal flow between two linked devices. There are three primary modes:

A. Simplex Mode

In Simplex mode, the communication is unidirectional, like a one-way street. Only one of the two devices on a link can transmit; the other can only receive.

Example: A keyboard (can only introduce input) and a traditional monitor (can only accept output).

B. Half-Duplex Mode

In Half-Duplex mode, each station can both transmit and receive, but not at the same time. When one device is sending, the other can only receive, and vice versa. It is like a one-lane bridge where traffic can go in both directions, but only one way at a time.

Example: A Walkie-talkie. One person must finish speaking and say "over" before the other can respond.

C. Full-Duplex Mode

In Full-Duplex mode (or simply duplex), both stations can transmit and receive simultaneously. Signals going in one direction share the capacity of the link with signals going in the other direction. This is like a two-way street where traffic flows in both directions at the same time.

Example: A telephone network. Both parties can talk and hear each other at the same time.

Q14. Write methods for creating table in Database.

Ans. MS Access offers several ways to initiate a new table:

1. Datasheet View: Create a table by directly entering data into a blank grid.
2. Design View: Allows for detailed definition of field names, data types, and descriptions before entering data.
3. Table Wizard: A guided process for table creation.
4. Import/Link Table: Create a table by bringing in data from external sources like Excel, XML files, or other Access databases.
   • Importing: Creates a local copy of the data; changes to the source do not affect the Access table.
   • Linking: Creates a live link; changes in either the source or the Access table are reflected in both.

PART – C

Q15. Explain components and application of Multimedia.

Ans. The term Multimedia is a linguistic blend of two words: "Multi," meaning many, and "Media," referring to the material or medium through which information is transmitted or sent. It is defined as the integration of various media elements, such as text, graphics, audio, and video, to present information in a more effective, engaging, and attractive manner.

Components of Multimedia

Multimedia is comprised of five primary elements that work in synergy to represent data:

1. Text

The most common medium for representing information It is primarily utilised for titles, headlines, and navigation menus.

Common extensions include .DOC and .TXT.

Software: Microsoft Word, Notepad, and WordPad.

2. Audio

Encompasses speech and music to increase the "understandability" and clarity of concepts. The MP3 format is the industry standard for storing compressed sound and music.

Software: QuickTime, RealPlayer, and Windows Media Player.

3. Graphics

The foundation of every multimedia presentation, making concepts more presentable and professional. Often viewed via Windows Picture viewer or web browsers like Internet Explorer.

Software: Adobe Photoshop is a leading tool for editing graphics to make them more attractive.

4. Video

A combination of moving pictures with synchronized sound. It is considered the most effective way to communicate, as it saves time and enhances presentation. The MPEG (Moving Pictures Experts Group) format is widely used for video files.

5. Animation

The process of altering images in a sequence so they appear as moving pictures to the human eye. It shows a specific number of frames per second to produce the effect of motion.

Applications of Multimedia

Nowadays the applications of Multimedia are observed in various fields such as Education, Entertainment, Business and so on. To communicate the message in the form of picture, sound, video, animation is the primary role of multimedia. Some of the application of multimedia are as follows:

1. Business and Engineering

1. Videoconferencing: Enables real-time audio and video communication between distant locations, saving time and money.
2. Marketing: Used to create dynamic advertisements on television and the internet.
3. Engineering: Tools are used for designing and testing new products and components.

2. Entertainment

1. Movies: Multimedia enables special effects and high-action sequences that were previously impossible.
2. Gaming: Provides immersive experiences through 3-D effects and high-quality sound.

3. Education and "Edutainment"

1. Edutainment: A hybrid of education and entertainment that makes learning engaging for students.
2. Interactive Multimedia: Applications that allow users to actively participate rather than being passive recipients of information.

Multimedia in Foreign Language Learning

Multimedia creates a rich, interactive environment that simulates real-life language use, through features like native speaker conversations, visual context, and interactive exercises, ultimately enhancing comprehension, pronunciation, and fluency. It addresses all four core skills: listening, speaking, reading, and writing.

Key Benefits in Language Acquisition

1. Natural Exposure: Podcasts and online news provide exposure to native accents and colloquialisms.
2. Visual Context: Images and videos provide cues that help learners understand new vocabulary and cultural nuances.
3. Pronunciation Mastery: Audio clips allow learners to mimic native speakers, while speech recognition software provides instant feedback.
4. Adaptive Learning: Digital tools allow students to adjust the pace and difficulty level to suit their individual needs.

Essential Tools

1. Language Apps: Feature gamified elements and flashcards.
2. VR/AR: Immersive environments for practicing speaking in simulated real-world scenarios.
3. Exchange Platforms: Video call services that connect learners directly with native speakers globally.

Q16. Write features of Unix Operating System.

Ans. UNIX is a powerful, multi-user, and multi-tasking operating system that has served as the blueprint for much of modern computing (including Linux and macOS).

Features of UNIX operating system:

1. Multi-user and Multi-tasking - UNIX allows multiple users to access system resources simultaneously while keeping their data and processes isolated. Furthermore, it supports multi-tasking, meaning a single user can run several programs at once in the background while continuing to work in the foreground.

2. Hierarchical File System - UNIX organizes data in a logical, tree-like structure. It starts at a single point called the root (represented by /), and everything from documents to hardware devices, is treated as a file within this hierarchy. This consistency makes it much easier for the system to manage diverse types of data.

3. The Kernel and the Shell - The system is split into two primary layers. Kernel is the "brain" of the OS that interacts directly with the hardware to manage memory, files, and CPU time.

And Shell is The command-line interface that acts as an intermediary between the user and the kernel. It interprets your commands and passes them to the system to be executed.

4. Portability - Unlike many early operating systems written in assembly language for specific machines, UNIX was rewritten in the C programming language. This makes it highly portable, allowing it to be moved (ported) to different hardware architectures with minimal changes to the code.

5. Pipes and Filters - UNIX encourages a "modular" approach to computing. Using pipes (represented by the | symbol), users can take the output of one small, specialized program and feed it directly as input into another. This allows users to build complex tools out of simple, reliable building blocks.

Q17. Write methods for creating charts in MS-Excel.

Ans. Charts in Microsoft Excel are visual tools that turn numerical data into easy-to-understand graphics. They help users quickly spot patterns, compare values, and track changes over time without reading long tables. Excel offers different chart types, such as column, line, pie, and bar charts, so data can be presented in the most suitable way. Using charts makes data analysis clearer, faster, and more effective.

Components of a Chart:

Components of a chart include: -

1. Chart Area –

• Chart Title: Gives the chart a name, describing the overall topic.
• Plot Area: The rectangular region within the chart that contains the actual data points.

2. Axes and Labels –

• X-axis (Category Axis): The horizontal axis, typically displaying categories of data.
• Y-axis (Value Axis): The vertical axis, showing numerical values.
• Axis Titles: Text that explains what each axis represents.
• Data Labels: Provide additional information, like the exact value, for a data marker.

3. Data Visualisation –

• Data Series: A set of related values that are plotted on the chart, such as all the bars or lines for one category.
• Data Markers: The individual symbols on the chart that represent a single data value (e.g., a bar, dot, or slice of a pie).

4. Supporting Elements –

• Legend: Identifies the colours or patterns used to represent different data series.
• Gridlines: Horizontal or vertical lines extending across the plot area, making it easier to read values.
• Trendlines: Lines added to a chart to show a trend in the data, such as a moving average.

Types of a Chart:

Various types of charts in MS Excel include: -

1. Column Chart - Column charts are used when you want to compare different values vertically side-by-side. Each value is represented in the chart by a vertical bar. If there are several series, each series is represented by a different colour.
2. Line Chart - Line charts are used to illustrate trends over time. Each value is plotted as a point on the chart and is connected to other values by a line. Multiple items are plotted using different lines.
3. Pie Chart - Pie charts are useful for showing values as a percentage of a whole. The values for each item are represented by different colours. Limit pie charts to eight sections.
4. Bar Chart - Bar charts are just like column charts, except they display information in horizontal bars rather than in vertical columns.
5. Area Chart - Area charts are the same as line charts, except the area beneath the lines is filled with colour.
6. XY (Scatter) Chart - Scatter charts are used to plot clusters of values using single points. Multiple items can be plotted by using different coloured points or different point symbols.
7. Stock Chart - Stock charts are effective for reporting the fluctuation of stock prices, such as the high, low, and closing points for a certain day.
8. Surface Chart - A surface chart is useful for finding optimum combinations between two sets of data. Colours and patterns indicate values that are in the same range.
9. Doughnut Chart - A doughnut chart shows the relationship of parts to a whole, but it can contain more than one data series.
10. Bubble Chart - Bubble charts are similar to XY Scatter charts, but they compare three sets of values instead of two, with the third set determining the size of the bubble.
11. Radar Chart - Radar charts compare the aggregate values of a number of data series.

Creating Charts:

Method 1: Using the "Insert" Tab (Standard Method)

1. Select the Data: Highlight the range of cells containing the data you want to graph (including column and row headers).
2. Navigate to Insert: Click on the Insert tab in the Ribbon.
3. Choose Chart Type: In the Charts group, select a category (e.g., Column, Line, Pie, Bar).
4. Insert: Click the specific sub-type (e.g., 2D Clustered Column) to place the chart on your worksheet.

Method 2: Using "Recommended Charts"

Excel has a built-in feature that analyses your data and suggests the most effective chart type for that specific dataset.

1. Select your data range.
2. Go to the Insert tab and click Recommended Charts.
3. A dialog box will appear showing various previews. Select the one that represents your data most clearly and click OK.

Method 3: Using the Quick Analysis Tool

Excel provides a floating tool for instant visualization.

1. Select your data range.
2. A small icon called the Quick Analysis tool will appear at the bottom-right corner of your selection.
3. Click the icon and navigate to the Charts tab.
4. Hover over the options to see a live preview and click one to insert it.

Method 4: Using Keyboard Shortcuts

If you need a basic chart instantly, Excel offers two primary shortcuts:

1. Alt + F1: This creates an Embedded Chart (a chart object on the same worksheet as your data).
2. F11: This creates a Chart Sheet (a new, separate tab in your workbook dedicated solely to the chart).

Q18. Explain LAN, WAN and MAN.

Ans. LAN, MAN, WAN refers to various types of computer network. Computer networks are categorized based on their geographical scale and the number of devices they connect.

1. LAN (Local Area Network)

A LAN is a network that connects computers and devices in a limited geographical area, such as a single room, a home, an office building, or a school campus.

• Ownership: Usually privately owned by an individual or a single organization.
• Speed: Offers the highest data transfer speeds (ranging from 100 Mbps to 10 Gbps).
• Media: Typically uses Ethernet cables (twisted pair) or Wi-Fi.
• Error Rate: Very low, as the distance the data travels is short.

2. MAN (Metropolitan Area Network)

A MAN is a larger network that usually spans an entire city or a large campus. It serves as an interconnection of several LANs within a metropolitan area.

• Ownership: Can be owned by a single large organization (like a government body) or a public utility provider.
• Speed: Moderate to high speed, though generally slower than a LAN but faster than a WAN.
• Media: Often uses high-speed fiber optic cables to connect different parts of a city.
• Example: A city-wide cable TV network or a network connecting several branches of a local bank.

3. WAN (Wide Area Network)

A WAN covers a very large geographical area, such as a country, a continent, or even the whole world. It is a collection of LANs and MANs connected together.

• Ownership: Usually not owned by any single organization; it is a collective of many service providers.
• Speed: Slower than LAN and MAN due to the immense distances and varied technologies involved.
• Media: Uses long-distance transmission media like satellites, microwave links, and undersea fiber optic cables.
• Example: The Internet is the most prominent example of a WAN.