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 is the software that resides on a single computer and does not interact with any other software installed in a different computer?
[A] Embedded Software
[B] Stand Alone Software
[C] Real time software
[D] All of the Above
Show Answer
Correct Answer: B [Stand Alone Software]
Notes:
Standalone program is one that run as a separate computer process, not an add-on of an existing process. It is an application, which can be run without the need for installation procedure.
22. Which of the following graphs tell us the correct and appropriate way to determine the deadlock situation occurrence?
[A] Starvation Graph
[B] Resource Allocation Graph
[C] Inversion Graph
[D] All of the Above
Show Answer
Correct Answer: B [Resource Allocation Graph]
Notes:
A resource allocation graph tracks which resource is held by which process and which process is waiting for a resource of a particular type. It is very powerful and simple tool to illustrate how interacting processes can deadlock.
23. Which of the following are the features of a Spreadsheet?
[A] Layers and Lines
[B] Rows and Columns
[C] Layers and Planes
[D] Height and Width
Show Answer
Correct Answer: B [Rows and Columns]
Notes:
A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. The program operates on data entered in cells of a table.
24. Which of the following is the location information application software?
[A] MATLAB
[B] Google
[C] ArcGIS
[D] Win
Show Answer
Correct Answer: C [ArcGIS]
Notes:
ArcGIS is a geographic information system. It is used for working with maps and geographic information. It is used for creating and using maps, compiling geographic data, analyzing mapped information etc.
25. What is full form of the YAGNI principle used in software system designing?
[A] You are not gonna need it.
[B] You are going not into it.
[C] You are gonna need it.
[D] You aint get to know it.
Show Answer
Correct Answer: A [You are not gonna need it.]
Notes:
You aren’t gonna need it or YAGNI is a principle of extreme programming that states a programmer should not add functionality until deemed necessary.
26. What is the name given to any software that is included with a new computer, hardware, or other software program?
[A] Bundled Software
[B] Pre-installed Software
[C] Both a and b
[D] Free Software
Show Answer
Correct Answer: C [Both a and b]
Notes:
Bundle ware, pre-installed software, Bundled software is any software that is included with a new computer, hardware, or other software program. Bundled software is included at no additional cost to the user.
27. What is the name given to the skilled and trained professional who directs all activities related to an organization’s database?
[A] System Administrator
[B] System Manager
[C] Database administrator
[D] Database Manager
Show Answer
Correct Answer: C [Database administrator]
Notes:
A database administrator is a specialized computer systems administrator who maintains a successful database environment by directing or performing all related activities to keep the data secure.
28. Which of the following are the examples of ORDBMS?
[A] PostgreSQL
[B] Greenplum
[C] SQL Server
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Examples of ORDBMSs include PostgreSQL developed by the PostgreSQL Global Development Group,Oracle Database by Oracle Corporation, Informix by IBM,SQL Server by Microsoft and Greenplum Database by Pivotal Software etc.
29. What is the full form of DHCP?
[A] Dynamic Host Configuration Protocol
[B] Destined Host Configuration Protocol
[C] Data Hosting Central Protocol
[D] Dynamic Housing Central Protocol
Show Answer
Correct Answer: A [Dynamic Host Configuration Protocol]
Notes:
DHCP stands for Dynamic Host Configuration Protocol. It is a client/server protocol that automatically provides an Internet Protocol host with its IP address and other related configuration information.
30. Which of these has the highest transmission capacity?
[A] Twisted pair cables
[B] Coaxial cables
[C] Optical fibers
[D] All have the same
Show Answer
Correct Answer: C [Optical fibers]
Notes:
Optical fibers have around 26,000 times more transmission capacity than twisted-pair cable and Coaxial cables have around 80 times more transmission capacity than twisted pair cables.