Information and Communication Technology MCQ

121. What functionality does the ruler in a word processor provide?

Correct Answer: Correct answer is: (D) Creates boundaries or margins inside which you add the contents (words, images, etc.) of your document.

Exam Relevance: SAT, ACT, GED

Difficulty: Moderate

Concept notes: The ruler in a word processor is a tool that helps define the layout of the document by setting margins and tab stops.

Common Mistakes: Students may confuse the ruler's function with measuring the width of a table or showing the cursor position, which are not its primary roles.

Explanations: The ruler in a word processor is primarily used to set the boundaries or margins within which the content of the document is placed. This includes setting the left and right margins, top and bottom margins, and any additional guides for text alignment. The ruler does not directly measure the width of a table or show the cursor position, nor does it define the size of the page itself. It is a tool for defining the layout and positioning of content within the document.

Option Analysis:

Option A: The ruler does not show the position of the cursor in the document. This is typically indicated by the cursor itself or other indicators in the word processor interface.
Option B: The ruler is not used to measure the width of a table. Table dimensions are usually adjusted through specific table properties or by dragging the table borders.
Option C: The ruler does not define the size of the page. Page size is typically set in the document's page setup or layout options.
Option D: The ruler creates boundaries or margins inside which you add the contents of your document. This is the correct function of the ruler in a word processor.

Mnemonic: Remember: Ruler sets the "R"ules for your document's layout.

122. A map of a database is called a.....

Correct Answer: Correct answer is: (A) Schema A map of a database is called a Schema.

Exam Relevance: Database Management Systems, Computer Science Exams, Information Technology Exams

Difficulty: Easy

Concept notes: A schema in database terminology is a blueprint or a map that defines the structure and organization of the database.

Common Mistakes: Students may confuse a schema with data attributes or data entry errors, which are different concepts in database management.

Explanations: A schema is a formal description of the structure of a database, including the names of the tables, the fields in each table, and the relationships between the tables. It provides a clear and organized view of the database's design, making it easier to understand and manage the data.

Option Analysis:

Option A: Correct. A schema is the correct term for a map of a database.
Option B: Incorrect. Data attributes refer to the properties or characteristics of data, not the structure of the database.
Option C: Incorrect. Data entry errors are mistakes made during the input of data, unrelated to the database structure.
Option D: Incorrect. This option is not applicable as the correct answer is provided in option A.

Mnemonic: Schema: Structure, Map, Architecture

123. Microsoft Office Suite spreadsheet program is

Correct Answer: Correct answer is: (A) Microsoft Excel.

Exam Relevance: Microsoft Office Certification, High School Computer Science Exams

Difficulty: Very Easy

Concept notes: Microsoft Excel is the spreadsheet program within the Microsoft Office Suite.

Common Mistakes: Students may confuse Microsoft Excel with other Microsoft Office applications like Word or PowerPoint.

Explanations: Microsoft Excel is specifically designed for creating and managing spreadsheets, which include features such as tables, charts, and formulas. It is part of the Microsoft Office Suite, which also includes applications like Word and PowerPoint. The other options listed are not spreadsheet programs.

Option Analysis:

Option A: Correct. Microsoft Excel is the spreadsheet program in the Microsoft Office Suite.
Option B: Incorrect. Microsoft Word is a word processing program, not a spreadsheet program.
Option C: Incorrect. Microsoft PowerPoint is a presentation program, not a spreadsheet program.
Option D: Incorrect. This option is not applicable as Microsoft Excel is the correct answer.

Mnemonic: E for Excel, E for Excel, E for Excel, E for Excel.

124. ..... is the logical structure of the database.

Correct Answer: Correct answer is: (A) Schema.

Exam Relevance: Database Management Systems, Computer Science Exams, Information Technology Exams

Difficulty: Easy

Concept notes: The schema of a database defines its structure, including the tables, fields, relationships, and constraints.

Common Mistakes: Students may confuse the schema with the actual data stored in the database, which is not the case. The schema is the blueprint or design of the database, not the data itself.

Explanations: The schema of a database is the logical structure that defines how the data is organized. It includes the tables, columns, relationships, and constraints that govern the database. This structure is essential for understanding how data is stored and accessed within the database. Therefore, the schema is the correct answer as it represents the logical structure of the database.

Option Analysis:

Option A: Correct. The schema defines the logical structure of the database.
Option B: Incorrect. A key is a field or set of fields that uniquely identifies a record in a table, not the logical structure of the database.
Option C: Incorrect. This option is not correct as the schema is the correct answer.
Option D: Incorrect. This option is not correct as the schema is the correct answer.

125. What is the first stage in software development?

Correct Answer: Correct answer is: (C) System Analysis.

Exam Relevance: Software Engineering Exams, Computer Science Exams, IT Project Management Exams

Difficulty: Easy

Concept notes: System Analysis is the first stage in software development where requirements and problems are identified and analyzed.

Common Mistakes: Students often confuse System Analysis with Specification and Design, which is the second stage.

Explanations: System Analysis is the initial phase in software development where the needs and problems of the system are identified and analyzed. This stage involves gathering requirements, understanding user needs, and defining the scope of the project. It is crucial for laying the foundation for the subsequent stages of software development.

Option Analysis:

Option A: Specification and Design is the second stage, where detailed specifications and design of the system are created.
Option B: Testing is a later stage where the developed software is tested for functionality and bugs.
Option C: System Analysis is the first stage where requirements and problems are identified and analyzed.
Option D: Maintenance is a post-deployment stage where the software is maintained and updated.

126. Which utility protects against viruses?

Correct Answer: Correct answer is: (A) Antivirus.

Exam Relevance: CompTIA A+, Microsoft Certified: Security, Certified Ethical Hacker (CEH)

