Computers and IT MCQs
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2024-2025. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
21. Which of the following clearly defines the Ripple effect?
[A] It is the ability of software systems to react appropriately to abnormal conditions.
[B] It is a phenomenon where a change in one piece of a software system affects other area of the
[C] It is the process of adapting generalized components to various contexts of use.
[D] All of the Above
Show Answer
Correct Answer: B [It is a phenomenon where a change in one piece of a software system affects other area of the]
Notes:
Ripple effect states that a change to a single variable will have effect on the rest of a program. It provides a measure of the program’s complexity.
22. Which of the following is the term used to describe software that is pre-packaged by the developer of the product?
[A] On-the-shelf
[B] Pre installed
[C] Off-the-shelf
[D] Both b and c
Show Answer
Correct Answer: C [Off-the-shelf]
Notes:
Off-the-shelf is a term used to describe software or hardware that is pre-packaged by the developer of the product. For example, Microsoft Office is a Commercial off-the-shelf product that is a packaged software solution for businesses.
23. What does the SCCM stands for?
[A] System Center Configuration Manager
[B] Software Center Configuration Manager
[C] Software Configuration Checking Manager
[D] None of the Above
Show Answer
Correct Answer: A [System Center Configuration Manager]
Notes:
SCCM stands for System Center Configuration Manager. SCCM is a software management suite provided by Microsoft that allows users to manage a large number of Windows based computers.
24. Which among the following are the database languages?
[A] Data Definition Language
[B] Data Manipulation Language
[C] Data Control Language
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
There are many types of Database Languages. A few among them are – Data Definition Language. DDL stands for Data Definition Language, Data Manipulation Language, Data Control Language etc.
25. Which language is used to make changes made by the DML statement?
[A] Data Definition Language
[B] Data Control Language
[C] Transaction Control Language
[D] Structured Query Language
Show Answer
Correct Answer: C [Transaction Control Language]
Notes:
Transaction Control Language is used to run the changes made by the DML statement.(TCL) commands are used to manage transactions in the database.
26. ACID is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures etc.What is the full form of ACID?
[A] Aquired Consistency In Database
[B] Atomicity, Consistency, Isolation, Durability
[C] Atomicity,Control,Isolation,Dependency
[D] Atomicity,Concurrecny,Isolation,Durability
Show Answer
Correct Answer: B [Atomicity, Consistency, Isolation, Durability]
Notes:
Andreas Reuter and Theo Harder coined the acronym ACID for Atomicity, Consistency, Isolation, and Durability. In the context of databases, a sequence of database operations that satisfies the ACID properties is called a transaction.
27. In the OSI model, Bridging is performed in which of the following layers?
[A] Layer 7
[B] Data Link Layer
[C] Session Layer
[D] Transport Layer
Show Answer
Correct Answer: B [Data Link Layer]
Notes:
In the OSI model, bridging is performed in the data link layer. A network bridge is a computer networking device that creates a single aggregate network from multiple communication networks or network segments.
28. Which of the following device distributes network traffic across a number of servers?
[A] IDS
[B] Load Balancer
[C] Switch
[D] Hub
Show Answer
Correct Answer: B [Load Balancer]
Notes:
A load balancer is a device that acts as a reverse proxy and distributes network or application traffic across a number of servers. Load balancers are used to increase capacity and reliability of applications
29. What is the name given to the device that converts between two different types of transmission for interoperation?
[A] Bridge Router
[B] Protocol Convertor
[C] Multilayer Switch
[D] Hub Jointer
Show Answer
Correct Answer: B [Protocol Convertor]
Notes:
A Protocol Converter is a device used to convert standard or proprietary protocol of one device to the protocol suitable for the other device or tools to achieve the interoperability.
30. What will be the bandwidth of a periodic signal if it is decomposed into five sine waves with frequencies of 100, 300, 500, 700 and 900 Hz?
[A] 900 Hz
[B] 100 Hz
[C] 500 Hz
[D] 800 Hz
Show Answer
Correct Answer: D [800 Hz]
Notes:
Bandwidth = Highest frequency – Lowest frequency. In this case, bandwidth will be equal to 900Hz-100 Hz i.e. 800Hz.
