Information and Communication Technology

In MS-Excel 2007, STDEV[numberl, number 2, …] is a statistical function that

[amp_mcq option1=”estimates standard deviation based on a sample by ignoring logical values and text in the sample” option2=”estimates standard deviation based on a sample by including logical values and text in the sample” option3=”calculates standard deviation based on the entire population by ignoring logical values and text” option4=”calculates standard deviation based on the entire population by including logical values and text” correct=”option1″]

The correct option is A.

In MS-Excel 2007 (and later versions with STDEV.S), the STDEV function (or STDEV.S) calculates the standard deviation based on a *sample*. It measures the dispersion or spread of data points around the mean. Importantly, the standard STDEV function in Excel ignores logical values (TRUE/FALSE) and text within the range of numbers provided as arguments when calculating the standard deviation.

Excel has other standard deviation functions: STDEVP (STDEV.P) for calculating the standard deviation of an *entire population*, which also ignores text and logical values; STDEVA for sample standard deviation that *includes* text (counted as 0) and logical values; and STDEVPA for population standard deviation that *includes* text and logical values. The question specifically asks about `STDEV`.

In MS-Excel 2007, NPV(rate, value1, [value 2], …) is a financial function that returns

[amp_mcq option1=”the net present value of an investment based on discount rate and series of future payments and income” option2=”the number of periods for an investment based on periodic, constant payments and constant interest rate” option3=”the future value of an investment based on periodic, constant payments and constant interest rate” option4=”the future value of an initial principal after applying a series of compound interest rates” correct=”option1″]

The correct option is A.

In MS-Excel, the NPV (Net Present Value) function calculates the present value of a series of cash flows based on a specified discount rate. It is used to evaluate the profitability of an investment or project by bringing all future cash flows (both positive and negative) back to their present-day value. Option A accurately describes this function: “the net present value of an investment based on discount rate and series of future payments and income”.

The NPV function assumes that cash flows occur at the end of each period. If cash flows occur at the beginning of the period, the NPV calculation needs adjustment, often by using the XNPV function for uneven dates or a combination of NPV and the initial investment outside the function.

Which one of the following communication media uses light pulses for carrying information?

[amp_mcq option1=”Coaxial cable” option2=”Optic fibre” option3=”Microwave” option4=”Satellite” correct=”option2″]

The correct option is B.

Communication media carry information in various forms. Coaxial cables use electrical signals transmitted through copper wires. Microwave and satellite communication use electromagnetic waves (radio waves) transmitted through the air or space. Optic fibre cables, however, use light pulses transmitted through thin strands of glass or plastic. This method allows for very high bandwidth and long-distance transmission with minimal signal loss.

Optical fibre communication has revolutionized telecommunications and data networking due to its speed, capacity, and immunity to electromagnetic interference compared to traditional copper-based media.

In the context of computer graphics, which one of the following is not a raster image format?

[amp_mcq option1=”JPEG” option2=”TIFF” option3=”SVG” option4=”GIF” correct=”option3″]

The correct option is C.

Raster image formats represent images as a grid of pixels (Picture Elements), where each pixel has a color value. Examples include JPEG, TIFF, GIF, PNG, and BMP. Vector image formats, however, represent images using mathematical equations to define lines, curves, and shapes. They are resolution-independent and can be scaled without loss of quality. SVG (Scalable Vector Graphics) is a prominent example of a vector image format.

Raster images are suitable for photographs and complex images with gradients and subtle color variations but can become pixelated when scaled up significantly. Vector images are ideal for logos, illustrations, and graphics that require scalability, such as for printing at different sizes.

In the context of computer networks, which one of the following is not an application layer protocol?

[amp_mcq option1=”SMTP” option2=”FTP” option3=”HTTP” option4=”TCP” correct=”option4″]

The correct option is D.

In the context of computer networks using the TCP/IP model, the Application Layer is the highest layer, which interacts directly with software applications. Protocols at this layer provide specific services to applications. SMTP (Simple Mail Transfer Protocol), FTP (File Transfer Protocol), and HTTP (Hypertext Transfer Protocol) are all well-known application layer protocols used for email, file transfer, and web browsing, respectively. TCP (Transmission Control Protocol), on the other hand, is a Transport Layer protocol. It provides reliable, connection-oriented data transmission services to the application layer, ensuring data integrity and flow control.

The TCP/IP model consists of four layers: Network Interface Layer, Internet Layer, Transport Layer, and Application Layer. The Transport Layer is responsible for end-to-end data transfer between processes. Other common Transport Layer protocols include UDP (User Datagram Protocol).

Who has coined the term ‘global village’?

[amp_mcq option1=”Hans J. Morgenthau” option2=”E. H. Carr” option3=”Marshall McLuhan” option4=”Richard Falk” correct=”option3″]

Marshall McLuhan coined the term ‘global village’.