Difficulty: Very Easy

Concept notes: Antivirus software is designed to protect against viruses and other malicious software.

Common Mistakes: Students may confuse antivirus software with other utilities like file compression or search utilities, which do not have the capability to detect and remove viruses.

Explanations: Antivirus software is specifically designed to protect against viruses and other malicious software. It scans files and programs for known virus signatures and can detect and remove them. Other utilities like the Restore Utility, Search Utility, and File Compression do not have the capability to detect or remove viruses.

Option Analysis:

Option A: Antivirus software is designed to protect against viruses and other malicious software.
Option B: Restore Utility is used to restore files or system settings to a previous state, not to protect against viruses.
Option C: Search Utility is used to find files and folders on a computer, not to protect against viruses.
Option D: File Compression is used to reduce the size of files, not to protect against viruses.

Mnemonic: AV for Antivirus, V for Virus.

127. What is the purpose of a rectangle within a flowchart? *

Correct Answer: Correct answer is: (A) Process.

Exam Relevance: SAT, ACT, AP Computer Science Principles

Difficulty: Easy

Concept notes: In flowcharts, a rectangle is used to represent a process or an action that needs to be performed.

Common Mistakes: Students may confuse the rectangle with other shapes like the parallelogram, which is used for input/output operations.

Explanations: A rectangle in a flowchart signifies a process or action. It is used to denote a step in a procedure or a task that needs to be executed. This makes it distinct from other shapes like the parallelogram, which is used for input/output operations, or the diamond, which is used for decision points.

Option Analysis:

Option A: Correct. A rectangle represents a process or action in a flowchart.
Option B: Incorrect. A parallelogram is used for input/output operations, not a rectangle.
Option C: Incorrect. A diamond shape is used for decision points, not a rectangle.
Option D: Incorrect. An oval or rounded rectangle is used to denote the start or end of a flowchart, not a rectangle.

Mnemonic: Rectangles represent Routine tasks.

128. The third stage of the project life cycle is.....

Correct Answer: Correct answer is: (B) Execution.

Exam Relevance: PMP, CAPM, PRINCE2

Difficulty: Moderate

Concept notes: The project life cycle typically consists of four main stages: initiation, planning, execution, and closure and evaluation. The third stage is execution, where the project plan is put into action.

Common Mistakes: Students often confuse the order of the stages or mix up the activities associated with each stage.

Explanations: The third stage of the project life cycle is execution. During this phase, the project plan is implemented, and the project team works to achieve the project objectives. This stage involves the actual work of the project, including tasks, deliverables, and milestones as outlined in the project plan.

Option Analysis:

Option A: Closure and evaluation is the final stage of the project life cycle, where the project is concluded and its outcomes are assessed.
Option B: Execution is the correct answer as it is the third stage where the project plan is implemented.
Option C: Planning is the second stage, where the project plan is developed and detailed.
Option D: Initiation is the first stage, where the project is defined and approved.

Mnemonic: IPEE: Initiation, Planning, Execution, Evaluation

129. Which unit controls the movement of signals between CPU and I/O?

Correct Answer: Correct answer is: (A) Control Unit.

Exam Relevance: Computer Architecture, Digital Systems, Computer Organization

Difficulty: Easy

Concept notes: The Control Unit is responsible for managing the flow of data and instructions between the CPU and I/O devices.

Common Mistakes: Students may confuse the Control Unit with the Memory Unit, which is responsible for storing data rather than controlling its flow.

Explanations: The Control Unit is the part of the CPU that directs and coordinates the operation of the computer. It controls the movement of signals between the CPU and I/O devices by generating control signals that dictate the sequence of operations. The Memory Unit, on the other hand, is responsible for storing data and instructions, not for controlling their movement. Secondary Storage is used for long-term data storage and does not control signal movement. Therefore, the Control Unit is the correct answer.

Option Analysis:

Option A: Correct. The Control Unit manages the flow of data and instructions between the CPU and I/O devices.
Option B: Incorrect. The Memory Unit stores data and instructions but does not control their movement.
Option C: Incorrect. Secondary Storage is for long-term data storage and does not control signal movement.
Option D: Incorrect. The Control Unit is the correct answer.

130. Which of the following is capable of reading characters written with magnetic ink on a paper?

Correct Answer: Correct answer is: (B) MICR.

Exam Relevance: Banking Exams, IT Exams, Competitive Exams

Difficulty: Easy

Concept notes: MICR stands for Magnetic Ink Character Recognition, a technology used to read characters written with magnetic ink on documents such as checks.

Common Mistakes: Students may confuse MICR with OMR (Optical Mark Recognition), which reads marks made by pencils or pens, not magnetic ink.

Explanations: MICR is specifically designed to read characters written with magnetic ink, making it the correct choice for this question. OMR and Optical Bar Code Readers do not have the capability to read magnetic ink.

Option Analysis:

Option A: OMR is used for reading marks made by pencils or pens, not magnetic ink.
Option B: MICR is the correct choice as it reads characters written with magnetic ink.
Option C: Optical Bar Code Readers read barcodes, not magnetic ink characters.
Option D: This option is incorrect as MICR is the correct answer.

Mnemonic: Magnetic Ink, MICR, Check Reader

⬅ Previous SetSet 13Next Set ➡

3 thoughts on “Information and Communication Technology MCQ - Set 13”

Peter Ross April 8, 2020

The MCQ is quite entertaining and will help in increasing knowledge also.
Reyaz Ahmad khan December 26, 2020

plz help me in regard with current Affairs
Eshita Nandpal April 11, 2021

Plz give make a part of unit wise

3 thoughts on “Information and Communication Technology MCQ - Set 13”

Leave a Reply