– Marshall McLuhan (1911-1980) was a Canadian philosopher of communication theory.
– He used the term ‘global village’ to describe how the electronic mass media collapse space and time barriers, allowing people to interact and perceive the world on a global scale as if it were a small village.

Other options are associated with different fields: Hans J. Morgenthau and E. H. Carr are prominent figures in the field of International Relations (Realism), and Richard Falk is a scholar of international law and international relations.

Consider the following statements about the cache memory:

• It is a non-volatile memory.
• It is a slow-read and inexpensive memory.
• It is a fast-read and expensive memory.
• It is a small-sized memory.

Which of the above statements are correct?
Select the correct answer using the codes given below:

[amp_mcq option1=”1 and 2 only” option2=”3 and 4 only” option3=”1 and 3 only” option4=”1, 3 and 4 only” correct=”option2″]

The correct answer is (B) 3 and 4 only. Cache memory is known for being very fast, expensive per unit of storage, and small in size compared to main memory (RAM). It is typically implemented using SRAM (Static Random-Access Memory), which is volatile.

– Statement 1: It is a non-volatile memory. This is incorrect. Cache memory is usually made of SRAM, which is volatile; it loses its contents when power is removed. Non-volatile memory includes ROM, Flash, SSDs, etc.
– Statement 2: It is a slow-read and inexpensive memory. This is incorrect. Cache is designed for fast access (fast-read) and is more expensive than main memory or secondary storage.
– Statement 3: It is a fast-read and expensive memory. This is correct. Cache memory is located closer to the CPU and is significantly faster than main RAM. This speed comes at a higher cost per bit.
– Statement 4: It is a small-sized memory. This is correct. Cache memory is much smaller than main memory due to its high cost and the need for speed (smaller size allows faster access).

Cache memory acts as a high-speed buffer between the CPU and main memory (RAM) to reduce memory access time. It stores frequently used data and instructions so that the CPU can retrieve them much faster than fetching them from RAM. There are typically multiple levels of cache (L1, L2, L3), with L1 being the smallest and fastest, and L3 being the largest and slowest among the cache levels, but still faster than RAM.

Compiler, Interpreter and Assembler are

[amp_mcq option1=”System software” option2=”Hardware” option3=”Application software” option4=”None of the above” correct=”option1″]

The correct answer is (A) System software. Compilers, Interpreters, and Assemblers are programs that are part of the system software stack. They are essential tools used to translate programming code into machine-readable instructions, which are required for the computer hardware to execute programs.

– System software is software that manages and controls computer hardware and provides a platform for running application software. Examples include operating systems, device drivers, utilities, and language processors like compilers and interpreters.
– Compilers translate source code written in a high-level programming language into machine code or an intermediate code all at once before execution.
– Interpreters translate and execute source code line by line.
– Assemblers translate assembly language code into machine code.

– (B) Hardware refers to the physical components of a computer system.
– (C) Application software consists of programs designed for end-users to perform specific tasks, such as word processing (MS-Word), browsing the web (Chrome), or playing games.

In computer security, which one of the following means that the information in a computer system can only be accessed by authenticated parties ?

[amp_mcq option1=”Confidentiality” option2=”Integrity” option3=”Availability” option4=”Reliability” correct=”option1″]

The correct answer is (A) Confidentiality. Confidentiality in computer security ensures that information is accessible only to those individuals or systems that have been authorized to access it. This is typically achieved through authentication and authorization mechanisms.

– Confidentiality is one of the core principles of the CIA triad (Confidentiality, Integrity, Availability), which are fundamental goals of computer security.
– Authentication verifies the identity of a user or system, while authorization determines what authenticated users are allowed to do.
– Measures like encryption, access controls, and strong authentication are used to maintain confidentiality.

– (B) Integrity ensures that data is accurate, complete, and has not been tampered with or modified in an unauthorized way.
– (C) Availability ensures that systems, services, and data are accessible to authorized users when needed.
– (D) Reliability refers to the ability of a system to perform its intended function correctly and consistently over time. While related to availability and integrity, it is not the primary term for restricting access to authenticated parties.

Which one of the following is *not* a database management software ?

[amp_mcq option1=”Oracle” option2=”MySQL” option3=”MS-Access” option4=”MS-Word” correct=”option4″]

The correct answer is (D) MS-Word. MS-Word is a word processing software used for creating and editing text documents. It is not designed for managing structured databases.

– A Database Management System (DBMS) is a software system used for creating, managing, and interacting with databases.
– DBMS software allows users to store, organize, retrieve, and manipulate large amounts of data efficiently.

– (A) Oracle is a powerful, widely used commercial relational database management system.
– (B) MySQL is a popular open-source relational database management system.
– (C) MS-Access is a database management system included in the Microsoft Office suite, suitable for smaller databases.
– These three options are indeed examples of database management software.